Applyfilter

[zamir]

hi, can you applyfilter to a form based on what a user will enter in a login screen and have a specific record show up on that form.

the code i already have is this:

DoCmd.ApplyFilt er , "LastName = Me.txtLastName"

which a 'Enter Parameter Value' shows up to find that record, but i don't want to do that, i want that record to be already on that form.

thanks

[willakawill]

Hi. You can't include control values inside parenthesis. Try this:

DoCmd.ApplyFilter , "LastName = " & Me.txtLastName.Text