problem saving

[gersheff]

For some reason i am having trouble saving the data in the form to its appropriate table. I have a macro setup so that when i am done with a form i click a button wich saves that form and opens a new 1. however if i were to check the table it is supposed to be saving to the data is not there. The data only appears there after i close that original form (I don't want to do this). Any ideas why this would happen?

thank you.

 

[ColinEssex]

Is the form bound to a query / table?

Col

 

[gersheff]

yup the "record source " row has got something in it. I found that if i go to the next record it saves it also, so i created the macro to do that for now.

 

[Rich]

The correct method is DoCmd.RunCommand acCmdSaveRecord