Enter Parameter Value Box Appearing?

[SantasLittleHelper]

I have the following as a Macro which allows me to search for information. E.g. If i searched for the surname Smith, the table on the Split Form will show me the results.

[First Name] Like "*" & [Forms]![Search Staff Records]![Text24] & "*" Or [Surname] Like "*" & [Forms]![Search Staff Records]![Text24] & "*" Or [Date of Birth] Like "*" & [Forms]![Search Staff Records] & "*"

When I click the search button which this Macro is assigned, the 'Enter Parameter Value' box appears and I need to type my search text in again for it to work. Is there a way around this?

 

[Trevor G]

Think two possible options.

Use the macro section in Access to create the search as described above if it then works convert the macro into code and you have a solution.

Create a query to do the search part by part then it should give you a solution in SQL View.

 

[xenou]

There are three parameters in your post query so not sure what you are retyping.

also this one appears incomplete (the last one):
[Forms]![Search Staff Records]