Runtime error 2186: This property isn't available in Design view

[Pookiemeister]

I'm learning how to use a listbox in access 2010. Normally I will use YouTube as a visual guide when I am stuck. One of the tutorials shows how to show the selected value of listbox by using the Immediate window. So I entered the following inside the immediate window: This is my information not from the video
"?Forms!frmMaintenanceEntries!lstAdjustment" and according to the video, it should return the word "NULL" but mine returns the value "Runtime error 2186: This property isn't available in Design view". I'm not sure if it matters, but the demonstration was done in office 365 or Office 2019. Thank you.

 

[Micron]

If you care, yours doesn't "return a value", it raises an error. It should work as long as you didn't use quotes like that. Your syntax is OK but I would replace the second bang (!) with a dot. If Access thinks you're invoking a property you might have some corruption going on as there's no way that lstAdjustment is a property. Or is the selected value being confused with a property because you've used a reserved word in the bound field name or one or more row values?

 

[Pookiemeister]

I got it to work and all I did was restart access, Retyped the same information in the immediate window and it worked. Thanks for you help.

 

[welshgasman]

I got it to work and all I did was restart access, Retyped the same information in the immediate window and it worked. Thanks for you help.

I think that it is likely the form was not in design View when you got it working?