Hello,
Thank you for help, but unfortunately nothing did help.
I've tried everything you suggested.
As I understand, if problem would be possible to solve by
these steps, db wouldn't work before, and in this case it
would not crashed when I close form, which happen now.
By the way, when I made changes according step 3,
property Visible-No didn't work.
All available updates I've install already.
Almost all my forms and subforms have queries in
Recordsource
Thanks,
Mark
-----Original Message-----
Some suggestions.
1. Turn off the Name AutoCorrect check boxes under Tools
| Options |
General. Then compact the database to get rid of any
corruption. More info:
http://allenbrowne.com/bug-03.html
2. Open the main form in design view. Right-click the
edge of the subform
control and choose Propeties. Note the fields in the
LinkMasterFields and
LinkChildFields properties (Data tab of Properties box).
3. Whichever fields are nominated in the
LinkChildFields, make sure they
exist as a *control* in the subform. Usually this means
adding a text box to
the subform for your foreign key, and setting its
Visible property to No.
Although Access should be able to manage even if the
field is not
represented by a control (and used to be able to do so),
recent versions
crash and this should solve the problem.
4. If the problem persists, are any of the fields listed
in LinkMasterFields
not bound to a table field? If so, Access may
misunderstand the data type.
If it is a calculated text box, set its Format property
to "General Number"
or whatever is suitable so Access knows the type. If it
is a calculated
query field, typecast in the query, e.g. CLng([MyField]
+ [AnotherField]).
More info:
http://allenbrowne.com/ser-45.html
Step 3 should solve the problem. If it does not, check
that you have at
least SP2 for Office XP, and SP8 for Jet 4. The service
packs are available
from support.microsoft.com
If none of that works, do you have subqueries in the
subform's Recordsource?
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Mark Remesnitskiy" wrote in
message
...
I have form with subform, and it was working well to
some
point of time, but than when I enter new record in form
and go to subform, or tried to close form, whole
program
shuts down, come up error dialog box with choice to
report to Microsoft, than make backup file, compress
and
repair database.
After opening database again, it is navigating around
form and subform without any problem.
Each new record - everything comes again.
I tried to delete some records, created new database
and
import tables, queries and forms from previous - one
nothing helped
I'm runing Access 2002 on Windows 2000 and XP, on both
some results.
Is anybody have any idia what is going on, and how to
solve this problem
Thanks,
Mark
.