I have two forms based on two tables:
tblReferralsDischarges ---- frmReferralsDischarges
tblOtherServices ---- frmOtherServices
Customers are entered in the frmReferralsDischarges, assigned a Referral Autonumber, and all thier information including their RAISE Number (a unique identifer to that person) and all the information relating to thier referral. There is a command button which opens frmOtherServices. OpenArgs is used to copy across the ReferralAutonumber and the RAISE Number. Then other services that that customer has been referred to can be entered.
This is where my problem occurs.
Whilst i can enter data, and it saves under the correct person, if i leave the form (frmOtherServices) and go back in to it at a later date to enter more information relating that referral, it opens a blank form. No data is kept and a new entry occurs within the table.
How do I fix this???
l3111,Manchester, UK