New Record on SubForm

[Xenix]

How can I add a new record on a subform?

I use the code:
Forms!Customer!NotesQuery!Customer = Forms!Customer!NAME

but this just overrights the customer field on the notesQuery form


Thank you in advance

Mike

 

[Mile-O]

If you are already on the subform just use the

DoCmd.GotoRecord, , acNew

piece of code wherever you need it.

 

[Xenix]

Thank you but I am not on the subform

I am on the Customer subform but the notesquery subform is open

any other ideas?