Update table from combo box

  • Thread starter Thread starter John
  • Start date Start date
J

John

Is there a way to automatically update the information in
a table when selecting it from a combo box on a form
without closing the form. It is a single record (default
values record)? Also once the table is updated, how can
the subforms automatically update their information once
the change is made to the table record?

Thanks,
John
 
you could use the exit event of the control to set the dirty property to
false
Private Sub MycboControl_Exit()
Dirty = False
End Sub
this effectively saves the current record.
HTH
 
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

Need combo box to refresh when moving to new record 2017 1
Sort form records by field looked up in another table 1
Requery combo box in subform 5
Update Table via Code 3
Prevent duplicate selection from combo box on continuous form 4
Using combo box when adding records to continuous form 1
Auto Populate a Field 1
Using Combo Box to select records for update 1

Back
Top