Cascading Issue
Aug 25, 2004
i have a subform called Tbl_Trainingsubform
on here i have two combo boxes which i am trying to setup as casacading...i believe this is how they are referred to anyway.
combo box 1 is called cbosection the other is called cboactivity
i have a table called tbl_training which has the following
trainingID
Activity
Section
and here is my sql that i have put on the afterupdate of Section...
Private Sub cbosection_AfterUpdate()
On Error Resume Next
cboActivity.RowSource = "Select Tbl_Training.activity " & _
"FROM Tbl_Training " & _
"WHERE tbl_Training.section = '" & cboSection.Value & "' " & _
"ORDER BY Tbl_Training.activity;"
End Sub
what i am trying to achieve is that when the user selects from the section box, the combo box activity will then be limited to the relevant list
what am i doing wrong
Andy
View Replies
ADVERTISEMENT
Sep 2, 2005
Hi
I have 4 Comboxes all Cascading from one an other and it's all working fine.
My question is about My fourth combo boxe, It as two fields that the user can see when he selects the fourth comboboxe; pretty straightforward...
I want the user to see the two fields on the form after using the combo boxe. For this I have one of the record to populate the comboboxe and the other one to populate an other text box using the dlookup function where the criteria is = to the field selected in the combo boxe, I hope you're following...
Now, some of my records for each fields are not all different from each other so when the user select a set of value the "dlookup text box" may have several option: the index is not unique if you see what I mean...
To have the unique index, I would need to add to the 4th combobox the primary key which is an autoNo that the user doesn't really need to see...
So... I am thinking of hidding the primary key column in the comboBoxe and make it the main field THEN write a code on the after Update of the Comboxe to hide the comboxe and show a text box placed over the comboxe with a dlookup function with a criteria = primary key and an other text box set on a different field with the same criteria.
I hope this is making sense, I was wondering what you were thinking of this method, it seems to involve a lot of fiddling which I don't mind but I'd rather make sure that i making it right.
View 3 Replies
View Related
Dec 7, 2005
Dear members,
I have a form with 4 Combo boxes bound to fields in 4 tables;
1) Oblast Name
2) District Name
3) Jamoat Name
4) Village Name
The selections work fine. Cascade works from Oblast to Village Name. My question is ;
Currently the ID's of the bound columns are stored in the tables instead of the corresponding data. For example for the Oblast name; I have the value "3"=" rather than "Khatlon" for District_Name, I have "223", rather than "Muminobad".
Is there way to capture the names of the respective places rather than storing ID's in the table?
Thanks in advance.
Irshad
View 9 Replies
View Related
Jan 15, 2008
I don´t get this effect: I am struggling with a cascading combobox problem, could you help me, please?
form is frm_Principal. Combobox are Categoria, 2ª Categoria and 3ª Categoria. Where´s the error?
http://www.drupload.com/uploads/211DB_MM08.rar
thanx so much
View 4 Replies
View Related
Mar 11, 2005
Hi,
I'm fairly new to database design. I'm designing a database that has 5 tables, the first table stores a persons details and a unique trace number. The other tables contain this trace number and some other details.
Is it possible that when i enter a persons details to the details table, name, Surname, Trace Number, that this trace number will cascade or replicate in the other 4 tables? How would i do this?
thanks,
Joe
View 1 Replies
View Related
Mar 11, 2005
Hi!
I am trying to find a solution for this many to many relation and combos! I ve managed to do the one-to-many as the Mile-o example but i have trouble getting the same result right on many-to-many relations
as you know access needs us to create an extra table for many-to-many relations! but the example talks about the current an the previous table! how can i have 3 cascading combos with many to many relations to each other???
i also have a fourth but this one is related as one to many with the 3rd!
for more information i have:
Many Cars-to-many Categories of brands of parts
Many Categories-to-Many Brands of parts
One Brand-to-Many parts
the many parts combo is also a record selector!
In the beginning I had one table of parts with 4 foreign keys then i changed it to the current one with the previous chain of relation ending to parts with one foreign key! is this better???
Thanx! I hope I made my proble as clear as i could :)
Please Heeeeeeeeeeeeeeeeelp :) :)
View 3 Replies
View Related
Jun 5, 2005
I'm looking for if possible a simple solution for my cascading combo boxes that do not work in a subform.
I have provided a link to my DB and the form i'm having issues with is frm_Projects any suggestions woul dbe great i know that this subeject has been looked at several times but i still seem to not figure it out.
Database (http://www.cyruspostings.com/hold/db.zip)
View 3 Replies
View Related
Jun 24, 2005
I have three cascading combo boxes that, when a selection is made, will auto-fill 3 following text fields. So I had it working just beautifully, with the data pulling from the correct columns. All of a sudden, they stopped working, and the text fields are displaying #Name? instead of the appropriate data. Nothing has changed on my form, and I have really been struggling to determine what happened and to fix it. Any help or suggestions would be welcome. Thanks.
View 2 Replies
View Related
Sep 28, 2005
Can anyone kindly help me with the attached
database. I need to synchronize 3 combo boxes.
based on the choice made in the previous box.
I have seen it done before using text fields but
not using numeric fields as in my case here and
without using queries.
I have set the RowSource for the 3 boxes on the
OpenForm event and have removed all my code
attempts.
Thanks for your help
View 3 Replies
View Related
Feb 21, 2006
This ought to be an easy one, and I had it figured out in the past, but I can't remember what I did before. I've tried so use the forum search, so I wouldn't have to bother anyone with this, but I can't seem to word my serch criteria properly.
I have a cascading combo box for doctor's names that will auto fill 7 other fields (contact info), based on its selection. It works very well, until I have a doctor with the same last name as another doctor, say, Dr. Mary Jones, and Dr. Henry Jones. The list is sorted alphabetically, so Henry Jones is first. His information populates exactly as it should, when selected from the list. However, when I select Mary Jones, only HENRY's information displays in the 7 corresponding fields. What's wrong here?
View 9 Replies
View Related
Apr 2, 2006
I am new at programming in Access and I am writing a database for our church. I have 2 tables, one called “Donators” and the other “Donations”. In the Donators table I have their Last Name and First Name along with their address etc. In the Donations form I use a combo for the Last Name and a separate combo for the First Name. I did this so the person entering data doesn’t have to use a mouse but simply tab and type. Both combos are bound to the ID number. Without using a cascading combo, all First Names appear not just the ones relating to the Last Name. I checked the examples on cascading combos and tried them but without success. I could really use someone’s help. Thanks.
View 3 Replies
View Related
Apr 11, 2006
This is driving me a little mad, and its probably something quite simple!
I am creating a form which will allow users to narrow down their search based on criteria entered into three combo boxes.
The first combo box pop's up a calendar and is populated when the date is chosen on the calendar.
The second combo box will provide a list of systems that have a record entered on that date
The third combo box will then show a list of case id's based on the system and date selected.
I can get it working when ignoring the date, but as soon as I bring the date combo into the equation I get a data mismatch error. Now I presume that this is to do with holding a date in a text field and comparing with a date/time field in the table, so I have set both to 'short date', but still get the error.
Can anyone provide any pearls of wisdom to help stop me from going insane? (that might be a bit late tho!)
View 1 Replies
View Related
Dec 12, 2006
I have a few cascading combo boxes that restricts the value of one combo box depending on what the the value of other one is.
The problem I have is that some of the data is not displayed in the combo boxes when scrolling through the records after data entry.
I have tried to re query them on the form on open event but it does not seem to help much.
Any Ideas?
thanks :)
View 9 Replies
View Related
Nov 4, 2007
Hello
I have a database (Access 2007) that has two tables, reports, queries and so far all seems to be working and going well. Quite impressed with it to be honest for my lack of skills.
However, I've run into a bit of trouble and need assistance getting a combo box to work with another combo box to produce list kind of thing.
The database is a vehicle database and I need the 'Vehicle' combo box to give me a list of vehicles. I then need the 'Model' combo box to produce the models of the car selected in the 'Vehicle' combo box.
Example - If I select 'Ford' from the 'Vehicle' combo box list I want all the models to be displayed in a list form thing in the 'Model' combo box so the user can easily select make and model of the car.
I have two tables:
CarMM
VD
The 'CarMM' table contains a list of around 1,500 records of car makes and models. First column has the 'Vehicle' make and the second field coloumn has the 'Model'.
The 'VD' table contains all other information like the charges, name, the make and model of car once selected in combo box.
I then have the form called 'VD'. In this form contains the combo boxes I want to be cascading.
Any advice on how to do this? I'm quite new to this so any help would be nice. Thanks you very much.
View 2 Replies
View Related
Jun 14, 2005
As part of my data structure I have a Fault table, Transaction table & Resolver table. The Resolver's are dependant on the Transaction that are selected in the fault table. What I am after (and it's not happening) is when selecting a Transaction in the Fault table the only resolver that is available to the user is the one related to the choosen Transaction.
At the moment after selecting a Transaction all Resolver's from the Resolver table are available. When creating my Fault table I selecting the Resolver field as a Lookup and choose the Transaction table and the Resolver field.
View 1 Replies
View Related
Jul 28, 2005
I need some help setting up my tables to allow cascading combo boxes. I need to document when a Pharmacy IV room and chemotherapy room are cleaned. Each Room requires different cleaning procedures.
Here is my table structure:
TblCleaningDuties
DutyID-Auto# (PK)
Duty - text (Example- mop floor, clean hood, wash ceiling, wash sink)
Frequency-text
TblLocation
LocationID- Auto# (PK)
Location - Text (Clean Room, Chemo Room, Anteroom)
TblCleaning
CleanID-Auto# (PK)
LocationID-(FK)
DutyID- (FK)
Date/Time
TechID
If the user selects Clean Room I don't want them to see wash sink and anything else not pertinent to the Clean Room. How do I set up the tables?
Thanks,
Jason
View 1 Replies
View Related
Oct 25, 2006
Probably an easy one that I just can't think my through it. I've been trying to create some (for lack of a better term) cascading fields using the lookup wizard (to eventually be used in a datasheet view/form).
In the main table, the user needs to select a Team (A, B, C), Sub-Team (A1, A2, A3, B1, B2, etc), and a Family (A1 contains bolts, screws, and washers).
The first lookup of selecting a Team (A, B or C) was easy. However after this point I'm stuck. If the user chooses A, I only want the "A" related sub-teams to show in the next lookup. Then based on the sub-team chosen, I want the Family list restricted again.
Any ideas would be appreciated. Thanks!
View 5 Replies
View Related
Jun 2, 2005
Just wondering if anyone can help Im creating two combo boxes where the first one determines the values in the second one.
The tables are made up of the following;
Line
Line number (PK)
.....
....
Main Setting
Part Number (PK)
Press Line (FK)
Now ive took the advice of previous threads but im having the following error message when im creating this;
The record source 'SELECT [Main Settings].[Part Number] FROM Main AS Settings WHERE [Main Settings].[Press Line]=[Forms]![Example]![Line]' specified on this form does not exist.
I know that this doesnt exist but im typing it correctly. Access seems to be changing my statement i.e. inserting the AS command. Any help will be much appreciated
View 3 Replies
View Related
Nov 21, 2005
I have an unbound Form with a Subform bound to a query. The query parameters are selected by the users via Unbound cboboxes. The form is working but I would like to add a feature on each cbobox that would allow to show "All" the data (ie:Show the data like if there was no parameter on that field). I can't see how to add this feature, is anybody got any idea?
View 3 Replies
View Related
Jan 31, 2005
Right I have followed one of the sample databases and modified it to create cascading combo boxes like i needed.
Now all i need to do is use them in the context i need.
Basically I have country, region and sub region. These cascade to each other in the form which has been created. If you select a country, then in region you in only see the regions in that country, etc.
What i need is to be able to use the cascading combos boxes in conjunction with the "Location table". So someone can put in a project number and then use the cascading combo boxes to to chose the country, region and sub region boxes saving all of the data into the location table .
Please can someone help, as it took me allmost three hours to create the cascading combo boxes but now i cant even use them for what i wanted them for,.
Many Thanks
View 12 Replies
View Related
Feb 25, 2005
Right i have a project form which has a sub form of location
One project can have many locations
therefore it is nescarry to enter more than one location
Problem is with the cascading combo boxes i have for country to region to sub region, is that you can enter one fine, but if you enter another is deletes the information from the first entry
can anyone fix this please
i have uploaded a sample
View 4 Replies
View Related
Mar 15, 2005
Hi
I have trawled this forum searching for help with cascading combo boxes, it was very helpful but alas I need that bit more.
I have 2 combo boxes and the result is displayed in a subform. The problem is that it will only display one selection made from the Combo boxes and I need multiple selections on display in the record.
It is a parts job worksheet in a garage where multiple work is required on a vehicle. It is based on Work Type and Work Codes which then bring up the detailed description.
The first Combo Box is Work Type and this allows you to select letters. The second Combo Box is Work Code and this allows you to select numbers.
I used the example I found on here but haven't changed the field names as I daren't alter the coding until I know it will display multiple selections in the subform of the record.
I attach the database to see of anyone can help me, ppllleeeaaassssee. I woul dbe most grateful if you could make the changes and zip it back up as I ain't no VB programmer.
View 9 Replies
View Related
May 24, 2005
Hi folks, this may seem like a silly question... but I'm rather new at this...
I have set up 4 Cascading combo boxes on a form, as per the fantastic little tutorial by SJ McAbney... They work great...
What I want them to do is output the combo box selections back to a table. I have been able to get it to do this, but all it's putting back in the table is the ID number of the combo box selection. I need to get the text there instead. I experimented with switching the column order on the form, so the text is before the ID... and that worked with the output, but messed up a number of other things.
Any suggestions??
Thanks in advance...
B
View 8 Replies
View Related
Aug 6, 2005
Hi all,
I'm building a db to catalogue my prints collection. I'd like to group them in categories. With the examples I found on this site I've been able to include cascading comboboxes in a form and they cascade beautifully (3 categories: maincategory, Subcat1 and Subcat2). Problem is though, I cannot get them to work in combination with a unique record! I have tried all sorts of combinations to link the cascading boxes to the print but they either don't change at all, or my qry returns 0 records. I must be doing something simple wrong but I'm not very experienced and just don't see the solution. I've spent all evening so far and I think it's time for some help.
I've got these tables (there are more tables and fields, but these are the main ones)
Tbl_prints
PrintID
PrintTitle
Tbl_Category
CategoryID
Category
Tbl_SubCat1
SubCatID
SubCat1
TblSubCat2
SubCat2ID
SubCat2
PrintID
The tables are linked by the printIDs.
Now, when I fill in the details for print #1 and then advance 1 record to print #2, (or #3 etc) the comboboxes don't follow.
What would be the solution for this?
Thank
View 3 Replies
View Related
Oct 9, 2005
i currently have 4 combo boxes that each has its own table, and setup as cascading. Now what i want to add is an <All> in each combo to box to give any results in that table.
i have
combo 1
SELECT [tblProductManufacturer].[ProductManufacturerID], [tblProductManufacturer].[ProductManufacturer]
FROM tblProductManufacturer UNION Select "<All>", "<All>" as Bogus From tblProductManufacturer
ORDER BY [tblProductManufacturer].[ProductManufacturer];
combo 2
SELECT tblProductModel.ProductModel, tblProductModel.ProductModelID
FROM tblProductModel
WHERE (((tblProductModel.ProductManufacturerID)=[Forms]![MainScreen]![MainWindow].[Form].[CboProductManufacturer])) UNION Select "<All>", "<All>" as Bogus From tblProductModel
ORDER BY tblProductModel.ProductModelID;
combo 3
SELECT [tblProductVersion].[ProductVersion], [tblProductVersion].[ProductVersionID]
FROM tblProductVersion
WHERE ((([tblProductVersion].[ProductModelID])=[Forms]![MainScreen]![MainWindow].Form.CboProductModel)) UNION Select "<All>", "<All>" as Bogus From tblProductVersion
ORDER BY [tblProductVersion].[ProductVersionID];
combo 4
SELECT [tblProductSize].[ProductSize], [tblProductSize].[ProductSizeID]
FROM tblProductSize
WHERE ((([tblProductSize].[ProductVersionID])=[Forms]![MainScreen]![MainWindow].Form.CboProductVersion)) UNION Select "<All>", "<All>" as Bogus From tblProductSize
ORDER BY [tblProductSize].[ProductSizeID];
in place of UNION Select "<All>", "<All>" i have also tried
UNION Select Null as AllChoice, "(All)" as Bogus
And in place of UNION Select "<All>", "<All>" as Bogus i have also tried
UNION select distinct null, null (And added distinct after the first Select of the query)
but to no avail????
View 7 Replies
View Related
Nov 8, 2005
Hi all,
I encounter a problem here.
I have a main form (OrderForm) with a subform (OrderDetails). In the OrderDetails subform, I put a [txtSubSumOrder] TextBox at the subform footer to perform the Sum of the OrderDetails. To pass the [txtSubSumOrder] data back to the main OrderForm, I put another TextBox [txtMainSumOrder]=[OrderDetails].[txtSubSumOrder] at the main OrderForm. Therefore, I can calculate the commission for sales, profit and etc for the Order in the main OrderForm by using the data from the[txtMainSumOrder].
The challenge is I need to wait untill the [txtMainSumOrder] has been sucessfully updated with the changes in the OrderDetails subform before I can perform the calculation accurately. But programmatically, how do I know/detect the [txtMainSumOrder] has been successfully updated, before I initiate the calculation routine? I try the [Enter], [After Update] and various events for the [txtMainSumOrder] control, but I still fail to detect the changes has been take place.
Help ............
View 6 Replies
View Related
