saving data without using Me.refresh

[303factory]

Hi

Is there a way to save any data changed to a bound subform without refreshing the master form? If you tick a few boxes on the subform then try close the main form there seems a problem with the data not being saved.

Me.mysubform.Refresh doesnt seem to be an option
Me.mysubform.Requery doesnt fix my conflicts

Refreshing the master form before I try close everything and move on fixes the problem, but refreshing the master form takes aaages becase it has about 20 subforms with images etc. Any ideas?

Thanks

303

 

[James Dudden]

Hi,
Have you tried adding a save command:

DoCmd.RunCommand acCmdSaveRecord

Regards
JD

 

[303factory]

Hi,
Have you tried adding a save command:

DoCmd.RunCommand acCmdSaveRecord

Regards
JD

Hmm I tried this and I'll still getting a problem, when you click a command button it should eventually close the form, first it should update the value of a bound combo box, but fails on this line of code that should do this.

Me.exhibitStatus = 6

'you cant assigne a value to this object'

Then all the 'enter a parameter' boxes appear as if you had a query missing data, then when you've cleared them you can start the code again and it is no longer stuck on the combo box line. If I do Me.refresh before the combo box update line it works fine. If you dont update the form manually before clicking the command button it doestn fall over

Has anyone encountered a similar problem?

 

[James Dudden]

Hi,
If you post your db I will take a look for you.
Regards
JD