Look up field

  • Thread starter Thread starter Stephanie
  • Start date Start date
S

Stephanie

Hi. I've seen databases designed to have a look up field
where you start tying the LastName, and the remainder of
the form "flashes" through all of the contact information
while you're typing.
For example, if I want to look up "Peterson", I type "P"
and my first record "Pears" pulls up, the I continue with
the typing to "Peter" and the Peter record pulls up, then
as I finish typing "Peterson" I get to the Peterson record.

However, I can't figure it out. Could you provide the
details of how to design a look up box?
Thanks,
 
Stephanie

Look into the use of a "combo box", with AutoLookup property set to Yes.
Access HELP and the Northwind sample database that comes with Access provide
examples.
 
Jeff, thanks for the reply.
I did copy and paste something into my form that is
working for what I need.
But I am curious- I tried to use the combo box, but
couldn't figure out where the AutoLookup property is. I
didn't see it on Access 2000 on the properties list....
Thanks,
Stephanie
 
Stephanie

My bad -- the Auto Expand property is what you want.

Regards

Jeff Boyce
<Access MVP>
 
Back
Top