Form Question

[Bandit]

O.K. I have a Purcahse Order Table and a Purchase Order subtable. I have
used these to create a Purchase Order Form and I use the subform table for
the subform on the Purchase order form. I want to enter my basic PO info on
the form and the items I am purchasing on the subform. When I try to go to
enter a new PO, the subform does not advance to a blank form like the PO form
does. So the PO form will advance to a blank form to enter new info but the
subform will not advance to a blank form to enter new info. Also, the PO
will only allow me to advance two forms. Any ideas? This is a great site.

 

[Klatuu]

Check the Link Master Field(s) and Link Child Field(s) properties in your
subform control on the main form. The Link Master Field(s) should be the
field or fields in the Purchase Order Table that relates to fields in the
Purchase Order subtable. The Link Child Field(s) should be the fields in the
Purchase Order subtable that relate to the fields in the Purchase Order table.

This question, I don't understand. What do you mean by advancing two forms?
Do you mean two records?

Also, the PO will only allow me to advance two forms.

 

[Bandit]

Sorry for the confusioin, I meant two records. Thanks for your help. I
really appreicate it.

 

[Klatuu]

Without being there to see it, I can't tell you exactly why it is advancing
two records. I would first look to see if there are two places in the code
that would move to the next record.

 

[Bandit]

I appreicate your help and I don't want to sound stupid, but could you tell
me where to find the master/child field?

 

[Klatuu]

If you have a subform, on your form is a subform control. Select the subform
control, not the form that is being used as the sub form. Open the
properties box for the subform control and you will see those properties
there.