Finding Names

[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

 

[John Vinson]

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'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.