automatic fill in

[angie78]

Hey, I'm working on this project where my boss wants me to built an 'interactive' form. When I start to type a Customer's name it has to automatic fill the rest in. for example 'Angie" is a customer: When I type 'An' it has to automatically fill in 'Angie' or at least give the 'Angie' option, if it's not Angie I could fill something else in that field.
And when I type in a customer's name it's info has to automatically show in the subform.
Anybody knows how I can do this?

 

[LHR]

You can have your subform based on a query that takes in the value of control on the main form.

i.e:

The criteria of the query for the subform would be:

Forms![mainFormName].[ContolOnMainFormName]

Hope this is helpful!

 

[Pat Hartman]

The combobox works this way by default. Use it in combination with an "autolookup query". Details in help.

 

[angie78]

ok thnx guys....i'll try finding something on 'comboboxes' in help