SetFocus after Cancel in BeforeUpdate - Microsoft Access / VBA

I am checking for null fields in a BeforeUpdate event handler. If I find one, I set Cancel=True, set the focus for the empty text box and exit the event handler. When I return to the form, there is no focus at all. If I press the Tab key, nothing happens. I need to click in a text box to re-establish the focus.

I get to the BeforeUpdate Event handler by clicking an AddRecord button which is attempting to execute a GoToRecord acNewRec statement, placed there by the wizard that generated the code for the button. I get the impression that this statement is somehow canceling my setfocus, even though the action has been canceled.

Is there any way that I can programmatically set the focus?

Aug 13 '07 #1

Subscribe Post Reply

2919

JKing

1,206

Expert 1GB

You have posted your question in the Articles section rather than the Forum section.

I have moved it across for you.

MODERATOR.

Aug 13 '07 #2

missinglinq

3,532

Expert 2GB

We need to see the entire BeforeUpdate sub.

Welcome to TheScripts!

Linq ;0)>

Aug 13 '07 #3

Similar topics

SetFocus

by: Steve | last post by:

I'm at my wits end here. Can someone tell me why this advances to the next field rather than stay in the pWord field. Thanks in Advance. Steve Private Sub pWord_AfterUpdate() If Forms!! <>...

Microsoft Access / VBA

Cancel Change In Option Group

by: Corrine | last post by:

Is there a way to cancel a change in an option group? The option group still changes to the option clicked on when clicking on the NO button with the following code in the BeforeUpdate event of the...

Microsoft Access / VBA

cancel as integer and the like: why and how

by: WindAndWaves | last post by:

Goodmorning Gurus Here is another of my questions..... When adding code to a control then access sometimes puts in a couple of 'parameters'. Can anyone tell me what the use of them is. I have...

Microsoft Access / VBA

a2k - offering a Cancel option

by: Deano | last post by:

Alot of my forms are bound. I would like to offer a Cancel option so that they can make as many changes as they like and still Cancel out without making any changes. I have one idea of how to...

Microsoft Access / VBA

Why doesn't A97 cancel the click event?

by: MLH | last post by:

I tried the following code to prevent a checkbox from being updated (going from a value of Null to True, from True to False or from False to True). I was surprised it did not work. Can anyone...

Microsoft Access / VBA

Cancel BeforeUpdate and Return To Old Value

by: PC Datasheet | last post by:

In a form/subform I have an unbound combobox in the form header that sets the value of a field in the subform so that it does not have to be entered for each record. In the BeforeUpdate event of...

Microsoft Access / VBA

Can setfocus on a field error 2108

by: SDL | last post by:

The code below says error 2108 must save field before setfocus? All I want to do is check out the input field and if in error set the cursor back on it after the MsgBox displays. In this case I...

Microsoft Access / VBA

Problem with SetFocus

by: Jim Devenish | last post by:

In my application vehicles arrive and depart from a workshop. The ArrivalDate and the HandoverDate are each entered. Sometimes the person who should enter the arrival date forgets to do so. ...

Microsoft Access / VBA

SetFocus Issue

by: agroover | last post by:

I can't seem to figure out how to get rid of the errors. I recieve the following error when I leave the Grade.SetFocus in my code... Microsoft Access can't move the focus to the control Grade ...

Visual Basic 4 / 5 / 6

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice