Main form stay intact while subform changeable.

[storm1954]

Hi ,

Thanks for all the help that you guys are providing, you are the greatest.

A little problem I am facing is that i have two forms ( main and Sub) . Everytime i want to enter a new record the main data goes blank ( not required) and the sub data goes blank for new data ( required) . The new subdata is related to the main data. This way I have to retype all the same data in the main form which I wish not. Please assist making the main form data stays so i only type the sub form.

Sound simple but.......

Muchas Gracias

[Bob Fitz]

Can you tell more of what you are trying to do and about the data that each of the forms shows and how the data is related.
A sub form is usually used to show the "many" data in a one to many relationship. The main form showing the "one" data.