Help with Combo Box

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

Guest

Within my subform I have a combo box that looks up fields and populates the
rest of the fields in the subform

ID
SELECT [Sales Items].[ID], [Sales Items].[ITEM], [Sales Items].[Price],
[Sales Items].[SALE_PRICE], [Sales Items].[ONLINE_DISC] FROM [Sales Items];

This is great for 99% of the time. The procedure is just entering a code
from a Label on an item, however say if the Code is missing from the item
we're trying to look up this won't work.
What I'd like is in addition to the combo box another field or button that
can search [Sales Items].[ITEM] FROM [Sales Items] and populate the fields too

Any suggestions?

Thanks in advance
 
Hi Shawn,

Assuming your first combo box is Bound to the Code, and which displays the
Code after selection, add another combo box selecting the first two columns.
Also bind it the Code field, but in this one, set the Column Width of the
first column to 0". Now you can look up by the Description. Since the Bound
value is really the code, the code will show up in your first combo box, and
thus populate the other controls.

Hope that helps.
Sprinks
 
Thanks so much Sprinks, in this case the simple was better!

Shawna

Sprinks said:
Hi Shawn,

Assuming your first combo box is Bound to the Code, and which displays the
Code after selection, add another combo box selecting the first two columns.
Also bind it the Code field, but in this one, set the Column Width of the
first column to 0". Now you can look up by the Description. Since the Bound
value is really the code, the code will show up in your first combo box, and
thus populate the other controls.

Hope that helps.
Sprinks

shawna@happyharborcomics said:
Within my subform I have a combo box that looks up fields and populates the
rest of the fields in the subform

ID
SELECT [Sales Items].[ID], [Sales Items].[ITEM], [Sales Items].[Price],
[Sales Items].[SALE_PRICE], [Sales Items].[ONLINE_DISC] FROM [Sales Items];

This is great for 99% of the time. The procedure is just entering a code
from a Label on an item, however say if the Code is missing from the item
we're trying to look up this won't work.
What I'd like is in addition to the combo box another field or button that
can search [Sales Items].[ITEM] FROM [Sales Items] and populate the fields too

Any suggestions?

Thanks in advance
Click to expand...
Click to expand...
 
Back
Top