Autopopopulate combo box

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

Guest

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
 
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?
 
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
 
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>
 
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
 
Back
Top