Subform to add record

[bobsyeruncle]

In this DB i have the main form and subform (not visible)

When you click button it opens subform. I want this subform to add a new record with the visit details.

HOW?

I am a Noob and learning all the time so play nice

 

[PNGBill]

When you Click to make the subform visible, also set it to add data.

 

[SOS]

From what I'm seeing there is no reason to have a subform anyway. You aren't saving anything to the main form, or using its recordsource in any way, so you could just have the subform table be the form's recordsource and get rid of the subform completely and put the subform controls on the main form. Not sure why you have it this way.

 

[bobsyeruncle]

I have tried this both ways ... using just the main form and using the subform too. I am stuck!

The end result i want is ...

When user selects school name from combobox ... the fields on the main form are populated with the contact details.

I then want the command button to open a subform/seperate form (whatever is the best method) where i can add the details (relevant to the main form record displayed) you see such as date of visit, no of pupils etc. Once this information is entered and the subform is closed the data is added to the table (related to the main table) where i can build reports/querys based on the information stored there.

Is that any more clear

Heres a quick screenshot the whole DB is in Post No1

 

[bobsyeruncle]

Pretty Pretty Please ..... i'm pulling my hair out

 

[SOS]

Pretty Pretty Please ..... i'm pulling my hair out

Revised sample attached.