Hello All
I have a table called Activity with columns ActivityID, PolicyID (Lookup from tblPolicy), CustomerID (Lookup from tblCustomer) and further ...
I have an activity form with details from tblactivity..further I got a Dashboard where all the records are displayed including ActivityID (Hyperlink)
when ever the user clicks this activityID the activity form opens..This is fine but when the activity form is opened its changing the policyID and CustomerID on the form and in the table aswel. To make it even worst it some times changes and some times doesn't. Basically I am unable to find the problem at the first place.
I am using the below formula to open the activity form with three conditions..
Any Help would be grately appreciated...Its my third day on this issue...
Many Thanks
Basically My database has a the following structure
Each Customer has many policies and each policy can have many activities
CustomerID --->PolicyID--->ActivityID
If any one can shed some light on this that would be great.
Many Thanks
I have a table called Activity with columns ActivityID, PolicyID (Lookup from tblPolicy), CustomerID (Lookup from tblCustomer) and further ...
I have an activity form with details from tblactivity..further I got a Dashboard where all the records are displayed including ActivityID (Hyperlink)
when ever the user clicks this activityID the activity form opens..This is fine but when the activity form is opened its changing the policyID and CustomerID on the form and in the table aswel. To make it even worst it some times changes and some times doesn't. Basically I am unable to find the problem at the first place.
I am using the below formula to open the activity form with three conditions..
Code:
DoCmd.OpenForm "frmActivity", acNormal, , "[customerid] = " & Me.CustomerID & "AND [ActivityID] = " & Me.ActivityID & "AND [PolicyID] = " & Me.PolicyID
Any Help would be grately appreciated...Its my third day on this issue...
Many Thanks
Basically My database has a the following structure
Each Customer has many policies and each policy can have many activities
CustomerID --->PolicyID--->ActivityID
If any one can shed some light on this that would be great.
Many Thanks
Last edited: