Need to keep information without getting off of the space

[dakcg]

Hi all, I have a form with the control buttons in the footer. My problem is when the user fills in the last box that they want to and then hit the control button in the footer that last bit of information does not come thru. I've tried a DoCmdRunCommand acCmdSaveRecord but it doesn't seem to be working. Any help?

 

[neileg]

Obviously the last field is not being saved because it still has the focus. What is the command button doing?

 

[dakcg]

Hi Neil, That button runs a macro that (1) Deletes a temp table, (2) Recreates the temp table with current info, and (3) Opens a form based on the temp table.
I have another form that is basically the same set up (info in the body and button in the footer) using checkboxes that works fine with DoCmdRunCommand acCmdSaveRecord but on that form there is only one button. On my problem form there are three buttons, could that be the problem?

 

[neileg]

Do you explicitly close the form in your code? If you do, this will save the last field, otherwise it is left 'hanging'.

 

[dakcg]

Thanks Neil, That was the problem. I had that form closeing a little further downstream. Thanks for your help.