make subform data entry

[DBritter]

I have a subform that I want to be in data entry with only blank records showing. This is a form for a new order by an existing customer(all of the order information is in the subform. the main form only holds the ID field relating the order to the customer).

I have both the main form and the subform set to data entry.

What I see when the form is opened is a previous order from the same customer.

(if this make any difference)
there is a filter on the main form where the ID field is the same as on the previous lookup form. Once the person has found the correct customer, they click a button and supposedly go to a blank form to enter a new order.

 

[jflachman]

If you open the form with

DoCmd.OpenForm

you will overide the Data Entry property if you set the datamode to acFormEdit rather than acFormAdd

If that's not your problem, I'll need some more information. Jonathan
________________________________________
It is not fair to ask of others what you are unwilling to do yourself.
-Eleanor Roosevelt

 

[DBritter]

Code to open form:

DoCmd.OpenForm "frmLead2", , , , acFormAdd


I wrote in the on enter property of the subform to 1)go to a new record and after that did not work 2)to got to the next record. Both of the operations told me that I had an error and I was at the end of the recordset.

When I go to a new record using the middle wheel on my mouse(scrolling down), I end up at the end of the order records(the records that the subform references) and the ID field on the main form has "(autonumber)" written in it telling me that there is no longer a relationship between the customer ID and the order ID.