How can I stop my Subform from changing!

[Shiloh917]

I have a form based off of two forms The EmpData form and the Personal Information Form. I am adding information into these forms on a regular basis they are connected by the EmpID and ID keys. The problem is after I have edited the form and then I need to go back in and add more information I have to start all over and re add the information in. The subform is not keeping the information in it. I look in the personal Table which the subform is based on and the information is there but it adds it in as a separate row each time I add info. I just need the information entered in one time for each employee and then if they need to change an address or contact name I just want to open the form and edit it. Please help!

 

[KenReay]

Hi

You need to explain a bit more about how you have your forms set up, are they bound forms ?

How do you navigate to an existing record to change it, as opposed to inserting new record

Do you have any relationships set between your tables

do you have the master/child properties set on the sub form control(s)

Data is held in tables, not forms, so you need to describe the structure of the tables


Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[Shiloh917]

I figured it out. All I needed to do was on the Personal Form which is the Subform was set data entry to No. Thanks anyway!