Refreshing a list box on a subform

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

I am using Access 2000. I have a form (FormA) and a subform (SubformA). The
subform is a list of customers and it is based on a query of the customers
table. On the form is a button that goes to a completely separate form
(FormB) where multiple customers can be selected from a list box. The
customers that are selected from the list box have a boolean field in the
customers table set to True. On leaving FormB and returning to FormA, I want
the customer list in SubformA to be updated to those that were selected on
FormB. I can't figure out how to get the subform to reexecute its query to
refresh its list of customers. Can someone please help me? Thanks!
 
I believe you want to put his in the "On Close" event of FormB:

Me.CustomerList.Requery

Regards,
James C.
EDI Analyst
 
Whoops! Slight error in my code. It's something like...

[Forms]!SubformA.CustomerList.Requery
I believe you want to put his in the "On Close" event of FormB:

Me.CustomerList.Requery

Regards,
James C.
EDI Analyst
I am using Access 2000. I have a form (FormA) and a subform (SubformA). The
subform is a list of customers and it is based on a query of the customers
Click to expand...
[quoted text clipped - 5 lines]
FormB. I can't figure out how to get the subform to reexecute its query to
refresh its list of customers. Can someone please help me? Thanks!
Click to expand...
Click to expand...
 
Back
Top