Losing Unique table property in form

[BobJacksonNCI]

Using Access 2000 .adp with SQL 7 backend.

I have a form that uses an SQL select statement as the data source. There are two tables so I indicated the one that needs to be updateable in the Unique Table property of the form. It works (allows updates). Then, later, it doesn't work. When I check the Unique Table property, it's blank.

Has anyone dealt with this and/or have a simple solution?

Considering setting the property at Load time, but would like to understand.

TIA! (Thanks In Advance)

 

[cmmrfrds]

I have had the same thing happen when modifiing the Form. I believe it was when I modified the SQL Source for the Form, but can't remember for sure.

 

[BobJacksonNCI]

Thanks for your input!

It hasn't happened again... (crossed fingers)

I'll keep your input in mind. Although I didn't think I 'done' it, I may have been working on a different copy. Or, even though I was sure I saved changes (especially when they worked!).

Bob