Data Entry Form Question

[Guest]

Background: I have a front end/back end application that I am striving to
reduce the user's tasks for data entry. I have a form to capture information
and a portion of the form uses a combo box on a combo box setup. When a user
chooses the "team' they are assigned combo box 1st, the 2nd combo box
directly next to the "team" combo box shows only the names related to the
"team".

My question is, after the initial data entry from the user is complete and
is entered into the form (form property is set to data entry) and the user
needs to enter another new data entry how can I have the form retain their
“team†and name combo box information?

Bottom line: I am striving to reduce user’s data entry of team and name
entries.

Thanks for your time

 

[Larry Linson]

Do the usual "linkage" of the Combo Boxes and save the value of the first
(Team) Combo Box in a Form-level variable in the AfterUpdate event of the
first (Team) Combo, save the value of the second (TeamMember) Combo Box in
the AfterUpdate event of the second (TeamMember) Combo Box and reset each of
the Combos to the saved variable in the OnCurrent event.

That should do it... if you don't want to preset for the same Team Member,
instead of resetting the second (TeamMember) Combo, just Requery it after
you've reset the first (Team) Combo.

Larry Linson
Microsoft Access MVP

 

[Guest]

sir,

thanks for the advice, i'll try it on a "copy" of the form. that way if i
screw it up my application will not be affected.

cheers

doug

 

[Guest]

Sir,

i have attempted trying what you recommended however, i have had no luck.

is it possible for you to be more descriptive in your instructions; perhaps
step by step to accomplish this?

thank you for your time.

regards

doug