Creating a form that will display records from a linked table

[timesscript]

Sorry that I'm no good at figuring out how to display my issue here. Below you see my form. The record source is currently a query that returns "inquirers" from a table of people. I have a list box that displays the names of all the inquirers, and after update will load the record of that name. What I want to add is another listbox, that once someone chooses a name, will populate with all the "inquiries" (Like tickets from a call center) that are under that name. I already have a separate table with inquiries that is related to the current table in a one-to many relationship (Many inquiries per inquirer). Then my ultimate goal is once they select the inquiry from the list box, that additional fields will fill with that inquiry information.



I realize that I may need to base my form on another query... or something... my mind is kind of blown right now trying to figure it out. I'm sure it's simple in the long run...

One problem is that if we change the record source to a query based on both the "inquirers" query and the "inquiries" table, we will end up with my existing list box displaying one line for every inquiry, instead of one for every inquirer, which will need to be fixed.

Please untangle my knotted-up mind!

[pbaldy]

If you want two listboxes, they would work the same as combos (as long as the first is single-select):

Baldy-Cascading Combos

[pbaldy]

I should have added that you could have a subform as well. Master/child links would keep it in sync with the main form.

[timesscript]

I don't want to go with a subform, but I went ahead and added both forms into my query, and used the GROUP by to make it so I only see one set of names in the first listbox. But I cannot seem to get anything to appear in the second listbox. Right now it is bound to the date field, and the first litbox afterupdate is supposed to requery it, but nothing appears. (WHat I want is you to choose the date and the appropriate inquiry will appear at the fields to the right.)

[pbaldy]

Hard to debug without knowing the row source, etc. Can you post the db here?

[timesscript]

It actually has no row source, and the control source is set to "inquiry ID"- the primary key field of the inquiries table.

I would have to clear out some real data I've been testing with to upload the database- based on what I've told you is there something I should try before I do that?

[pbaldy]

If the second listbox doesn't have a row source, why would anything appear in it? For a requery to work, it would have to have a row source query that referenced the first listbox.

[timesscript]

Yeah, I used a wizard and I see that that would not work. I do not know though how to create a query that references a listbox- can you give me an example of how that would work?

[pbaldy]

I did; the link in post 2.

[timesscript]

Ah. I was looking for a query that was saved as opposed to just SQL- but then I found out, and your example helped me out a lot! Thanks!

[pbaldy]

Happy to help!