Order Entry form problem

[richard luft]

I'm attempting to upgrade my Ac2 program to Ac2000, and I'm having a confusing problem with an 'orderentry' form/subform, which worked perfectly in Acees2, yet does not function in access2000, which I hope someone can help solve.
In Ac2, the subform worked purely as a data entry form, which it still does it still does in Ac2k ONLY IF there are no previous entries in the " services" table (recordsource for subform) for that customer.
However, if there ARE previous entries in "services" for the given customer, my subform ends up displayingl a list of the previous entries for that customer.
This display occurs after an event of "Applyfilter, {Customer ID] = Me![Customer ID]" which occurs on exit of one of the fields in the form header, and prevents the proper functioning of the form.
I note that the coding of the form/subform is identical in both versions of access, other than DAO modifications to allow compatibility. Also, the subform is set for 'default editing' = Data Entry, and id present on the form in datasheet view. Also, the form/subform is linked on [Customer ID].
Any suggestions as to how to correct this problem?
TIA, Richard

 

[aleb]

I suspect that your subform works perfectly well
You just need to jump to the "new record" field. Place a button on a subform with the help of the wizard, select "record operations" in Catergories, select add new record in Actions and .... you are done.

 

[richard luft]

Pat: My filter is for the detail section of my form, in which the subform is placed (but not exclusively). The filter is not for the subform itself.
I don't understand how I can change the recordsource of the subform to accomplish what you suggest, as the recordsource would always be tblServices.

Aleb: ----But how do I prevent the rows of the subform from getting occupeid by previous entries in the first place? Or will the 'newrecord' btn also clear the entries present?

 

[aleb]

Change the subform default view to the Continuous Forms and add this button to the header section of the subform thus the button will not appear on every subform record.
Also this button does nothing but just jumps to the new record.
Try it.
BTW it will not clear any records it will not just display them.

 

[richard luft]

Aleb:
Sounds good; I'll give it a try.
I'm still confused that the old system worked fine in AC2, but fails here. It was so neat, without extra buttons, etc.
Richard