Requery a combo box on current record

[dawnd3]

Hi there, I have a combo box in a subform that is filtered dependent on a combo box in the main form. (this works fine) However, the values don't update when I switch records. I tried putting this code in the oncurrent event of the main form:

DoCmd.Requery (Forms!frmItemSub![cboPlan])

but it didn't work. Do I have the syntax correct to reference a field in a subform from a main form?

Dawn

http://www.calliopeconsulting.net

 

[Guest_imported]

You might try this
Forms!MainFormNameHere!frmItemSub![cboPlan].Requery
Paul

 

[dawnd3]

I tried that and also the following:

DoCmd.Requery Forms!frmPurchaseOrders!frmItemSub![cboPlan]

and

Me!frmItemSub!cboPlan.Requery

No luck! Anyone????

Thanks for your response

Dawn

http://www.calliopeconsulting.net

 

[dawnd3]

I have also tried

Forms![frmPurchaseOrders]![frmItemSubForm].Form![cboPlan].Requery

Nothing works!!!

http://www.calliopeconsulting.net

 

[BusMgr]

Dawn

If you get this could you let me know as I am having the same issue.

Thanks

BusMgr
krspring76@hotmail.com

 

[mscraig]

Try using the Requery command on the individual objects.
I have had some success that way.
Example:

TextBox1.Requery
Combox1.Requery

Put this code in the On_Change or After_Update commands in your form coding. You can Requery all or just some of your text controls this way.

 

[dawnd3]

thank you I will try that I am having another issue with it now so I will let you know when I try it. Dawn

http://www.calliopeconsulting.net