clckwrkorange
asked on
showing dbgrid fields
I have an inventory database which has a list of items, such as CPU, Monitor, Keyboard, Mouse, etc. Each of these items have a location, owner, office, item and make field which they are belong to. I would like to be able to Pick out an item, such as CPU and only show the CPU's whose make is Dell. What kind of code would I use that would only display the CPU's that are made by Dell, etc.
ASKER
I do not know how to declare a recordset
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
To that recordset object you pass the following query,
"SELECT fieldlist FROM tablename WHERE item = """ & control.text & """ and make = """ & Control1.text & """"