Look-up form or report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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".
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple Search Command criteria in a form 2
unconcatenate from form into table? 2
report after parameter form 3
Access How to check that the value of a field in a new record is not present in 2 fields of the table? 0
Error Message for REPORT if wrong number entered 2
Auto-Populate Form Field 1
Can I use "Filter By Form" to build a neat search form? 4
Open Report with Criteria From Form 6

Back
Top