Bind list box column to a table field

[unknown1]

@ gunilla...
my combo box/list box has many columns and all of them should be linked with the diffrent table fields...

@ vbainet...
i removed all links but how can i then bind the coulumns of the form to the table?

 

[vbaInet]

Now that you understand how to build subforms, for you to be able to have a link between your subform and your table this is what you do:

1. Create a form that is linked to your table, set it to datasheet.
2. Go back to your main form and create a subform, but this type select that form that you just created.

Done.

 

[Gunilla]

Sorry
I didn't read the full question. That's what you get when you are too eager. Glad you found your answer.
Gunilla

 

[unknown1]

i still cant get u...///sryyyyyyyyyyyy

 

[vbaInet]

I will repeat.

1. Create a form (not a subform, a form)
2. Make the record source of the form to be the Product table with all three fields.
3. Drop text boxes for each field onto the form (bound text boxes)
3. Set it to Datasheet view.
4. Call it Prod_Details
-----------------------------------

Now go back to your main form and do this:
1. Click your subform ONCE
2. Change the Source Object to Prod_Details from the list.