I've got a Dialog form that runs a Macro that pulls up a tabular form based upon the user input in the dialog form. I use the Where condition to bring up only records that match the Input Text. The Where condition looks like this, [LastName] Like [Forms]![SearchByDialog]![SearchByLastNameText].
The only problem is that you have to type in the full name or the first letter and an *. I would like the user to be able to just enter the first few letters of the field (in this case [LastName]) and find all corresponding fields. I guess assume that the * is always there. Thanks for any help.
Jeff
The only problem is that you have to type in the full name or the first letter and an *. I would like the user to be able to just enter the first few letters of the field (in this case [LastName]) and find all corresponding fields. I guess assume that the * is always there. Thanks for any help.
Jeff