cannot change row source in listbox

[davyre]

Hi,
I have encountered several issues regarding the row source of a listbox. For example in my current listbox, it has row source like this:

SELECT TblCustOrderUnit.OrderUnitID, TblCustOrderUnit.OrderID, TblCustOrderUnit.UnitID, TblUnits.BSUnitID, TblCustOrderUnit.CompletionDate, TblCustOrderUnit.SerialNumber
FROM TblUnits INNER JOIN TblCustOrderUnit ON TblUnits.UnitID = TblCustOrderUnit.UnitID
WHERE (((TblCustOrderUnit.OrderID)=[orderlist].[value]));

Now when I tried to modify the rowsource, i.e deleting the WHERE clause so the row source would be like

SELECT TblCustOrderUnit.OrderUnitID, TblCustOrderUnit.OrderID, TblCustOrderUnit.UnitID, TblUnits.BSUnitID, TblCustOrderUnit.CompletionDate, TblCustOrderUnit.SerialNumber
FROM TblUnits INNER JOIN TblCustOrderUnit ON TblUnits.UnitID = TblCustOrderUnit.UnitID;

and save the form (CTRL+S), the row source automatically revert back to the old one. Why is this happening? Is there any chance that the form is corrupted?

 

[dhookom]

Are you attempting to save while in design view? Saving in Form view will not save properties.

Duane
Hook'D on Access
MS Access MVP

 

[davyre]

Hi Duane,
Yes I saved it while it is in Design View, or in SQL View. Both doesnt do anything.

 

[dhookom]

I have never experienced what you are describing. I would look to see if any code is changing it.

Do you have Auto Name Correct options set?



Duane
Hook'D on Access
MS Access MVP

 

[davyre]

where can I find the Auto Name Correct options? Strange as I found this problem sometimes, and usually occurs with the old forms(probably created more than 6 months ago)...

 

[dhookom]

Check in the Access Options->Current Database

Duane
Hook'D on Access
MS Access MVP

 

[davyre]

I can see that Track Auto Name Correct and Perform name AutoCorrect are checked, so I guess the Auto Name Correct option is enabled? Should I turn that off?
I cannot check if it is directly affecting the 'troubled' form, as I have deleted that form and remake it with exactly the same row source SQL and it worked just fine.

 

[dhookom]

I always uncheck the name autocorrect boxes.

Duane
Hook'D on Access
MS Access MVP