Search results

@theDBguy I'm going to build a mock db with the navigation and events form and all the VBA code and post it. Maybe with a demo example someone can figure out a better way to set up the code and isolate this issue.

He's tracking my personal issue and we didn't figure out what my issue is on my end. It appears localized to me.

I've changed all of the Spelling checks to a BeforeUpdate event. I feel that the code still isn't acting right and further troubleshooting is needed. If the sequence of a form's code is supposed to be as below, ….. When you first open a form, the following events occur in this order: Open →...

Disconnected the other monitors. Restarted the laptop. Using only the laptop. The resolution is 1366 x 768 (Recommended). Landscape. Opened the Access file with TreeView and the same issue persists. Next idea please.

Here's my end goal. Stop the Event field from running the Spell Check when the Form Opens. When the form opens, put the cursor in the textsearch and STOP.

My main monitor is a 43" 4K 2160 pixels UHD. Just sliding the Access file to another monitor doesn't change the behavior.

Where would I create this event procedure to see it firing? I'm still guessing me way forward with your guidance.

I think I'm answering your question. The textsearch box has no Events tied to it. The Event Field has 3 Events within it. AfterUpdate, On Lost Focus and On Key Down. Private Sub Event_AfterUpdate() 'refresh the current record to obtain a primary key Me.Requery 'Resort list with...

Nope. I'm still confused. You mentioned before that SetFocus and LostFocus events happen in pairs. In my mind the sequence that I have makes sense but obviously that isn't the case.

Good guess. Textsearch is in the Form Header and Event field is in the detail section.

Any thoughts from the community on this behavior?

Thoughts from anyone on the attached file and troubleshooting?

Can anyone explain why my code is triggering a LostFocus event next after the Form_Open event? All of this is happening before the user can even see the form. The first time they see the form it's doing a spell check, which isn't the behavior I'm looking for. I just want the form to open and...

So change the original code from variant to date?

It is my intention to get the formula (see below where I hard pasted it in) or field that represents it (MaxDate) into the OrderBy not a specific date value. So this is the current state of the form. I've removed the OnLoad vba. We'll see if this holds.

So I'm causing this to myself because of how I'm interacting with the forms?

Here's what I'm seeing in design view. Why is it choosing a specific date vice the function MaxDate to do this sort?

Step 7 on your list, after everything was looking so good. The OrderBy got populated again with a date. So, what are you thinking now?

Sorry, I got confused on who I was responding to.

When I copied and pasted from the code posted in message #6 I got the above result. It's all good. I'm fine on this one for now. Thanks.