Synchronized Form

[jrmiv]

I have a data entry form (primary key is CRR which is an autonumber) which is fed into a table called ComplaintDocument. This information is then researched and entered into another form called ResearchDocument (which references the CRR Number from the ComplaintDocument).

I have a query that looks at both tables and displays ALL OpenComplaintForm in a report. (Complaint Form has been entered but the Research part is still open)

I would like to be able to select a record on the OpenComplaintForm Report which would in turn open up the ResearchDocumentForm for entry and store in the ResearchDocument table.

Any help/guidance would be greatly appreciated.

 

[MajP]

One way
faq702-5860

 

[jrmiv]

MajP,

I think I may not have stated clearly my intentions and what I need help with.

I want to be able to Open the report that I created "OpenComplaintForm" and be able to select a record based on my primary key field "CRR" which will open the form "ResearchDocumentForm" for entry.

 

[MajP]

Sounds like you are not looking for a synchronized form (as I change in one form, related records change in another), but simply want to open another form based on the record selected in the first form. You can drop an unbound combo box on the form and the wizard would step you through how to do that.

 

[jrmiv]

More like an interactive report.

I want to open a report and be able to click on an item in the report and have it open a form.

Is this possible in Access?

 

[MajP]

Unfortunately reports do not have that functionality.

 

[jrmiv]

MajP,

I have fixed the problem with a double click event that when I double click on the "CRR" Field in the Complaint Form it opens the ResearchForm.

Is there a way (code/macro) to bring over the "CRR" number from the [ComplaintForm] to the [ResearchForm] on the double click event?