Hi, I am a newbie to the programming side. I am sure this is a simple issue but I just can't seem to find the right answer.
I am creating a fairly basic Contacts database. I have a field named " Account Number" on each of my tables, all related together.
I have a form of Customer's Information, and I have a Command Button set to open a Contact Form. When the form opens, I need it to be filtered to the Account Number that I am viewing on the main form "Customer's Information"
Ex: I am viewing XYZ Company's record, with no filter applied, just viewing the record. I want to open the Contacts Form already filtered to show just the records that match the Account Number of the first form.
I know I should be able to do this easily but I just can't figure it out.
Any help would be GREATLY appreciated!
Thanks,
Robert