Access forms question from a newbie

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

First, make sure you use an *unbound* combo box for this. You won't be able
to move record if the combo is bound to a field, because as soon as you
choose a value Access tries to save it into the current record instead of
moving.

When you add a combo to the form (in form design view), there is a wizard
that writes the code to navigate to a record. If you would prefer to write
your own or have something more stable, see:
Using a Combo Box to Find Records
at:
http://allenbrowne.com/ser-03.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Karl Middleton" wrote in message
...
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?

Did you try building the combo box with a wizard?

The wizard has such a option built in to make this type of combo box....

i
"Karl Middleton" wrote in message
...
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