Open a form - Search and Open another 2 forms?

M

MN

Hi,
I have a Main Screen obtain the records from a temp table. User will click a
button to search for Lastname and Firstname in 2 separate table Customer and
table Service.
If found in those 2 tables then
- open 2 form for edit that record
Else
-Add new record in those tables
After that go back to Main Screen with the next Record.
Ques:
1- How do I search for those 2 text box?
2- How do I open 2 forms obtain only those records?
Thanks you for any reply.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Repost-Please help-Search Lname and Fname 0
Temporary Form with 2 Sub form Update Main Form And its Sub form ? 2
How do I clear a form? 0
Using combo box when adding records to continuous form 1
Build search function in to a form 5
Crash on Close from 2 stable Access forms after unsolicited install of VS 2015 0
VBA code returns no records hwenKey ID is added 14
Filter Combo Box Listing 5

Top