Auto Populate from combobox but save in new table

[pfunk]

What I am trying to do is select a book from the comb box and have the other information auto-populate. That being said I also want it to save in the feedback table. I know this is duplicating data but it is what I need for stat purposes and exporting to excel later. I have attached photos to show the books table

the feedback form

and the feedback table

[pfunk]

I got it to work with a dlookup function!

[Missinglinq]

That's one method. The other would be to include the info in the Combobox and then assign it in the AfterUpdate event. To do this you'd simply

Set up your Combobox using the Wizard and include the Fields you need, from Left-to-Right.

If in the Combobox they appear as

Field1 | Field2 | Field3

the code would be

Private Sub YourComboBox_AfterUpdate()
   Me.txtField1 =  Me.YourComboBox.Column(0)
   Me.txtField2 = Me.YourComboBox.Column(1)
   Me.txtField3= Me.YourComboBox.Column(2)
End Sub

Notice that the column index is Zero-based.

Linq ;0)>