Finding Names

  • Thread starter Thread starter Iain
  • Start date Start date
I

Iain

I have had problems designing a form that allows me to
enter either all or a few letters of clients surname with
out using the * sign which the parameter box prompts for.

I am using XP professional.

In advance may I thank you for any assistance given.

IainS
 
I have had problems designing a form that allows me to
enter either all or a few letters of clients surname with
out using the * sign which the parameter box prompts for.

I am using XP professional.

In advance may I thank you for any assistance given.

IainS
Click to expand...

I'm not quite sure what you want, but a Query with a parameter such as

= [Enter last name or part of it:] & "*"

is one way; a Forms reference

= [Forms]![formname]![controlname] & "*"

is another. But probably the best way is to use a Combo Box with the
default autocomplete feature turned on.
 
Back
Top