Update Checked box

  • Thread starter Thread starter Milindra
  • Start date Start date
M

Milindra

I've created a form that have four subforms on it. What
type of code that I need to have in order to keep it
update from one subform to another subform. Now I need to
close the form and reopen in order to update it.

For example:
I have a check box on subform in oder to select who will
be in the meeting, but when I went to meeting subform(
under the same main form), it suppose to add the one that
I just clicked on it, but it didn't. Please help me out.

Milindra
 
Milindra said:
I've created a form that have four subforms on it. What
type of code that I need to have in order to keep it
update from one subform to another subform. Now I need to
close the form and reopen in order to update it.

For example:
I have a check box on subform in oder to select who will
be in the meeting, but when I went to meeting subform(
under the same main form), it suppose to add the one that
I just clicked on it, but it didn't.
Click to expand...


To get an open form or subform to reflect data changes that
have been made since the data was originally loaded into the
form, use the Requery method in the appropriate event. For
example, if you need to see the changes immediately when a
user clicks on the check box, then use the check box's
AfterUpdate event:

Me.Dirty = False ' Save change to table
' Force other form to reload its data
Me.Parent.anothersubform.Form.Requery
 
Back
Top