Form properties reverting after I save, exit, and reopen

[rmttbone]

Hello,

I am using MS Access 2010, Windows 7 64 bit.

I created a form and set the following properties under the data tab to yes; Data Entry, Allow Additions, Allow Deletions, Allow Edits.

I created two unbounded text fields to allow the user to input dates or use a date selector to chose a date.

When I close the database and reopen it, I cannot place my cursor in either field, and I check the above properties in layout view, and it shows that all the values were changed to no. If I open in design view the properties show yes. After I open in Form view, I can place my cursor inside the two field and use the date selector or type values.

When I close the data and reopen it, the above happens.



I have other forms and this does not occur.

Is there something I can do or is there a setting I can use that will correct this issue?

Thanks in advance Randy

[ranman256]

Is there code in the form?
in the form properties check all EVENTS to see if there is code there to reset it.

-signed
Randy

[rmttbone]

ranman256, No code in events.

[rmttbone]

I just found that when I change the name of the form object, it does not lock? Any thoughts on why this is happening?

[rmttbone]

I resolved the issue. I found DoCmd code in another form that set this form to read only when you opened it with the a command button.

Thanks

[Missinglinq]

BTW, setting Allow Additions, Allow Deletions and Allow Edits to Yes would make one think that you plan on using this Form to view/edit/delete existing Records, as well as New Records. If this is a correct assumption, you need to change the Data Entry Property to No. When set to Yes, this property only allows the entry of New Records...old/existing Records cannot be displayed!

Common sense would dictate that a property named Data Entry would have to be set to Yes, in order enter data! But this isn't true! Assuming that you have an updatable Recordset, you can enter New Records and edit existing Records as long as Allow Additions, Allow Deletions and Allow Edits are set to Yes.

Linq ;0)>