Autopopopulate combo box

M

Mike_can

Hi eveyone..again...

I ha ve a form with several fields.. among them the user has to fill 3 names
(n1, n2, n3), is there a way to autopopulate a combo box with these fields? i
knos it may be redundant, but i want the user to chose among these 3 names,
and later on not have any mistyping errors...

thanks
 
J

Jeff Boyce

How will Access know which three names to fill with?

Do you have three combo boxes, or do you use one combo box three times?

Can you provide a bit of data in the way of an example?
 
M

Mike_can

Hi Jeff.
this is s supplier comparison.So first the users have to enter the 3 company
names Company A, Company B, And Company C, in the fields CN1, CN2 and CN3.
Later on, at the end of the form i want the user to select (using a combo
box to avoid mistyping errors) the company that they consider is the best
supplier .

Thanks
 
J

Jeff Boyce

Mike

Another approach might be to take what they've already done and use it. If
they've selected a Company in each of your combo boxes, and those companies
still are displayed, what about double-clicking the combobox of the one they
select?

Or adding three radio buttons, one for each -- the one selected is the one
they consider the best.

Good luck

Jeff Boyce
<Access MVP>
 
G

Guest

Mike, one other option is to create a Table with those
companies and point the Combo (drop) to that table and
populate the fields on your primary table from your
selection. You may identify a default value, or just
leave blank until one is selected.

SR Bandy
 
Top