G
Guest
I have a main form called frmCustEntry which has a combobox called
cboCustFind. on the on-click event I have a module run that populates the
form with the customer information...name, address, etc.
Well I have a subform on this main form called subContactNames. Which has a
listbox in it that is unbound. It pulls the contact names for the
company....which there could be several. I want to be able to click on
multiple names and store them in a separate table after I've chosen the
names. My problem is the list box.
I need it to populate with the values equal to the cboCustFind. I put the
codes in the query and the subform and it stands alone works great. But when
I put it into the main form it doesn't because it needs to be refreshed
somehow after I've chosen the right value from cboCustFind.
How do I get this subform refreshed at the right time?
I tried adding this after the call for the module in the onclick event in
cboCustFind
Me.subContactNames.requery
cboCustFind. on the on-click event I have a module run that populates the
form with the customer information...name, address, etc.
Well I have a subform on this main form called subContactNames. Which has a
listbox in it that is unbound. It pulls the contact names for the
company....which there could be several. I want to be able to click on
multiple names and store them in a separate table after I've chosen the
names. My problem is the list box.
I need it to populate with the values equal to the cboCustFind. I put the
codes in the query and the subform and it stands alone works great. But when
I put it into the main form it doesn't because it needs to be refreshed
somehow after I've chosen the right value from cboCustFind.
How do I get this subform refreshed at the right time?
I tried adding this after the call for the module in the onclick event in
cboCustFind
Me.subContactNames.requery