I posted a question about opening more than one form when a field matched and got the suggestion to create sub forms. IT WORKED GREAT. But then they said this.
(Just set the OnUpdate property of the SSN control on the main form to requery the two subform controls (after you make any appropriate checks to be sure the SSN entered by the user is valid).
You might also want to set the subform controls visible property to false so they are not displayed when the form is opened. After a valid SSN is entered, make them visible and requery them. If an invalid SSN is entered, reset the two subform controls visible property to false.)
I don’t get that. How do I hide the subforms until after I input the SSN and then have the subforms appear with the matching information?
Also, they suggested that I put some information in a header. So I can take the SSN field and the other fields that auto populate and put them in the header? Does that mean that will appear in all of the forms? Because each form has the SSN / Name / Phone Number. When I added stuff to the header I couldn’t see the sub forms anymore.
It is slow now because I have like 4 sub forms. Will hiding them speed it up?
Oh one last thing. I have dummy ssn’s like 000-00-0000 how can I tell it not to pull the history calls for those specific SSN’s?
