Subform

[nia]

Hello, I have a form within my database, and within this form is a subform. But every time i move on to the next record in the form the content of the subform does not change, ie the information in the subform for the first record stays the same for the next record. How can change so that when i go to the next record both the form and subform go blank giving me a new next record!!
Thanks
Nia

 

[Mile-O]

You need to ensure that the subform and form are linked by using the LinkChildFields and LinkParentFields properties of the subform object.

 

[nia]

Hi, thanks for that, i have linked both forms now but now my problem is that once i write in information into the subform of the second record, it overwrites the information in the subform of the first record, so now the information in the first and second records of the subform are the same!!!!!!!!!
Hope you can help
Nia

 

[Mile-O]

Can you post an example of your problem as I don't "quite" see what you are attempting?

 

[nia]

Well in my main form, i have three combo boxes. One for Naming of the Area, the next is for Test Id then lastly for the Year. These are all stored in the Table Retest. Then in the subform underneath i have a textbox for the Test Date, a combo box for Reason for Retest, another combo box for Product, another combo box for Analyst Name, and finally a comment box. All these are stored in a table called RetestDetails.
Because i am using code to add to these combo boxes, putting these all on one form seems to corrupt the code....
Any ideas??
Thanks
Nia