Combo Box - Filling in fields

  • Thread starter Thread starter Sandra Grawunder
  • Start date Start date
S

Sandra Grawunder

I have a combo box on a form to select a name from a
query list. I have additional fields on the form to
collect the address, etc. from the results of the
selection in the combo box. For instance:
=Getname.column(2), etc.

It seems to work fine except I have this aggrevating
situation when I type in a name in the combo. Once the
first letter is typed, the other fields are filled in by
the first record found beginning with that letter. Once
the name is completed and you hit enter, the fields are
updated with the correct information, or, if the name is
not in the list, I have a proc to add a new entry to the
underlying table, so everything eventually works out but
I find it annoying that the fields are filled in before
the name is completed and the underlying table is queried
for the correct results for the other fields.

Is there a better way to do this?

TIA,
Sandra G
 
Back
Top