Form/Table AutoFill

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

Guest

I have a list of parts by different manufacturers. Each manufacturer has its
own "reference" number. How can I get the form to fill in this number from a
query/table automatically when the manufacturer's name is selected from a
list box?
 
I would suggest you create a separate table consisting of your vendors and
the reference number then create a relationship between your current table
and the new vendor information table. Then use a query to pull the
information in. Open both tables in the query screen. When you open both
tables in the query screen you will see the line for the relationship. Pull
the information that you need from your current table then pull the reference
number from you new vendor information table. Use this query to create your
form. This should do it.
 
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

Query question 8
HOW do I make selections and carry only those selections thru proc 1
Autofill form from linked table 3
update combo box on form close 1
Copying data from subform to main form 1
Filling in fields to a partially complete record in a table using a form 0
how can i use a combo box selection in a form to then autofill tex 1
Auto-Populate Form Field 1

Back
Top