473,770 Members | 1,991 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Tabbing into field causes form to go to next record

Sam
I have some required fields on a form. I'm checking these fields in
the Form_BeforeUpda te sub. When just clicking on the fields and then
trying to go to the next record by clicking on the little arrow at the
bottom of the form it works as intended (A message box pops up telling
the user the field is required and sets focus to the next field in my
If Else statement), but when I tab into the field (any field) the
message box pops up telling the user the field is required and then
goes to the next record. I have no idea why this happens and I haven't
been able to find anything on this. Can anyone help me here?

Thank you in advance.

Jun 19 '06 #1
5 3040
AP
Looks like the form 'Cycle' property (other tab) of form properties is
set to all records, when you tab off of a control that is last in the
tab order it will take you to the next record. Either change cycle to
current record or arrange you tab order.

Sam wrote:
I have some required fields on a form. I'm checking these fields in
the Form_BeforeUpda te sub. When just clicking on the fields and then
trying to go to the next record by clicking on the little arrow at the
bottom of the form it works as intended (A message box pops up telling
the user the field is required and sets focus to the next field in my
If Else statement), but when I tab into the field (any field) the
message box pops up telling the user the field is required and then
goes to the next record. I have no idea why this happens and I haven't
been able to find anything on this. Can anyone help me here?

Thank you in advance.


Jun 19 '06 #2
Sam
Thanks for the reply AP. I tried changing the 'Cycle' property of the
form properties to current record with no luck. My tab order is
correct. These fields are in the middle of the form (and in the middle
of the tab order)...so they're not last in the tab order. Any other
suggestions?

Thanks again.
AP wrote:
Looks like the form 'Cycle' property (other tab) of form properties is
set to all records, when you tab off of a control that is last in the
tab order it will take you to the next record. Either change cycle to
current record or arrange you tab order.

Sam wrote:
I have some required fields on a form. I'm checking these fields in
the Form_BeforeUpda te sub. When just clicking on the fields and then
trying to go to the next record by clicking on the little arrow at the
bottom of the form it works as intended (A message box pops up telling
the user the field is required and sets focus to the next field in my
If Else statement), but when I tab into the field (any field) the
message box pops up telling the user the field is required and then
goes to the next record. I have no idea why this happens and I haven't
been able to find anything on this. Can anyone help me here?

Thank you in advance.


Jun 19 '06 #3
In Properties area:
Are all of the fields marked as tab stop Yes?
Single form or Continuous Form or Datasheet?

Are you getting blank records (extra records) in your table?

Is me.dirty used anywhere in the code for the form.

Ron

Jun 19 '06 #4
Sam

Ron2006 wrote:
In Properties area:
Are all of the fields marked as tab stop Yes?
Single form or Continuous Form or Datasheet?

Are you getting blank records (extra records) in your table?

Is me.dirty used anywhere in the code for the form.

Ron


Hi Ron. Thanks for the reply. In the properties area for the form the
Default view property is set to Single form. Tab stop is set to Yes on
all text and combo boxes on the form. No, I'm not getting any blank
records in my table.

me.dirty is not used anywhere in the code for the form. I hope that
helps.

Thanks

Jun 20 '06 #5
Well you have eliminated all of the easy posibilities.

I am afraid I cannot think of anything right now. I will have to think
on it for a while.

Perhaps you might add a docmd.canceleve nt to the routine that is giving
you the error message.

And I will continue to think about it.

Ron

Jun 20 '06 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
2207
by: Warmonkey | last post by:
Hi there, I have been frustrated by the 'next record' problem when a user tabs off the last control on a form. I have tried a couple of the suggestions listed on the newsgroup, but so far nothing has solved the problem in relation to my database. I have 3 subforms on the form and serveral other controls (such as buttons). When the final subform receives focus (a one-to-many style
1
1700
by: Ben | last post by:
I have a Tabular form bound to a table. The purpose of this form is to get times from a timer and record them in a field. The timer dumps the time automatically through a serial port. When the time is recorded it goes to the next record. Sometimes a user may have to skip a record and come back. All of this is no problem and works great. I have 3 buttons that will set any penalties in a record. The person just needs to hit a button to...
9
3337
by: William Wisnieski | last post by:
Hello Everyone, Access 2000 I have a main form with a continuous subform. On the main form I have a text field called . It gets populated based on what the user selects in a field on the sub form (code in the AfterUpdate Event). Here's the issue. If the user deletes a subform record. The field on the main form shows null even if there is a value in the preceding subform record. What I'd like it to do is immediately refresh to
3
14554
by: William Wisnieski | last post by:
Hello Again, I'm really stuck on this one.....so I'm going to try a different approach to this problem. I have a query by form that returns a record set in a datasheet. The user double clicks on a row and a main form (pop up) opens bound to a table with a continuous subform bound to another table. On the main form is a field called . It is vital that this is
25
10265
by: Lyn | last post by:
Hi, I am working on a genealogy form. The only table (so far) lists everybody in the family, one record per person. Each record has an autonum ID. The parent form (frmMainForm) displays the data in each record, which includes the ID of the father and the mother (who also have records in the table). One record per form. I have a Tab Control in the form, and in one of the tabs I have a subform (sfmSiblings) in which I wish to list...
2
2421
by: Rooksarii | last post by:
Hello folks, Let me first apologize for any impropper terminology I may use as I am presently trying to broaden my Office knowledge by diving into Access head on. My specific problem is this. I have a field in one of my tables that references a value in another table via a list box. Next to it, instead of manually creating another list box to go along with it, I would like to have this other field acknowledge that the value in it's...
11
12622
by: pmarisole | last post by:
I am using the following code to split/join values in a multi-select field. It is combining all the values in All the records into one long string in each record in recordset. Example: I have a recordset with 2 records. The 1st contains the split/joined values: Alan Smir, Jeff Karl The 2nd contains the value: Keith Robb When it updates database, it will put Alan Smir, Jeff Karl, Keith Robb into each record in the recordset
2
19609
by: Brett | last post by:
My database has 2 tables: Table1 & Table2. If a field is not null on a record in table2, then the not null fields in table1 that correspond to the records in table1 needs to be updated to match the field in table2. What I have is a form that is linked to Table2. If the users want to change a field in the main database (table1), they fill the change in to the form (which is linked to table2) If there is no change to the field, they simply...
6
2246
by: Doug Bell | last post by:
Hi I have a DataGrid with some hidden columns and also some read Only and some ComboBox Columns. Sandard Tabbing through the Datagrid sees the focus go to the hidden columns requiring further Tabbing to get to the desired column but it works fine stopping correctly on the ComboBox column. I have built a routine to test whether the use is Tabbing forward or back (Shift Tab) by looking at the last location, not by trapping the Keys. If
0
9618
marktang
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
10259
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10101
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10038
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9906
tracyyun
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
7456
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6710
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5354
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5482
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.