How to open a form with filter applied?

[rkm360]

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

[andymark]

filter 'ABC' records
DoCmd.OpenForm "Customer's Information", , , "[Account Number]='ABC'"