Tabbing In Forms/ Continuous Subforms
Feb 22, 2006
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.
View Replies
ADVERTISEMENT
Feb 21, 2006
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.
View 14 Replies
View Related
Feb 2, 2006
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
View 3 Replies
View Related
Oct 22, 2004
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
View 4 Replies
View Related
Feb 8, 2005
Okay. I am trying to build a form where I could get information like this but also editable. It can be either bound or unbound with enough information to update the records. I could do this several other ways but would prefer it just like it is below. Any ideas is greatly appreciated. Sam.
REPORT_NAME_1
Active(y/n)
ELEMENT_1 Included(y/n)
ELEMENT_2 Included(y/n)
ELEMENT_3 Included(y/n)
REPORT_NAME_2
Active(y/n)
ELEMENT_1 Included(y/n)
ELEMENT_2 Included(y/n)
ELEMENT_3 Included(y/n)
REPORT_NAME_3
Active(y/n)
ELEMENT_1 Included(y/n)
ELEMENT_2 Included(y/n)
ELEMENT_3 Included(y/n)
View 1 Replies
View Related
May 24, 2006
Greetings all,
I have a question regarding subforms that are set to show continuous forms and how they can relate to each other. I have attached a jpg of what i'm trying to do, you may want to open it so you can follow along with what I will now explain.
I have 3 subforms on a main form. The subform on the left shows high level info. A user would find the record they want in the subform on the left, double click, and that would in turn populate the two subforms to the right.
My question is how do I reference the name field in the record selected in the left subform , for criteria purposes in the queries for the right hand subforms? I thought maybe using the bookmark property but that hasn't worked.
Any help would be greatly appreciated.
TIA,
Tim
View 3 Replies
View Related
Mar 8, 2014
I have a continuous subform recording the information of various wireless products for an employee embedded in an employee main form. Please see screen shot enclosed.
There is a check box "BYOD/Personal" on the subform. I want to hide a number fields when this check box on independent record is checked. However, if I use the following codes, the changes apply to all records under that employee.
Private Sub BYOD/Personal_AfterUpdate()
If BYOD/Personal.Value = True then
Me.Provider.Enabled = False
Me.XXX.Enabled = False....etc.
Else
Me.Provider.Enabled = True
Me.XXX.Enabled = True....etc.
End If
End Sub
How can I just disable those fields on the subform of a specific record when the BYOD/Personal field for that record is checked?
View 8 Replies
View Related
Feb 24, 2005
how do you make them?
i've just started going through all of my forms and making them unbound, as the people i'm creating this program for are far too stupid to create good data with bound forms. a few of my forms, however, contain continuous subforms. how do i get the records to show up for them? it's actually about three levels deep, but i'm sure i can figure out how to take care of that once i hear the concept (customer form > job form > job details [continuous subform]).
thanks guys
added after i saw there's another post on this subject: sorry about the double post on the subject. i looked at the other post on this, though, and was not convinced on how to do it. i understand they're a pain in the buttocks, but these people are REALLY stupid. on second thought, is there any way to have a BOUND continuous subform from an UNBOUND form? for instance, when the user selects the record and it is brought up in the form, the bound continuous form pulls up the records based on the ID's and whatnot? will this work? thanks
View 5 Replies
View Related
Jul 27, 2005
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 Related
Oct 21, 2013
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)
View 2 Replies
View Related
Feb 2, 2006
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.
View 1 Replies
View Related
Mar 29, 2006
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.
View 1 Replies
View Related
Nov 22, 2013
I have several Suppliers, each of whom holds several SalesEvents. At each SalesEvent I might buy none, one or more Bundles. Each Bundle then contains one or more Items. These relationships are all reflected in my Access 2013 desktop db as one-many relationships with cascaded updates.
My form structure for data entry reflects the Relationships, in that I have a Supplier form with a SalesEvents subform. On that subform I can enter data about each of that Supplier's SalesEvents, and each SalesEvent row has a button to call up a SalesEvent form which has a Bundles subform. Then each row of that subform has a button which calls up a Bundle form containing an Items subform. That Bundle form identifies the Supplier, Sales Event and Bundle number, and within its Items subform I can then enter the data for each Item.
Problem : All used to work fine, but I've clearly changed something because now when I select the Items button on the Items subform in the Bundle form, the system gives me the data for the first record in the SalesEvents table, rather than the one selected. I have checked the raw data and that's as it should be. I have tried to undo all the steps I took since it last worked properly, but to no avail. Restoring the last backup (taken when I'm sure it worked properly) still has the problem.how do I find what data is actually being passed between forms and subforms ?
View 3 Replies
View Related
Jun 19, 2006
Hello 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...
View 8 Replies
View Related
May 29, 2015
I have a bound continuous tabular form,However, based on data content in one field of a record, I want a checkbox in the same record enabled, so the user can check it if necessary. I have created a record set using the form as shown below, and I am looping through each record. To show that my code is referring to the field with required data content, I display it as a message box and it works, yet my checkbox does not enable.
I have the code in the form_load event, however, for testing purposes I have it behind a button.If I am seeing this properly, the code behind the button enables the checkbox for ALL records once the criteria in the required field is true, and based on the last record, which has no data content, it disables the checkbox in ALL records. I also have the PK ID for each record hidden in the form. Can I utilize that to target the checkbox of each individual record??
Form Detail
-Form does not allow additions or deletions. Edits allowed
-All fields are disabled and locked
-I only want the check box to unlock if data is found in the "RequiredField" as referred to below. I have also tried if not isNull(requiredfield.value) then -enable checkbox, which yields the same results
Here is my code
Code:
Dim rstMyForm As DAO.Recordset
Set rstMyForm = Forms!MyForm.Form.Recordset
rstMyForm.MoveFirst
Do While Not rstMyForm.EOF
If Not RequiredField.Value = "" Then
[code]...
View 14 Replies
View Related
Feb 4, 2006
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:
View 1 Replies
View Related
Jun 29, 2005
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!
View 1 Replies
View Related
Sep 20, 2005
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
View 1 Replies
View Related
Nov 18, 2005
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.
View 1 Replies
View Related
Jan 24, 2006
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.
View 2 Replies
View Related
Jul 23, 2007
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 !
View 1 Replies
View Related
Jul 24, 2007
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.
View 1 Replies
View Related
Dec 11, 2007
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,
View 2 Replies
View Related
Mar 8, 2013
I have a main form with multiple subforms in tab view, right now the forms only open in edit mode, I would like all forms to open to new record mode. I know I can set the main form with the switchboard manager but what about the subforms?
View 2 Replies
View Related
Jul 2, 2007
I am attempting to create a database for my users to input new data via a main form. I have this main form where I use subforms as look up tables/queries to pull my stored data from. My problem is that I want to try and not have the subform on the main form; I want it to be its own window. Bear in mind I am new to using Microsoft access, and trying to learn as I go.
I have created all the forms with queries. I use the open form command to get me to my subform, which is a common findings form. From there I am able to search and filter, and once I find my desired record I want to be able to link certain fields back to the main form. (basically if possible use a command button to select this information and insert it on the main form). Typically, my users will have a generic finding to to record so I have inputted these findings so that they can select them and not have to type them themselves. Is this even possible for me to do this way, with a command button by writing a VBA code and linking criteria? The reason I am creating a separate form is so that the main form is not cluttered and is user friendly.
The fields I want to link are the same, however they are not from the same queries, and essentially the main form has its own since as of right now there is not data because it’s run of user input. The findings form has data. There are relationships established.
Thanks for any help, I feel like this might be confusing since I am unsure of exactly what I am trying to do, but any help would be greatly appreciated.
View 3 Replies
View Related
Aug 5, 2013
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 Related
