Design View Properties do not match Form View Properties

[Will]

I am having problems with the LimitToList Function. I
want it to be set to "No". I have the BoundColumn set
correctly to 1. It will remain as such if set in design
view. The problem is that if I look at the properties in
form view, the bound column sets itself to 2. If I change
it to 1, the LimitToList function works perfectly. It
prompts me to save the changes but it doesn't. As soon as
I close the form and reopen it, it doesn't work again. I
open the properties and the BoundColumn is set to 2
again.

 

[Sam]

Some possibilities:
1. You don't have exclusive access to the database so changes to design
can't be made.
2. Seems unlikely, but maybe some existing VBA code is setting the
BoundColumn to 2 as the form opens.

HTH
Sam

 

[Will]

I do exclusive access to the database. It resides on my
computer only. I will check in to the VBA code.