MS Access Help

[Martynt74]

My dads struggling with a form on a database and given he's more capable in Access than i am i decided the best solution was to ask on here!

I've uploaded a word document where he states the issue and then the database on my onedrive which should be shared using the following link.

https://1drv.ms/f/s!AskUp4cdx3krjVL4g67eW_Dohpz-

His instructions don't read well to me so if anyone struggles i'll try and get him to clarify.

 

[Martynt74]

Having had a bit of a play. The issue seems to be that on form “frm_prop_vales” he wants to be able to enter values into the yellow cells to update the table but they seem to be locked.

On form “frm_prop_values_updatable” which looks to be the same form the cells are unlocked and editable.

 

[Martynt74]

Just saw this, the main issue is understanding my dad!

It does seem to be with the way that he's calculating things as in the second example which doesn't work the tables aren't actually linked.

I think that he'd be better doing his calculations elsewhere and then just using the first example to show info on the form.

He's said.

This one works

"I am only showing the K values for the calculated and proposed and that means I can update the yellow cells"

This one doesn't

"If I calculate the SL% using the modified query I get to show the SL% but cant update the yellow cells"

For reference the K values he mentions are the service levels (SL) values