Subform Control Reference syntax

[Lesg]

Hi Guys,



I have a goods receipt form which has a combobox ( cboprodlist ) to select product to book-in. on the form is a button that opens up a form to add new products if they do not exists currently.

When the new product is entered upon clicking the close button, I am wanting to requery the combox box on the goods receipt form so the new product is now available in the list, however, Ijust keep getting error message saying it cant find the field and is refereeing to the form

I have tried using:

Forms!frmGoodsReceipt!frmGoodsInSub.cboprodlist.Re query
Forms!frmGoodsReceipt!frmGoodsInSub.Form!cboprodli st.Requery

Can anyone suggest the correct syntax please?

[Welshgasman]

Me.cboProdList.Requery

Anyway, here is the syntax as well. http://access.mvps.org/access/forms/frm0031.htm

[CJ_London]

see this link for referencing controls in other forms

http://access.mvps.org/access/forms/frm0031.htm

your second example 'looks' right but perhaps you have more layers of forms?

Always a good idea to rename controls so they don't match the object they contain - helps to resolve issues and avoid conflicts with names. So perhaps use GoodsInSubFrm for the control name rather than frmGoodsInSub

Also make sure you have Option Explicit at the top of every module and compile your code before running to identify any compilation errors.

[orange]

See this tutorial for insight/option.