I have a form with two subForms (A and B)
Each of the subForms has three fields on it. (1,2, and 3)
The problem with the way tabbing works is that it keeps the tabbing within a subForm.
If you go to this form and hit the tab button you cycle through the first subForm
A1 -> A2 -> A3 -> A1 -> A2 etc
Is there any way to have the tab effect from field A3 go to B1
I hope this is clear
Thanks
Hi guys
I have a form with a large amount of subforms on it.
The problem I am having is that I cannot tab between subforms when entering data.
The cursor just moves within the subform and browses off of the current record (Creates a new record, like when scrolling the mousewheel).
Anyone know how I can set it up so that I can tab betweek all subforms across the entire form and not create a new record?
In addition, I know access 2000/97 users had to use custom code to disable the mousewheel, but I read something somewhere saying that you can disable it in Access 2003 without using code? How do I do this?
Thanks,
Toby
I have search the forum and have found many solutions to this same problem but so far none have worked for me. I am fairly new to Access so maybe I am just not understanding properly.
I have a form with a main form and many subforms. All subforms but one are continuous and the other is a single form that does not allow additions.
1. I can tab from the main form to the first subform but can’t get the next subform.
I have tried this on the exit of the first combo box in the subform
Private Sub EventInitialActionTaken_Exit(Cancel As Integer)
If IsNull(Me.EventInitialActionTaken) Then
Me.Parent.[frmeventFsubform].SetFocus
End If
End Sub
This works until I open a new record from one of the subforms and then I get an error.
2.Then, my last subform is the single form with no additions and I want it to tab to a command button on the main form. Right now it just goes in circles throughout the sub form
3.Also, if I ask to start a new record while my cursor is in one of the subforms, the new record will open with my cursor in that subform field. How do I get it to default to the first field in the main form? I tried Me.EventID.Setfocus on the On Load Event of the main form but this didn’t work.
I think that if I get the answer to question 3 then the code I previously used in question 1 might work.
Any help would be greatly appreciated.
Thank you in advance.
I have searched this site and tried several things over the last 3 days and am getting frustrated. All of my forms are built from existing tables.
I have a main form (frmevent) with the primary key being EventID. I have many "continuous" subforms e.g. event type, initial action taken, initial outcome that the user can enter more then one record.
My Event Type continuous subform has a cascading combo box. One combo box displays the Event Category and the other combo box displays the Event Types. I have the cascading combo working so that when the category is selected on those types that apply to it show up.
If the user tabs to the next record and doesn't enter anything in it I want it to tab to the next sub form.
I tried (please note that EventInitialActionTaken is the first field in the form)
Private Sub EventInitialActionTaken_LostFocus()
If IsNull(Me.EventInitialActionTaken) Then
Me.Parent.[frmeventFsubform].SetFocus
End If
End Sub
I am getting a run-time error on the form '2452' The expression you entered has an invalid reference to the Parent property.
What does this mean and can anyone help.
Thank you in advance.
Hi Guys & Gals,
I have 2 main forms for my database, both with multiple page tabs (I will call them pages to avoid confusion with tabs) and subforms.
I can set the tab order for the various pages to go through the fields and jump to the subform ok. 2 small problems I haven't been able to sort out are:
1) Once I have tabbed into a subform, in datasheet view, the tab takes me through the fields and then to a new record when it reaches the end. I can't tab out of the subform back to the page I came from and onto the next object.
2) When I tab from the last control on a page I want the focus to go to the first control on the next page of the form but what actualy happens is the next record is opened.
Neither of these are a big deal but it means using the mouse when I would rather navigate with a quick click. If I cannot set the tab order to get what I want for item 2, is it possible to put a control button on the page with some code behind it to move me to another page of the form in the same record?
Many thanks in advance.
Regards,
Keith.
I am trying to setup 3 text boxes to autotab once the required input has been put in.
I have in the table assigned each field the max number that can be inputted, which is 3, 4 and 5. Now when inputting it stops and you have to manually tab to get it to move over which is fine and good...but who I am designing this for wants it to tab. I could use input mask but it uses place holders which I dislike greatly.
I am looking how to do this in code, I am not sure which commands to call up. Right now I have this:
Private Sub Branch_Change()
If Branch.length = 3 Then
DoCmd.RunCommand acCmdTabOrder
End If
I am still learning my code, so laugh at will :) cause I am sure none of that is right. Thanks.
Is there any way to change the order that the tab button cycles through the different fields in a form? Right now mine jumps ALL over the place and in some case even misses a field.
View 1 Replies View RelatedHello all,
A quick search yielded no results, so here goes. What is the easiest way to automatically tab to the next field once a user has entered the maximum number of digits in the current field?
For example, I have a form with the 3-digit area code in one field, followed by the 7-digit phone number (this was set up originally by someone else, I don't know why the area code and phone number are split up). Since these fields will always be the same length, what I'm wanting to do is automatically set focus to the next field once the user has entered 3 numbers in the area code field, without their having to hit the 'Tab' key. Any thoughts?
Thanks in advance...
I forum could someone tell me:
I have an unbound form on that form I want to put three sub forms one on a products table the other on a course start dates table and the link table that joins the other two together. all three are related to each other with Pk/FK links.
When I try to link them it says you cannot link items on an unbound form.
regards in advance
Peter:eek:
everytime i try to tab from my subform, it creates a new record for that subform. Also, about the subform, the control that links the main form and sub form is unique.
I have now set my Cycle property on my subforms and forms to Current Record. How can I tab from the subform to the main form and vice versa?
Thanks!
I have a combobox where users can select classes. In the AfterUpdate event for that combobox I have the following code:
Me.ClassCode = DLookup("[ClassCode]", "Classes", "[ClassID] = " & Me.ClassID.Column(0))
I want to populate the Class Code field based on the class they select. The code works fine except that the Class Code field does not update until after I tab past it. There is a field in between Classes and Class Code so I have to tab 3 times before the textbox populates. I expected the textbox to populate immediately after I selected the class. I also tried putting the code in the On Click event of the combobox but that didn't work either.
If I just keep clicking on different classes I'd like the class code to change each time without having to tab to another field. Is that possible? What am I doing wrong?
Rod
Hello all,
This is my first post to these forums, however I have leeched so much information off of all you guys that I can't even begin to express my gratitude. So, now, onto my problem...
I'm developing a form for our call centre people to enter information regarding customer returns. Customer orders are placed on one of two systems. In my form, when the person is entering info, I have a drop down box to choose between the two systems, which calls up a respective subform to enter system-specific information. The problem I have is that I can use tab to enter the subform, however I can't use it to get out. There are two records in the subform - order date and order number. After I enter info into these 2 textboxes and try to tab out, it seems that the subform goes to a new record. How can I get my form to tab into the next required field on the main form? Hopefully this makes sense, I just read through it and its kinda questionable. Thank you very much in advance.
Hi,
I have a form with a number of fields and buttons on it. The form is opened in "add new record" mode. I have noticed that when I move from the last field in the tab order to the first field in the tab order it saves an entry in the database.
This is causing me problems because when users move from the last field in the tab order to the field in the tab order an entry is saved to the database but it by passes all the data checks ensuring that certain fields have been filled-in etc.
I don't know why the movement between these two fields is causing an entry to be saved. I don't have code associated with either of these objects. I aslo changed the last field in the tab order to a different field and it still happens.
Any ideas or suggestions would be greatly appreciated.
hello,
I have a main form with one child form. This child form also has a child form. This last child form has two tab controls it. When I tab through fields on the form, I have to reposition the form so that I can see these last fields. Otherwise I have to tab blindly through them. How do I get the form display the fields as I tab to them ? I have to design the forms on the larger size because the users like that. Any suggestions would be appreciated.
thanks !
Is there a way in data access pages to have where the user tabs to a numeric field in an existing record, that it highlights the data? Or....... is there a way to have currency values null instead of $0.00 in an existing record on a data access page?
The problem I'm having is: For my data access page, the user queries to pull up an appointment. The user then enters various amounts in different fields. I have the tab order set up ok, but when they tab to a field to add an amount collected, it tabs to the end of the $0.00 which makes the user have to backspace 3 times to enter data, or highlight and delete and then enter data....... All of this, of course, is time consuming.
These values are null, but show as 0 in my data access pages.
How can I get these to remain blank, or how can I get it to highlight the data in each field on tab?
Thanks in advance.
Hi,
I created a form based on head/detail/foot kind of setup.
Now in the detail I have a combo box and a textbox. Is it possible for me to set focus to the next line textbox after the combo box fires onExit trigger?
so for instance:
form is empty. Fill in textbox, choose from dropdown, and then on Exit the focus is set to the next line textbox.
Thanks,
I have a form with a tab control on it. The input for respective fields are placed inside the tab control, and I have the "Confirm" button placed outside, on the main form. Now I wanted to be able to navigate my focus from a control from inside to tab control, out to the Confirm button on the form, to allow smooth flowing data entry.
However, it seems like Access separates the tab indexes for the controls in the tab control and outside on the main form, so setting tab index does not work. I tried using the code ON LOST FOCUS and SET FOCUS;
Private Sub txtPurchaseNote_LostFocus()
Forms![frm Imported]![cmdConfirmPurchase].SetFocus
End Sub
But then a dialog box appears:
Run-time error '2110'
Microsoft access can't move focus to the control cmdConfirmPurchase
(cmdConfirmPurchase is a button control)
I have an interesting Access problem. When doing a query, and it does not matter which Access file it is all of them do it, if you tab out or click to another screen, sometimes, the query will stop. I have tried many different network related fixes but no luck. I am thinking the issue is with Access. I have no issue with Excel on Access files.
View 3 Replies View RelatedNewbie Access user here, with what I hope is a fairly easy task--
I have a form which contains fields for info about clients and a subform which has only one field for a corresponding video tape number. Is there any way to limit the record for this subform to one single entry, so that when I hit Tab after entering the single number, the second record in the subform will not appear, but rather I can jump to the next record in the main form?
If not, then can I just tab through the main form, into the sub form and then onto the next record? Is there a shortcut to create the next record other than having to manually mouse click the next record arrow at the bottom of the form?
I have a form with 5 subforms in it.
I am using recordsets to step through a table that contains a field with the names of the subforms.
Depending on the code, I want to make visible or hide the subform for that particular record.
ie Table has 5 records with a field called subForm. the values are as follows:
Record1: Field1: Value="Yes" Field2: Value="subForm1"
Record2: Field1: Value="Yes" Field2: Value="subForm2"
Record3: Field1: Value="Yes" Field2: Value="subForm3"
Record4: Field1: Value="No" Field2: Value="subForm4"
Record5: Field1: Value="Yes" Field2: Value="subForm5"
When I step through the table if the code finds "No" in Field1 then id makes the subform referred to in Field2 invisible and if it finds a "Yes" it makes it visible.
Can anyone help me with this?
Does anyone know how to have a datasheet view in a subform fill the top of the main form?
I want to be able to see the records in a datasheet view and when the record in the datasheet view is selected it prefills the top of a form ?
This is a question from yesterday that a member had helped me out with.
I have additional questions while I am waiting for response from him. If anyone of you can help, I would really appreciate it.
1. How can I make a form that gathers information from multiple tables?
2. Lets say it is possible, how does this info get saved to these multiple tables when the user clicks on the next record button on the record navigator.
Thanks for the assistance!
is it possible to have more then 2 subforms?
Lynda
Heya --
So if I haven't scared everyone away with the post's title, maybe someone out there can help me. I need it.
I have a many-to-many relationship with the following tables:
Companies
CompaniesProjects
Projects
I also have a query with the following:
CompaniesProjects.CompanyId
CompaniesProjects.ProjectId
Projects.*
Pretty straightforward. Now, I have a form to view Companies, inside of which is a subform listing Projects associated with the Company using the above query.
The issue that is stumping is that I would love to be able to add a new project from the subform. I thought it would be pretty easy, but I'm totally dry. I guess I need to grab the CompanyId from the parent form, and assign it to the new record before I can add any more data to the new record. But I have no idea how to do this, or even if it is the right thing to do.
Any help would be _greatly_ appreciated. I've been slamming my head against a wall with this for two weeks.
-Lucas
Hi,
I have 3 tables : Products, Description and ProductDescription. Products can have more then 1 description, Descriptions can be used by more then 1 product, that is why the third tabel ProductDescription exists (normalizing..:) ). The Productdescription table has 3 fields: id, productid, descriptionid.
I want a form in which you choose a product, then you see all the descriptions along with it. In this same form I want to be able to add a description, e.g. by pushing a button NEW. After that user enters description form etc. After returning to the mainform, a new record must be automatically added to the ProductDescription table and ofcourse a new record has been added to the Description table. I thought I would use subforms to realize this but it isn't working..:( . I have tried so many things that I dont know anymore what to do, i am totally confused. I know how to program in VB and ACCESS, but for now i don't see it anymore. Can someone please help me with this?
I just need to know how to start, what to use as subform and what as masterform, which links between fields, etc
nelleh:rolleyes:
Just a quicky.
I am trying to design a form with three subforms.
I keep getting tblXXX not in recordset.
Is there perhaps something wrong with my relationships?
Thanks,
Brian.
Zimbabwe.