Access not responding

[Gismo]

Hi All,

my DB seems to work fine in all the forms, except for the one form.
opening the form times out, then access closes down and opens up again
any explanation as to why this happens?
i did a compact and repair as well as a debug

 

[Gismo]

I found the error
it is in my vb, the me.requery seems to go into a loop

 

[The_Doc_Man]

Do you have default values declared (including something that asserts values in the Form_Current routine)? I believe that event fires after any time that a dirty record is saved.

 

[The_Doc_Man]

It has been a while so I'll take your word for that, Pat. An implicit save might indeed evade the event. Though based on a previous project, I thought that a DoCmd action to save the current record (without navigating) nonetheless fired the Current event. Because my forms surely acted as though that happened.

 

[Deleted member 147267]

The Current Event only fires if you move to a new record.

Not true. It fires when a form opens also.

 

[isladogs]

The MS article on the Form_Current event states that it

Occurs when the focus moves to a record, making it the current record, or when the form is refreshed or requeried.

See https://docs.microsoft.com/en-us/office/vba/api/Access.Form.Current

 

[Deleted member 147267]

Your quote leaves out the "or occurs when the form is opened" which makes it a bit misleading IMHO.
@Pat - say what you will about the lack of info from the OP but admit it when you are incorrect or incomplete and it is pointed out instead of deflecting. Lord knows I have to do that more than I care to admit.

 

[CJ_London]

just to weigh in

Your quote leaves out the "or occurs when the form is opened" which makes it a bit misleading IMHO.

this link explains the current event fires when a form is opened

https://support.microsoft.com/en-us...ects-e76fbbfe-6180-4a52-8787-ce86553682f9#bm3

Opening and closing a form

When you open a form, the following sequence of events occurs for the form:

Open

Load

Resize

Activate

Current

 

[Deleted member 147267]

CJ, so does Colin's but the quote doesn't drill down that far.

This event occurs both when a form is opened and whenever the focus leaves one record and moves to another. Microsoft Access runs the Current macro or event procedure before the first or next record is displayed.

 

[Deleted member 147267]

You sound just like those "Black lives matter" protesters who are making the police kneel to them.

Wow. Surprised you would even go there.

I wasn't even snarky.

No, you went straight to insulting instead.
Sorry for what's happened to your thread Gismo. I'm going to unwatch to try to prevent any further soiling of it.