Creating input box

[jamiedmiller]

I'm lost.

I am developing a database of printer info. Here's what I need.

I need to be able to pull the info on a specific printer and then search the database by that printer's location to find other printers with the same location value.

Any ideas?

 

[kerrigirrl]

i would do it in 2 forms. the first form is where you would enter the printer id or some field that uniquely identifies the printer. When you press enter, have it open a second form that's linked (finding specific data), and this will show you the information about the printer selected. On this form, you could also have a subform with a query that shows all printers by that location (use location field on the form in query).

i think you would need two tables in order to link the forms. maybe one with id and printer description, the other with id and all other information.