Record Source is being Corrupted that drives Form

[CementCarver]

Solved it. I added the three new fields while in the sql statement design window, which it successfully saves my additions. But then I go into the view code, and from the left hand side project window, I select the form in questions. Below the form name are the same attributes that you see in the properties window. I copy the sql statement from there and save it to a text file.

I then go back to the form design window and add my three fields. Right after this I check the form properties data tab and yes, the sql statement is corrupted again. But I take the sql statement that I've save and copy and paste it over the frm sql statment from the far left hand side while viewing the code, then I paste this sql statement back and this solves the problem.....!!!



What the heck man...... What a work around..... but at least it's solved.

CementCarver

[CementCarver]

Solved it. I just added the three new fields to the form's sql statement and then went to tehe project window for the form's sql statement and saved this string to a text file. Appended the form with the three new fields and then reviewed the record source again, and it has been corrupted again. Copied and pasted the string I save back over top of the sql statement in the vb project window and this solved the corrupted recordsource.

CementCarver