Multiple Subforms Search

  • Thread starter Thread starter Kentucky5
  • Start date Start date
K

Kentucky5

Actually I have two dilemmas, I have a form with multiple
subforms on it and if the user ends one form and goes to
the next issue it does not start with the initial subform
it remains at the subform they were at with the issue they
just entered.

2nd I need a method to show the user on the main form what
subform already has data. My thought was if the subform
has data entered on it that the button should be bolded.
This would indicate to the user the buttons that are not
bolded do not yet have data entered and will ensure that
nothing is missed.

Any thoughts on either issue would be appreciated.

Thanks
 
Kentucky5 said:
Actually I have two dilemmas, I have a form with multiple
subforms on it and if the user ends one form and goes to
the next issue it does not start with the initial subform
it remains at the subform they were at with the issue they
just entered.

2nd I need a method to show the user on the main form what
subform already has data. My thought was if the subform
has data entered on it that the button should be bolded.
This would indicate to the user the buttons that are not
bolded do not yet have data entered and will ensure that
nothing is missed.

Any thoughts on either issue would be appreciated.
Click to expand...
If they are moving to a new record the subforms should all be blank.
Looking up an existing record in some matter should fill the subforms.
If this does not happen there is probably a relationship problem between
them.
 
When they move to a new record the subforms are blank but
the focus remains on the last subform that they entered
and that is not what I want. I want the main subform to
be the focus. Any ideas with regard to the 2nd issue? I
appreciate your help.
 
kentucky5 said:
When they move to a new record the subforms are blank but
the focus remains on the last subform that they entered
and that is not what I want. I want the main subform to
be the focus. Any ideas with regard to the 2nd issue? I
appreciate your help.
Click to expand...
Use setfocus to set the focus to the field you want in the oncurrent event.
 
Back
Top