New order subform

  • Thread starter Thread starter davethewelder
  • Start date Start date
D

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
 
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
 
Back
Top