Combo Box in subform

[Guest]

The combo box will return the correct data on the subform if opened directly,
but when I activate the combo box on the subform from the main form, it loses
the paremeter value. Any suggestions!

 

[Guest]

I'm not sure on the problem.
Does the combo display data ccording to a value selected in the main form,
but it doesn't happen when you change the value in the main form?

If that the case you can try refreshing the combo on the AfterEvent of the
field in the man form

Me.[SubFormControlName].Form![ComboName].Requery

If that is not the case, can you explain the problem?

 

[Guest]

--
Sman

I'm not sure on the problem.
Does the combo display data ccording to a value selected in the main form,
but it doesn't happen when you change the value in the main form?

If that the case you can try refreshing the combo on the AfterEvent of the
field in the man form

Me.[SubFormControlName].Form![ComboName].Requery

If that is not the case, can you explain the problem?

--
Good Luck
BS"D

The combo box will return the correct data on the subform if opened directly,
but when I activate the combo box on the subform from the main form, it loses
the paremeter value. Any suggestions!

 

[Guest]

Can anyone help? My form loses it combo box paremeter value.

Sman

 

[Guest]

Hi Stephen

I have exactly the same problem and have spent 3 days trying to figure it
out. Have you got anywhere with it yet?

Penny

 

[Guest]

FYI

I have fixed my problem, may be same as your problem.

It appears the Subform name was different to the Subform Control name on the
main form, therefore subform wouldnt work when opened with main from. Try
recreating your subform and combo box from scratch and relinking to mainform
making sure Subform name and Subform Control name match.