Control the Sub form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

All,

I have a sub-form that I use to update one of my table. This function is
really handy but I want to control the way it updates the table. In other
words, is there any way I can set a button and the changes in the sub-form
will update in the table only if the user clicks the "Update" button? I would
appreciate any help.

Thanks in advance!
 
That's possible, but you must unbind the subform from the table, and all the
controls from their associated fields. The you must use code to write each
value to the table. The best way to do this is to use 2 subforms, 1 of which
is unbound, and the other as it is now, but locked so that you can't add
records.
 
Back
Top