Combo Box multiple colums as one colum in combo

[misslee1888]

Hello

I have had a look through the forum and I am not sure if this can be done. I have a table. i.e. with columns Decsription 1, Cost 1, Description 2, Cost 2 Description 3, Cost 3 description 4, cost 4 etc.

I am looking to try and gave a combo box show this information as follows. I.e

Colum 1 on Combo; Column 2 on Combo

Description 1 Cost 1
Description 2 Cost 2
Description 3 Cost 3
Description 4 Cost 4

I want to be able to auto fill some fields on a form based on the combo box selection.
Has anyone done this before and can it be done.

Thanks

 

[Sergeant]

I don't know of a way to do that without building the recordset in VBA.

My observation on your dilemma:
In 99% of my experiences where something *seemed* or *was* impossible, I have found that I was trying to force a poor table structure into a very capable application.
Now, I have no idea what your app does or why you have your fields set up that way, but I'd propose that fixing the table structure would solve your problem. Merely food for thought...it's your database.