Returning to main form that has a subform from another form

[DimmickT]

I have a mainform which is the customer form, then a subform where data is
entered regarding a specific customer record. From the subform I then have a
command button that takes the user to the billing form. Once they are
through entering the data in the billing form there is a command button that
returns them to the main form for the next entry. Is there a way to
automatically have the cursor ready in the first field of the main fields
subform to save a few clicks?

Also, once they are through entering new records for that customer you
currently have to use the navigation window to go to the next new record, is
there another way to do this?

Thanks
TDimmick

 

[Larry Daugherty]

Sure. You could open that last form in Dialog mode. Let your command
button simply close that form. In the form's close event but a line
of code to open the desired "main" form. Follow that with a line to
SetFocus to the desired control on that form. Or you could put the
code in the command button's Click event preceded by a line to close
the current form...

HTH

 

[DimmickT]

Here is some more detail...

I have a customer request form with a request detail subform. After the
first item of the request is entered in the detail subform the user will then
click the command button that opens the billing form (but leaves the main
form open since there will be multiple items associated with that request)
Once the billing information is entered the user will click a command button
that will set some values and close the billing form returning them to the
main form. Where would I add the line to make a specific field on the detail
subform get the focus once the billing form is closed? I mostly use
macros...my knowledge in modules and event procedures is limited so I prefer
to use the macros although I am having a hard time figuring this one out.
Everything is working beautifully except right now the user has to click in
the appropriate field to enter the next item. I would like to change this to
eliminate room for error.