Changing form values from a macro

[barboza]

I have written the following macro that is in module 1.

Sub Test()
DoCmd.SelectObject acForm, "frmCustody"
frmCustody.Me.Controls("F9").Value = "Ag"
End Sub

I get the following error: Object required.
Any ideas how to get the value to show up in the form when the macro runs??

Thanks,
B

 

[boblarson]

I have written the following macro that is in module 1.

Sub Test()
DoCmd.SelectObject acForm, "frmCustody"
frmCustody.Me.Controls("F9").Value = "Ag"
End Sub

I get the following error: Object required.
Any ideas how to get the value to show up in the form when the macro runs??

Thanks,
B

The correct syntax is:

Forms!frmCustody!F9 = "Ag"

OR

Forms!frmCustody.F9="Ag"

OR

Forms("frmCustody").Controls("F9").Value = "Ag"

The first two don't need .Value specified, but the third does and all three will accomplish the same thing.

 

[barboza]

Many Thanks

Thanks Bob.

Once again, you are right on the money!

 

[boblarson]