Access MS Access 2003 forms do not work anymore after changing data type

M

mgjdun

Joined
Oct 31, 2011
Messages
2
Reaction score
0
I have 3 search forms without subforms, and also 2 search forms with subforms. In a table I changed the data type of a field from 'single' to 'long integer'. Now all my forms without subforms don't work anymore: I can use them to search for records, but I cannot change records anymore.
My forms with subforms still work fine.
 
I found the problem. I made a new 'long integer' field and filled it with values from the original field. Then I removed the original field and renamed the new field as the original field. Afterwards, some forms did not work properly anymore.

If I just change the data type of the original field, all forms function just fine.
 
Back
Top