List box populate based on combo box

W

Warman

I have a combo box that is based on a table. The three fields that are
selected should generate a listbox based on a query. The query filters the
the selection.

I can't get any info in the list box. The query works and the listbox
contains the column names but no records.

Am I not using the right fields for the query or not doing a refresh?? I am
lost - been at this for several hours - read all the posts - I know it should
be simple.

Thanks :(
 
J

John W. Vinson

I have a combo box that is based on a table. The three fields that are
selected should generate a listbox based on a query. The query filters the
the selection.

I can't get any info in the list box. The query works and the listbox
contains the column names but no records.

Am I not using the right fields for the query or not doing a refresh?? I am
lost - been at this for several hours - read all the posts - I know it should
be simple.

Thanks :(

A combo box will not "generate" a listbox. Your question is unclear; what is
the SQL view of the query? What are the RowSources of the combo and the
listbox? How are you selecting "three fields" from a combo (since a combo can
have only one value)? Do you have any VBA code or macros (e.g. requerying the
listbox in the combo's afterupdate event)?
 

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

Top