combo box synchronize problem

  • Thread starter Thread starter UpRider
  • Start date Start date
U

UpRider

I have a form with a subform. The main form (form view) is for tasks, and
the subform (datasheet view) is for people who performed the tasks. The main
form has an unbound combo box to choose a task, and the subform displays OK.
The main form also has navigation buttons. The problem arises when the
navigation buttons are used. The subform displays the records OK as the main
form records are scrolled, but the combo box doesn't change. The combo box
shows a constant task, the the actual records shown in the subform are for a
different task. How can I update the combo box when the records are
scrolled via the navigation buttons? Setting the combobox to a string value
does not work. I don't want to bind the combo box so as to avoid inadverdent
updates.
TIA,
UpRider
 
Ah, I found the answer via Google. Never Mind.....
Set the combo box equal to the ID of the Task in the main form's CURRENT
event.
UpRider
 
As the combo is not bound it doesn't sound like it will show anything
anyway. I guess your source is picking records from some other table
somewhere then jumping to that record on the AfterUpdate event?

Why not just clear the combo each time the user navigates away from the
current record?

In the On Current event of the form your combo is a child of, enter the
following:

me.cboYourComboName=Null

That will at least clear the value so that it doesn't confuse the user.

Jamie Richards
 
Back
Top