Form or Make table Query?

  • Thread starter Thread starter Maxwell
  • Start date Start date
M

Maxwell

Hello,

Trying to do the following...
In FORM's I created a form to poplulate an existing TABLE
which I call my item cross reference. (this cross
reference has the specs to a list of items such as UPC,
retail price, cost, if it was an import or domestic
product, etc. )

In Forms, I have it so that you would need to hard key the
item nunmber or UPC in, however, in some cells i have a
drop down box so you can only pick the provided choices.
In my case, my dropdown box give a choice of
either "DOMESTIC" or "IMPORTED".
How do I make it so the if either is picked, that choice
will be plugged into the cell in my TABLE cross reference?

Is it a vlookup, and if so, how do I do that?

The drop down boxes are linked to another TABLE that has
DOMESTIC and IMOPORT linked to it.


Please help!!!!!
 
Assuming that the form's underlying Record Source is the
table into which you wish to store the value selected in
the combo box, all you need to do is to change the Control
Source property of the combo box to the name of the
table's field. This field, and the data you're trying to
store, must, of course, be the same type.

HTH
Kevin Sprinkel
 
Back
Top