Search for Text in Form

[rbordonaro]

Hi, I have spent hours trying to find an answer on google, entering code, using unbound text boxes with combo box, but it is just not working. I have an employee database, with about 3000 records. I have a field named Employee Name and a second existing field (not displayed in form) named Last Name. I want the user to be able to search by Last Name to see results for any one with that last name or it could be LIKE Employee Name.



Second, I want to add a second text box search to enter a Job Code and get all the employees with that job code.

So, the user can either enter Last Name or Job Code.

I hope this is clear and I appreciate any help. It seems like such a simple task, but I just cannot get it.

Again, thanks,

[ranman256]

use a continuous form to show all records,
then when the user fills in the boxes, then clicks the FIND button, use vb to build the where clause:

sub btnFind_click()
dim sWhere as string

if not IsNull(txtCode) then sWhere = sWhere & " and [JobCode]='" & me.txtCode & "'"
if not IsNull(txtName) then sWhere = sWhere & " and [LastName] like '*" & me.txtName & "*'"

if sWhere = "" then
   me.filterOn = false
else
    sWhere = mid(sWhere,5)       'remove the 1st 'and'
   me.filter = sWhere
   me.filterOn = true
endif
end sub

[rbordonaro]

Thank you for the reply - I do appreciate it. Your reply is confusing to me. I am new to access - can you put in layman terms. How do I link the find button to the continuous form fields? I cannot click in the field names to change to a different last name.

I am sorry....

[ranman256]

The button is one you put on the form. Name it whatever you want. This is an example.
the field names too. Use YOUR field names.

put the code in the button click event.

[orange]

Watch this video by Steve Bishop to see search in context.