display value from table on form

[mkphan]

I have a table called

ITEMS - which has the following fields:
item_id
description
price

A form is created with a combo box for [item_id]. I would like to display the description in a text box called "box_description" and display price in text box called "box_price".

Thanks ahead of time,

MK

 

[LonnieJohnson]

Hello MK,

If your form is as simple as you say, this lin in the combo box's after update event should do the trick:

Me.RecordSource = "SELECT * FROM ITEMS WHERE " _
& "(ITEM_ID) = '" & YourComboBoxNameHere & "'"

ljprodev@yahoo.com
Professional Development
MS Access Applications