Look-up form or report

M

Mike D.

Hi. I have a table that has the following fields: Part Number, Location.

I would like to create a simple form or report where the user would be
prompted to enter the part number and the form would then give the location
of the part. I would then want the user to be able to perform another search
if they wanted to.

What would be the best way for me to go about this?

Thanks!

Mike.
 
R

rowiga

Create your form with your table as the record source. Use the wizard to
create a combo box in the header of the form to "search for records on my
form".
 
Top