one a form with on relevant record.

[ianatkins]

hello,
Im no coder but Ive got to do a access project.

Heres my problem. I have a contact management database. A form is used with contact details. I have a button on that form which opens a second form containing call details.

I would like the second form to open showing the calls which match the record in the first form.

(both forms are linked with the same contact id)

Any help would be appriciated.

thanks
ian.

 

[Tay]

When you add a button to open the second form you can choose 'open the form and find specific data to display' then you can create the link between both forms uising your ID number and the second form will show the related records.

 

[ianatkins]

ive tried that one but it didn't work.



is ther any reason that springs to mind why that doesnt work.

At the moment in the primary key (for the second form) is a lookup of the primary key fromthe first form's data (whether that makes a difference).

thanks.