Synchronze Forms

[chopper57 via AccessMonster.com]

I have a combo box on a main form for job names and a subform for entering
data.
I have a popup for to add a new job name.
On the close event of the popup form I have a requery for the combo on the
main form:

Forms!frmMainForm!Combo1.Requery

This works as the job name gets added to the list.

The problem is that when you choose the job name the subform doesn’t
synchronize with the newly added job name. I can close the form and reopen
it and it will be synchronized but not without closing it.

 

[Marshall Barton]

I have a combo box on a main form for job names and a subform for entering
data.
I have a popup for to add a new job name.
On the close event of the popup form I have a requery for the combo on the
main form:

Forms!frmMainForm!Combo1.Requery

This works as the job name gets added to the list.

The problem is that when you choose the job name the subform doesn’t
synchronize with the newly added job name. I can close the form and reopen
it and it will be synchronized but not without closing it.

It sounds like you need to requery the subform too.

Forms!frmMainForm!subformcontrolname.Form.Requery

 

[chopper57 via AccessMonster.com]

Would you write it on two seperate lines?
I tried somthing like you have it doesn't work.

I have a combo box on a main form for job names and a subform for entering
data.

[quoted text clipped - 9 lines]

synchronize with the newly added job name. I can close the form and reopen
it and it will be synchronized but not without closing it.

It sounds like you need to requery the subform too.

Forms!frmMainForm!subformcontrolname.Form.Requery

 

[Marshall Barton]

No, that's a one line statement.

"tried somthing like" it?

"it doesn't work"?

More information please.
--
Marsh
MVP [MS Access]

Would you write it on two seperate lines?
I tried somthing like you have it doesn't work.

I have a combo box on a main form for job names and a subform for entering
data.

[quoted text clipped - 9 lines]

synchronize with the newly added job name. I can close the form and reopen
it and it will be synchronized but not without closing it.

It sounds like you need to requery the subform too.

Forms!frmMainForm!subformcontrolname.Form.Requery