Combo box question. An easy one.

[HandJT]

Does anybody know how to add fields to a combo box, then display the information when an option is selected?

 

[TheAceMan1]

How are ya HandJT . . . . .

If base the [blue]RowSource[/blue] of the CB on a query or SQL.
[quoteHandJT][blue]then display the information when an option is selected?[/blue][/quote]
Depends on what ya have in mind. Do you want to goto a record, post specific data from a specific source . . . . what?

See Ya! . . . . . .

 

[HandJT]

Well, I have a search form that a user can search for records four different ways. DWG, RMA, JOB, and NCT. They are all numbers. A user types in a number under, let's say DWG and Access displays that record on a Results form. Everything works just fine, except that there could be more than one record with that DWG number in it. So, I thought of putting a combo box on my results form with the record number displaying seems how this is unique to each record. Then I wanted to have access list all the records that this particular DWG number is in. And then I wanted Access to display the information from the record the user chooses from the combo box. It has me in a jam, cuz I know I'm missing a syntex somewhere or something, so a sample code would be nice to compare mine to or a common way of doing this. Any ideas?