Restrict values in combo via subform

  • Thread starter Thread starter Piers 2k
  • Start date Start date
P

Piers 2k

Hi folks,

Main form - Customers
Subform - Contact History (with appropriate link - all OK).
On subform there is a combo populated from a third table called Contacts.
This has a list of all contacts in a company (linked via CustID).
I need the combo to filter down and display only the Names for the current
Customer being viewed.

I've added in [txtCustID] into the Row Source of the combo, and it works
fine for the first record, but after changing records, it doesn't seem to
update.

Any ideas?

TIA<
Piers
 
In order to keep the combo "in synch" with your subform customer field,
you'll need 2 coded events.
On the OnCurrent event for each form...
cboCustomer.Requery
and
On the AfterUpdate event of Customer...
cboCustomer.Requery

Now, as you come into each subform record the combo will resync, and if you
happen to enter or change Customer on a record it will also sync.
hth
Al Camp
 
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

Append Records from a subform to a new record 1
Combo in subform 3
Update Table via Code 3
Requery combo box in subform 5
Refreshing a subform 2
Pass Subform filter to subform in report 0
Subform combo box selection effects all records 3
Combo lookup on subform 2

Back
Top