Bound Controls Update Tables on Form Close

[sethdromgoole]

Hello,

I have created an access form with bound controls to a table. I want the users to be able to change the controls' values, however, I do not want the controls to automatically update the table on the form close. Rather, I want the users to click a 'Save' button to update the tables. Any suggestions on how to accomplish this?

Thanks,

Seth Dromgoole

 

[earthandfire]

First thought is don't use bound controls - populate the form through code.

Hope this helps.

 

[sethdromgoole]

The problem with this method is that the controls are all combo boxes, and populating through code causes the form to load very slowly, especially when being used by field agents who have low bandwidth connections to the servers. The bound controls increase the speed of form loading.

-Seth

 

[KenReay]

How about

If me.Dirty Then
docmd.runcommand acCmdUndo
end if

in On form close event,

if the user has first saved the updates, then they are saved, if not, they are undone

Just another point, updates are also autimatically saved when you move to a different record, you may need to handle that too

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK