Simple Subform Problem

[whooke]

I'm sure there is an easy fix but I can't seem to find it. I have a form with a subform, with the intention of allowing the user to add data to the subform which would push it to the table. However, currently my subform is pulling the first record from the table and displaying it. I would like the subform to be blank when displayed to the user, so that data could be added to the form and be pushed to the table.

It seems as if there should be a simple property change that would allow me to change the direction the data is pushed. Any ideas how I can make this happen?

[June7]

What is relationship of form and subform? Is main form bound to a "master" table and subform is bound to dependent "child" table? Are subform container Master/Child links properties set?

Data is 'pushed' to table by entering values into new record row. Can set a form's DataEntry property to Yes and existing records will not be displayed.

[Missinglinq]

Alternately, you could use this in the Form the Subform is based on:

Private Sub Form_Load()
  DoCmd.GoToRecord , , acNewRec
End Sub

This will open the Subform to a New Record, but also allow existing Subform Records to be viewed, as well.

Linq ;0)>