I have a table with about 8 fields displaying information pertaining to 5
different types of equipment (ex: "equipment type"; "serial number";
"location"; "date adjusted"; "time adjusted")
I want to set up a form in which people from my company can search for a
specific piece of equipment based on equipment type, location, and date
using
3 different combo boxes, and having the results displayed in a table in a
subform.
one initial problem I had was when I tried linking the combo box to the
"equipment type" field, but because there are reapeating entries (there
are
only 5 different types, and they all repeat ex: LPRM, APRM, SRM, IRM,
there
are about 20 LPRM, 10 APRM, etc) when I went to view my form and try the
combo box, the available options were LPRM repeated 20 times, etc.
I am very new to access and don't know how to link the combo box selection
to filter the subform data, especially if I'm typing in the values for the
combo box to choose from instead of linking them to a field on my table.
I JUST learned what a query is, if that gives you an idea of my Access
level. I am very competent in Excel, and have done some Macros and Visual
Basic before in Excel
I have Access 2003
|
