Save data on form besides closing form

[mikepf]

I can update a table (dates)in a form then click on a button to execute a query but the new dates in the table are NOT used with the query. If I close the form and re-enter, the dates are then used with the form. If I click the SAVE button the dates are NOT saved in the table to then be used with the query. I have gone into properties and tried to do a Save Table(macro) on Data Change but no good. This has to be something simple but I cannot quite see it.

 

[GingerR]

In your button's OnClick event, first put

Docmd.RunCommand acCmdSaveRecord

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html

 

[mikepf]

Ginger,
I show a click event for the form but putting the line of code (I didn't change the code) in the click event didn't save the data before running the query. Any thoughts

 

[mikepf]

Ginger,
This is what the code looks like.

Private Sub Form_Click()
DoCmd.RunCommand acCmdSaveRecord

End Sub

 

[GingerR]

In your BUTTON'S OnClick event, not the Form's OnClick event. You said you have a button you click to run a query; put it in that button's code.

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html

 

[mikepf]

GingerR,
That did it! Thanks!!