Filter by selecting from a combo box

[Khanh Pham]

I have two tables. One called CHECKINFO with two fields
in it. One is companynum and one is companyname (both
keys). The other table is COMPANY with the fields
companyID (autonum)which is key and companyname. It is a
one to many relationship. One being the company table. I
would like to create a form that would allow me to select
a companynum from a combo box and then filter only the
records that have that companynum and bring it up in the
form. What would even be nicer is after putting in the
companynum, a list comes up with all the valid Companyname
in a list so when I choose a particular Companyname, only
that record and all the information for that record show
up. Can someone help me please????? Thank you very much.

Khanh Pham

 

[Carlos Alberto-Brasil]

Sounds like you just need a basic combo box.
Create a regular form as usual and then go into design view and click
the combo box button. Choose option 3- "Find a record"
This will yield a drop down box. When you click the arrow and make
a selection, the full record of your choice with all the details
should appear.
Another alternative is to simply right click on the companyid field in
your form and apply a FILTER FOR condition. This will slap a filter
on all output displayed in your form. FOr example, a filter on the
state of Belaware will cause only Dleaware records to show in
your form. Likewise for companyid.

Carlos Alberto