Limit Subsequent Records

[opostal]

I believe the answer is probably already here but I was not successful at drawing it out through my searches. What I have is a simple access database with the main table having 23 fields. I have a form that displays the fields and each field on the form is a combo box where the user simply chooses an item from the drop down box to search for records with that data in them. My currrent goal is to be able to go to one of the fields (usually one of the first 2 fields listed) and select a value. I would then like the remaining fields to only display items where the first value is equivalent.

The first three fields are customer name, location, and quantity. So essentially if I chose a customer name from the first field, I would like the remaining fields to only be able to display anything with that customer name. Additionally, should I choose a location in the field after the name, I would like the remaining fields to be locked in to only records that display the same customer name and location etc.

Once all the criteria is in I hit a search button on the bottom which displays a form of the record with a link to a file. This is why I want to do this from a form perspective vice queries

I know I can do this with a cumbersome query process but is there a simpler way to relate the fields so that I can accomplish this without the query process?

Thanks for any advice.

 

[vbaInet]

Sounds to me like cascading combo boxes. There are different approaches depending upon what object your combo boxes are placed. Are the combo boxes in a subform or a form?

 

[opostal]

The combo boxes are indeed in a form. I simply have a table and the form comes from the main table with all the data. I have made a simple query for each item and linked that to the combo box and then grouped them so there is only one entry of each type on the drop down box. So yes the combo box is in the form itself.

Thanks!

 

[vbaInet]

This is the sort of thing you could do:

http://baldyweb.com/CascadingCombo.htm

 

[opostal]

Yup that works thank you very much for your time. Took a little manipulation but it is now doing what I want. Thanks again!

 

[vbaInet]

Great. Glad that worked for you.

You're welcome.