Subform not staying synchronized!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a main form with a subform; they are linked via the master and child
fields. All is fine so far. I have a combobox on the main form that I use
to looks up data on the subform based on the value I select in the combobox.
Works great! However, when I tab out of the combobox into the subform, the
data in the subform changes and is no longer synchronized with the combobox.
Anyone know how I can fix this. It's driving me nuts; I don't want to lose
synchronization.
Any help will be appreciated, Thanks. (Forgive dual post. Original in
wrong catagory!)

Denny G.
 
I have a main form with a subform; they are linked via the master and child
fields. All is fine so far. I have a combobox on the main form that I use
to looks up data on the subform based on the value I select in the combobox.
Works great! However, when I tab out of the combobox into the subform, the
data in the subform changes and is no longer synchronized with the combobox.
Anyone know how I can fix this. It's driving me nuts; I don't want to lose
synchronization.
Any help will be appreciated, Thanks. (Forgive dual post. Original in
wrong catagory!)

Denny G.
Click to expand...

Please post the Master and Child Link Fields, and the synchronization
code. It may help to post the SQL of the two forms' recordsources as
well.

John W. Vinson[MVP]
 
John, thanks. Seems as though I found a solution: On the main form's
properties, I changed the "Cycle" property to "Current Page." Works great
now!

Denny G.
 
Denny said:
John, thanks. Seems as though I found a solution: On the main form's
properties, I changed the "Cycle" property to "Current Page." Works
great now!
Click to expand...

You might still have a problem. Given what you say above this indicates
that your main form and the ComboBox on it are both bound. If the only
reason for the ComboBox is to filter what you see in the subform then it
should NOT be bound. Everytime you change the value in the ComboBox you are
currently editing data in the main form's record. Is that your intention?
 
Back
Top