Hi everyone, I almost finished build my database but I have little problem - I want to add a subform in my customer form, where the user can type whatever he knows about the customer (first name, last name, phone number, street, house number) and when he will press the command button, it will run search on the table of the main form (customers) and jump to the correct customer. If the customer doesn't exist, it will pop massage "not found".
I thought to do that via query, because I want it to combine some searches (example - user know only first name and street), so it will be very simple, but I don't want it to open new page with the result, but to jump to correct customer in the customers form...
Thank you!!