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.
 
M

mgjdun

Joined
Oct 31, 2011
Messages
2
Reaction score
0
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access MS Access - Multi User Lock Issue 0
Access Access 2003 GoToRecord Problems 0
Access 2007 conversion subforms don't display linked records 2
sub forms which do not update automatically 1
Set Focus error 2110 2
Running Access 2003 db in 2007, and a few forms don't work 12
Refresh data in sub forms when one sub form is edited 4
Form and subform weirdness when linking to SQL Server 2005 via OD 2

Top