Access Crashes on Record Source

[Snowman88]

Hi!

I got a very ugly problem and can't seem to figure it out...


I got a form with some underlying code and everything works fine. When I try to put in the Audit Trail and therefore want to use Record Source for the Form property and map a txtbox to the Audittrail field in the corresponding table, Access crashes. Access crashes when i do one of the following:

Put in the Record Source and then:

Save the form

switch to form view

save the VBA code



Any tips? I already checked CPU Usage and its far below 20%, about 7 or 10 most of the time....

 

[MicroE]

Try to compact and repair the database.

If you still have issues try:
http://www.fmsinc.com/free/newtips/access/accesstip7.asp

then try:

Try these commands from the immediate window (ctrl + G:
saveastext acForm,"Form Name", "C:\frm.txt"

Rename your existing report then run this command
loadfromtext acForm, "Form Name","C:\frm.txt".

 

[Snowman88]

It seems that the decompile thing worked! Thank you so much!

 

[MicroE]

You are welcome – glad I could assist.