How do I set up a search on a name eg john smith+go to the record

L

leopard

I have a database of 1000 names,through forms the user must have the ability
to type in their name eg; John smith it comes up with a list, which form
filter will do. But how do you program so that the user highlights the name
press Enter and the persons details appear.

Do you need to to use VBA to make this happen?
 
R

Rick B

I'm pretty sure that you can add a combo box to the form and the wizard will
let you do this...

The very first option it gives you is... Find a record in my form based on
the value I select in my combo box.
 
L

leopard

Hi Rick

Yes that kind of works thanks. But ideally I would like a screen where you
type in the name, if the name is one that is there but there a 5 with of the
same - john smith a list appears you select the correct one and it goes into
that persons record. As well as that if the name does not appear you can add
a new record.

Leopard
 
Top