Access Form

[Twee]

Hi,

I need help with my MS Access form. I have a project where there are 30,000
file #s in excel and I have already exported it into Access. And all these
files are in 4 catagories (sample1, sample2, sample3, sample4) which I alredy
already created forms in Access. Now, I want employees where they take actual
physical files and go into the form and type the file # and and edit the form.
I want Access to read the File # if is sample1 or sample2 or sample3 or
sample4 and open that particular sample.

Please help me.

 

[Undrline]

When you create the form, create a dropdown (combo) control. In the
properties, under the Data tab, click in the Record Source, then, click on
the ... button that appears. Create a query that will display your
categories that you want the user to be limited by. Then, create a subform
linked to the value of that combo box. So, then the user will choose the
category, and only be able to enter values for that category in the subform.