New order subform

[davethewelder]

Hi, I have a form which allows users to select a customer and it populates
the demographic information into the main form. I have a subform to allow
them to enter order information. The forms are linked by customer ID.

The problem I have is that when the customer is selected the subform goes to
the first order record on the order table for that customer.
I require it to stay blank to record a new order.

I have set the subform to Data Entry = Yes to give a blank form but it still
goes to the order record.

Is there a setting I am missing or do I require some code in afterupdate?

Any help greatly appreciated.

Davie

 

[Mark A. Sam]

Diane,

From your description, the subform seems to be in datasheet or continous
form mode. Try setting the DefaultView property to Single Form.

God Bless,

Mark A. Sam