Display MsgBox & don’t open form if blan

HELP! I have a database that links to two seperate tables and my users can click a button and it pulls up all records that are related to the same SSN from both tables. PART 1 PROBLEM. How do I tell it to not open the form if there are no records and just display a message “no records found”. PART 2 Currently it opens two seperate forms for each table because they hold different types of information. Is this the best way to display the records or can you display one form at a time and whenyou close it the other one pops up?