Can't enter a new record in a custom form

[Beverly]

It's hard to explain the problem I'm having without showing you an image of
how my form is laid out so I'll try attaching an image here.

Basically, I've never had a problem entering in a new record (starting with
a new customer name) and then entering information in my Projects subform
and in my Invoices subform. But about a week ago, for some reason, when I
try to start typing in a Customer name, the database freezes up, I see
"Calculating . . . . " in the bottom message line, then the database has to
shut down, create a backup file, then restart.

The workaround is this: If I close the form, go into my table and just
enter the customer name in the table, then close the table, go to that
record in the form and complete the rest of the info in the form, it's fine.
I have no problems.

But if I try to create a new record in the form itself, it shuts down every
time.

Does this make sense to anyone?

Thank you in advance!

 

[tina]

sounds like the system is getting caught in a repeating loop that is
triggered by entering data in a new record. when writing code, or macros,
you have to think through the logic to avoid inadvertently setting up such a
loop. an example would be a calculation in one control which is based on a
calculation in another control, which is based on a calculation in the first
control.

start by reviewing *any* code and/or macro changes, or changes in form or
control settings, that you made before this behavior began. if that yields
no results, suggest you examine any code, or macros, that may be attached to
the main form's BeforeInsert event, or the Current event, or the Dirty
event, or the BeforeUpdate event, or perhaps the customer name control's
Change event, Dirty event, or BeforeUpdate event. if you don't track down
the problem, then i can only suggest widening your search beyond those
events and perhaps beyond the form.

hth

 

[Guest]

Hi Beverly,

...so I'll try attaching an image here.

It is never a good idea to attach any binary file to a newsgroup posting,
unless the particular group accepts attachments. Utter Access
(www.utteraccess.com) is one such group, but you have to first sign up as a
member. In any case, it is better to post the image, and provide a hyperlink,
so that anyone interested can take a look. Your image was not available to me.

It sounds to me like your database has some corruption sneaking into it. Try
downloading a copy of my "Accesslinks.doc" Word document. A zipped copy is
provided here:

http://home.comcast.net/~tutorme2/samples/accesslinks.zip

Try the instructions shown on the bottom half of page 3.


Good Luck!


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________