Access forms question from a newbie

  • Thread starter Thread starter Karl Middleton
  • Start date Start date
K

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
 
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
 
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
 
Back
Top