Combo Box Selection Comparing Value to Table

[Zephyx]

Okay so I have a search form I've set up, has an unbound text box that works perfectly, I can have all the results posting properly to my list box below. Now the issue I'm having when I make a selection from my combo box, the list box returns nothing. Now I know I need to do some setup in the background, just not sure how, here is what I'm working with.



2 Tables: 1) Referencing companies with autonumber label for normalization purposes
2) Equipment that has autonumber value in place of the company names

The form has you select via the company name, what I need it to do is take that selection, then cross reference it to the table to get the proper autonumber value so that as it searches my equipment table it will return only those with the user's selection acting as a filter.

Any help on how to go about this is greatly appreciated

[pbaldy]

Is this what you're trying to do?

Baldy-Cascading Combos

Using a listbox for the second combo doesn't change anything.

[Zephyx]

Unfortunately that's not it, however my manager actually just approached and said I can disregard the other box for now. But to give a better idea I'll attach a few screen shots to at least put my confusion into a more clear idea.

Pic1 is the form I've created with the user defining the first filter for their results, what I am wanting to do is make a selection from the combo box on the right, then take that name, and reference it to the table in Pic2 then return only the equipment that has the corresponding values from the ID box (on left) and the combo box.

[pbaldy]

I must be confused, because that sounds like the link. You choose Mustang CAT in the combo, and only records with Mustang CAT appear in the listbox?

[Zephyx]

Not at this time, when I make any selection right now it returns no results at all, the screen was taken before running the search again, the following pic illustrates. And honestly I doubt your confused so much as I am terrible at conveying my ideas in this scenario, I'm what is apparently referred to as a PICNIC or PEBKAC user.

[pbaldy]

Well, my link demonstrates 2 ways of doing that. Since you haven't shown how you're trying to do yours, I can't say why it comes up blank.

[Zephyx]

Annnnd I'm just realizing I apparently need to relearn how to read, thanks for the help and my apologies for being so difficult

[pbaldy]

No worries, we all have brain cramps.

Post back if you get stuck.

[Zephyx]

Okay, I think I know how to better explain what I'm trying to do now. So basically when you make a selection from the combo box I want that selection to act as a filter for the list box beneath it. However what I don't know how to do is to tell Access that when a user makes that choice, Mustang Cat for example, I want it to take that selection, take the reference number from the companies table (2 in this case), then proceed to search the equipment table using that value (2) and return only those results.

I just don't quite understand how to tell access to make that conversion. And I'm sorry if that link you've sent does in fact explain this, if that's the case then if you could give me a basic idea of how it works that would be greatly appreciated

[pbaldy]

Did you get this sorted out? Was the sample db of no help?

[Zephyx]

Sorry it took so long to respond, there are some days when I am unable to get online because I get sent out for service (I'm having to balance working on this db and operate as one of 2 field technicians for their equipment/vehicles) and I'm still working on it at the moment, I'll post back after I've done a bit more experimentation on my end