Referencing subform

[Aerowolf]

OK...I am able to use the following to populate fields in a record of the subform:

[Forms]![frmOrderEntry2]![Order Details]![QTY1] =

where [Order Details] is a subform that has the table OrderDetails as the data source.

How do I go to the next record in the subform?

Edwin

 

[Aerowolf]

I just answered my own question.

I used the following:

[Forms]![frmOrderEntry2]![Order Details].SetFocus
DoCmd.GoToRecord , , acNewRec

Thanks

Edwin

 

[Aerowolf]

OK...now it doesn't work.

HELP!!!

 

[PHV]

What about this ?
Forms!frmOrderEntry2!Order Details.SetFocus
Forms!frmOrderEntry2!Order Details.Form.Recordset.MoveNext

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Aerowolf]

When I use the following:

[Forms]![frmOrderEntry2]![Order Details].SetFocus

I get an error that says the database cannot move the focus to the control Order Details.

Edwin