Moving from one subform to the next clears the information in the first subform

[pinghanling]

Hi,



I'm doing an invoicing system and experiencing a problem on the invoice form.

InvoiceMainForm contains two subforms - ClientSubForm and QryLineItemsDataSubForm

ClientSubForm links to InvoiceMainForm through the ClientId field and QryLineItemsDataSubForm links to the InvoiceMainForm through the InvoiceNumber field.

The ClientSubForm appears first on the InvoiceMainForm and I want the user to be able to tab from the last text box on the ClientSubForm to the first text box on the QryLineItemsDataSubForm.

So I put the following code onto the last text box of the ClientSubForm:

Private Sub ClientEmail_Exit(Cancel As Integer)
    Forms!InvoiceMainForm!QryLineItemsDataSubForm.SetFocus
    Forms!InvoiceMainForm!QryLineItemsDataSubForm.Form!QtySold.SetFocus 
End Sub

This works in that it moves the cursor to the correct field in the QryLineItemsDataSubForm, but it also clears all the information from the ClientSubForm, except for the ClientId.

Can someone please help me to either fix the navigation or fix the clearing of the client information? Below is an image of my table relationships.


Thanks
Hanlie

[pbaldy]

Try changing the Cycle property of the form being exited.

[pinghanling]

Thanks for the reply.

I set the Cycle property to 'Current record' and it works the way I want it now.

Cheers
Hanlie

[pbaldy]

Happy to help, and welcome to the site by the way!