Subform Control

[RoadRunner123456]

I have a set of forms that are similiar to a five page application. I am trying to get a button to activate from the main form to go to the Subform Page. If there is no record is should open to a new record otherwise it should go to the exisitng record.

The main form is linked to a Main table and each of the Subforms are linked to to their own table with a common key to join to the main table.

Right now my button on the main form code work fine for the existing records but it does not default to new: Need a little help here for the next step to set controls for the new records???

Private Sub Toggle_120_Click()
Dim strDocName As String
Dim strWhere As String


strDocName = "Grassfed_Entry_Form"
strWhere = "[ID]=" & Me!ID
DoCmd.OpenForm strDocName, acNormal, , strWhere
End Sub

[June7]

Don't understand the code. Is Toggle_120 a control on main form? Is Grassfed_Entry_Form a subform? Can't 'open' a subform that sits on a main form.

[RoadRunner123456]

Don't understand the code. Is Toggle_120 a control on main form? Is Grassfed_Entry_Form a subform? Can't 'open' a subform that sits on a main form.

I have a toggle button on the main form#120, this is to go to the subform that is related to the Main Table through a key on the subform table. Because there are so many entry fields on the main form and the associated five subforms they need to have thier own separate page views. What I want to do is use a toggle button to go to the subform "Grassfed Audit" and either open the already exisitng date if any or if not data exists to open up a blank form in data entry mode. I have tried this using at designer toold to create the subform on the main form but it is entirely to cluttered when you have all five data entry screesn. Bewteen the main form table and the subform table there are about 125 fields for data entry. so by breaking it up into the main form with five subforms it will make it less cluttered.


The above toggle button commands, take the Main form Id and set its value so the subform can open with the data set related to the linked key so I know I have it partly set up. but lack how to get it to open in new record mode when it can not find a matching record.

[June7]

Totally confused, don't understand what you describe. If the main form is bound to a primary data table and subforms are bound to 5 related dependent tables, the records should synchronize. If there aren't any related records then the subform(s) will be on a new record row. Are the subforms in single or continuous or datasheet view?