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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Form Refresh 1
Access Sub form opens before the main form in MS Access 0
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Access Daily Entry with multiple entries per field 0
Access Control on subform / combo box requesting parameter 0
Edited data record to be inserted as a new data record under the same PO number in Microsoft Access 0
MS Access Sub Form 1
Requery a sub table 1

Back
Top