requery a combo box that is based on a query

  • Thread starter leeandgracebest via AccessMonster.com
  • Start date
L

leeandgracebest via AccessMonster.com

I have a combo box that is based on a query. My query contains the criteria
" [Forms]![frmCLIENTS]![ClientID] " where the main form contains the ID of
the Client and the subform contains the foreign field ClientID from the table
"Contacts" and they are joined in the query. If I run the query, I need to
enter a paramenter to return a list of contact names.
In my subform I have my combo box where I want to be able to pick a contact
from a list that is displayed for a particular clientID. The combo box
returns a list that matches the client ID for the first Client chosen, but it
is the same for all other clients. I have tried to requery the list by
placing "Me.ContactList.requery" in the AfterUpdate property in the combo box
but it doesn't work.
Any help would be greatly appreciated.
Thx. Lee
 

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

Clearing combo boxes and a text box 2
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Creating a Search using a combo box and then creating a report. 4
Link a text box based on drop down box with four options MS Word 365 0
how to requery on new record continuous form 1
List box populate based on combo box 3
show 2nd field when combo box choice is made 4
Requery Combo box in popup form 2

Top