Update Problem

[Shallo9]

I Seriously need some help friends,

From the below mentioned scenario...I basically 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.

I am using the below formula to open the activity form with three conditions..

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

Hello All,

I am struck again with one of my database. Basically My database has a structure as follows

Customers have many policies and policies have many activities

CustomerID --->PolicyID--->ActivityID

Basically whenever I change/Update a customer's Policy number (from Temporary number to actual number in a separate form) some random existing customers names gets changed to the one lately updated.

If any one can shed some light on this that would be great.

Many Thanks