Basic Filtering Problem

[CFP - Russell]

Hello everyone, I have a very simlple problem however I cannot figure out the solution.

I have a small form called 'customers'. The customers form has buttons that open up other forms which display more information about the customer. The data for the main customers form and all the smaller pop-up forms all comes from the master table named 'customers'.

My question is that I do now know how to filter out the records so that when the button for the customer details is clicked it brings up the current records details only.

Right now when the pop-up form pops up, it displays all the records and starts out at the 1st one. I need it to carry the record that it is on and display those details only.

Thanks,
Russell

 

[bradcccs]

Try:

    DoCmd.OpenForm "Your2ndFormsName", , , "[NewRecordID]=" & Me![CurrentRecordID]

You will need to alter the NewRecordID & CurrentRecordID to suit your needs.

Brad.