Automatically filling text boxes

[chrisbird13]

I have a combo box for rooms: single, twin, double, suite, grand suite

This is found from a lookup table

In the next field on the lookup table is the cost per night for the room, how can i get the cost per night to automatically appear in a text box below the room type combo box.

I asked this the other evening and somebody said it was to do with making the table the bound source or something but i didn't understand.

An explanation would be great

Thanks

 

[RuralGuy]

Try something like this in the AfterUpdate event of the ComboBox:
Me.txtPriceControl = Me.ComboBoxName.Column(1) if the price is in the 2nd column of the ComboBox. Using your control names of course.