I used an unbound textbox which automatically fill in with a value after I
select an item from a combo box on a form (e.g., select a Product ID in a
combo box, and have the Product Name automatically display in a textbox)? "
I had came across this in The Access Web. It does answer part of my
question. However in the form, there are more than 1 record. Once I go to the
2nd row and I select another Product ID int eh Combo Box, the 1st record
automatically was updated.
How should I go about doing this?