Access forms question from a newbie

[Karl Middleton]

Apologies in advance if I am posting into the wrong NG.

Question: In an MS Access Form we want to select a value from a dropdown
list and display a corresponding record for that value. Both dropdown list
and record for display come from the same table. How do we trigger the read
on the selected value?

TIA

Karl from OZ

 

[Jeff Boyce]

Karl

One approach would be to base the form on a query against the table. In the
query, use the form's combobox (dropdown) value as a criterion for the rowID
(your query would need at least the rowID, and ?other fields that are more
user-friendly). The criterion would look something like:

Forms!YourFormName!cboYourComboBox

In the combobox's AfterUpdate event, use something like:

Me.Requery

to force the form's source to requery.

The concept is to have the form only show the row identified by the
combobox.