Heya
Ive got my combos working fine now (thanks to all you kind folk on this forum!) but now that I have opened the main form (in which the combo box form is nested), once I have selected an item in the first one, and then click on the 2nd combo, a parameter box comes up saying "Forms!Training Record!Course_title_combo" and wants a value.
I cant see why this doesnt work when the form is nested, any ideas?
Gazz
Hello to all !
I have this db where i wantto include 4 and if possible 5 cascading combos where the user can select records from a table and view them in a subform which is in datasheet view.
All is going well until i try to add the 4th combo.Then when i select the 4th combos selection the subform displays nothing.
If someone could point me to the right direction i would be most thankful.
I have attached the db.
Thx for all replies :)
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 :) :)
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
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 RelatedRight 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
Hi All,
I have a query about cascading and combo boxes, which I was kindly, advised about previously. However, I’m stuck as to how to cascade using the selections from more than one combo box. Here are the tables involved
tblLine
fld LineID (PK)
LineDesc
tblMachine
MachineID
MachineDesc
tblLine_Machine
LineMachineID (PK)
LineMachineDesc
LineID (FK)
MachineID (FK)
tblCategory
DTCategoryID (PK)
DTCategoryDesc
tblDTReason
DTReasonID (PK)
DTReasonDesc
tblCat_Mach_Reason
CatReasonID (PK)
DTCategoryID (FK)
MachineID (FK)
DTReasonID (FK)
What I’m trying to do is create a form to enter downtime incidences and would like the downtime reason to be selected following a series of combo boxes. The first combo box selects the Line on which the downtime has occurred, using this, the next combo box selects the machine. I would like the category selected independently but then need the Downtime Reason selected based on the selections in the machine combo box and the category combo box. This is where I am having the problem.
I can get the machine combo box to display machines dependent on the Line selected and I can get the downtime reasons combo box to display machines dependent on either the machine selected or the category selected, but I don’t know how to get it to do it based on both.
e.g. the category may be mechanical, but there are reasons that are mechanical and specific to each machine.
Any help with this would be most appreciated.
Regards
Keji
Hi,I shall be grateful for any help.
My problem
Tables:
Cars
Customer
Invoice
TblMake
Tbl Model
I have used cascading combos for Make and Model. They work fine. I have set up tblMake as follows:
ID
Make
I have make tblModel as follows:
ID
Make
Model
I use these cascading combos on a form. The data from this form goes into the "Cars" table. I have set the "Column Bound", "Width" etc. to show the name of the car, not the number.
However, I have created a search form. This uses a SELECT...... case in the Row Source. The details of each car are shown in a unbound listbox. This select case is supposed to show "Make" and "Model", which it does, however - they are numbers!!!
Please can anyone let me know how to change it so it shows the actual names of the car.
Thank you
I have a cascading combo box working fabulously in a form. However when I embed that form into another form, the cascading combo boxes quit working. After doing some searching around on the web I think my issue is either in the query that the dependent combo box references and/or in the "after update event procedure" but I just can't seem to figure out the exact changes to make to my database. Details:
Tables with data for combo boxes:LOOKUP TABLE - Veg Species - Species Type,
LOOKUP TABLE - Veg Species - Species Name.
Related together based on common field: SpeciesType
[code]...
When the form with the combo boxes is embedded as above, I can select the species type from the dropdown but when I try to select the species common name value I am asked to
"enter parameter value - Forms!SUBFORM2a - Enter Specific Veg Info!cmbSpecies_Type".
OK, here is the problem. I have the following tables:
Customers
Consignment
ConsignDetails
Employees
Products
Suppliers
CompanyColors
CompanySizes
and I am creating a form to view the items currently on consignment with the customer. I have the main form 'Consignment' that holds the CustomerID, ConsignID, DateStarted, Employee (SalesPerson), Inventory Interval, and Closed (Y/N)... The subform lists in datasheet view the records in form 'ConsignDetails' that have the same ConsignID. The controls on the subform are :
ProductID
UnitPrice
Quantity
Color
Size
The ProductID is selected in a combobox from all products. The UnitPrice defaults to a DLookup() from the products table based on the ProductID, but can be changed and stored. The Quantity is a manual entry field. Color and Size are both supplier-dependent fields, in other words, the supplier of the product has unique Size and/or color codes or descriptions. I have no problem creating a combobox either in the AfterUpdate event of the ProductID or in the MouseDown event of the Color or Size field to limit the drop-down list to only those Colors/Sizes from the CompanyColors / CompanySizes tables with the same SupplierID as the Product in the first control.
So far so good, but here is where I am beating my head against the wall. Every time I choose a product from a different supplier, the Color and Size controls display ONLY the items from the current Supplier, not the items from the Supplier of the Product on their individual records. I have seen ways to make the combo popluate a locked textbox, hide the combo, and display only the text, but in a data entry application the user will be primarily on the keyboard, and the solutions seem to make it almost impossible to do without using the mouse over a continuous form.
I am using Access 2002 (ver 10.6501.6735) SP3 to create an ADP using MSDE to link to SQL7 tables....
Any help will be appreciated, I have spent almost two weeks trying different approaches and may be too close to the forest to see the trees.
Thanks,
Bruce Davis
OK ive got my 2 vaguely working combos which select the surgery, and the staff.
On the same form I want a couple of tickboxes which show for example, whether a person attended the course, if they had to pay etc (all yes/no answers).
How do I get the tickbox to update? i have tried to requery it but nothing happens, it just stays as what the last thing done to it was.
SHould i be using a subform here do you think?
Hi Guys,
I have two unbound cascading combo boxes on a form that limit the data for a stored field.
I am designing this as a subform to show software installed on a PC (hence the need to have a continuous form). As the manufacturer, software package and edition are already stored in my database, I am storing only the ID of the edition to limit duplicating data.
I would like to show the values in the cascading combos that relate to the edition ID stored as well as filtering the edition ID using the combo boxes (i guess a filter and a reverse lookup)
Please see attached pic. First record was entered as Microsoft Autoroute. New record for Manufacturer Frontier, change the previous records combos.
Thanks for you help
Ben
I have set up a form which has 2 combos.
Combo A pulls from a query which gets surgery address1, address2, and surgeryID. It displays only the first 2 fields.
Combo B gets info from a query getting staff firstname, surname, title, staffID and surgeryID, and shows the first 3 fields.
I have the following code in the afterupdate of box A (surgery_combo)
Private Sub surgery_combo_AfterUpdate()
staff_combo = 0
staff_combo.Requery
End Sub
HERE IS THE PROBLEM:
The queries seem to work fine, as box B displays the staff that work at each surgery. However on selecting a staff member, you can only SELECT the ones who have a salutation (mr/mrs etc) in the first column. And when you DO select this - the combo shows a most unhelpful "Mr" whereas I want the name there.
How do I change the column that the combo displays once selected?
I have a problem with cascading combo box not working.
I have a one form and with two subforms
One form is "frmReviews" with a subform called "frmbyReviewer" Link Master Fields = Name and Link Child Fields = Reviewer_Name
Then we have the "frmbyReviewer" with a subform called "frmsubMain" where it's Source Object is another form called "frmMain" and linked by Loan_Number
Here's the Design View of it.
I have cascading combo boxes in a subform. When I click the second box, which is dependent on the first, I get the following error:
"Object does not support this property or method"
This is what I have for the On Enter Event:
Me!LeadIn.Updated Form!LeadIn.Requery
I originally had : Me.LeadIn.Requery for the On Enter, but it prompted a parameter box looking for the Phone_Card form.
I think I have to adjust the OnEnter even syntax, but I cannot figure it out.
Here are the names of the forms:
Main Form: Updated Form
SubForm: Phone_Card
Control Names:
Combo Box 1: Brand
Combo Box 2: LeadIn
In doing a net search, I believe it should look something like this:
Me!Leadin.Form!leadin.requery ??
I should also add that the subform is in a tab control: TabCtl197 if that matters. Also, when I use the combo boxes while having the Phone_Card form open, they work fine. It is only when using it as a subform that it no longer works.
Thanks for any advice or help!
In my sub form I have two combo boxes named [wps] and [process ], I want to be able to filter process based on the value in wps.
View 3 Replies View RelatedI have a subform that I use on two parent forms. The subform has a cascading combo box. The LocationID field gets filtered after CompanyID (named: cboCompanies) is updated. The problem is that I can only get the combo box to work on one form (Contacts_All). When I open the second form (Contacts_Clients), it asks for the Parameter Value.I am entering this into the criteria for the LocationID field:
[Forms]![Contacts_All]![SUBFRMContactsCompanies]![cboCompanies] Or [Forms]![Contacts_Clients]![SUBFRMContactsCompanies]![cboCompanies]
So, the "Or" is not working.Do I need to make a separate subform for each parent form or is there some way to get this working? I already feel as if I am managing way too many forms and need to simplify.
i have a main form which allows me to fill in Order Information within which is a subform which allows me to fill in Order Lines.My Order Lines contain the following fields:
Extrusion
Length
Qty
etc. etc.
Elswhere in my database (tblLengths) I have set up a list of possible lengths for each Extrusion and therefore when an order is filled out I want the user to be restricted only to those lengths that are possible with the particular extrusion they have chosen. This list contains the ExtrusionID and LengthID so that I can query the available lengths for a particular Extrusion.Within my subform I have set the record source to point at the tblLengths and criteria on the ExtrusionID to point to [Extrusion]. I've also put a requery against the Extrusion field so that I can force the combobox to refresh its list of results.
My problem is that I am getting unexpected results each time I add an Order line into my form and reading up I see that what I am trying to do is a big no-no.
Is there anyway that we can do cascading combobox in the same datasheet view of subform? Basically I'd like to filter "Account Name" based on "Plan#" selected in the same record of subform.
View 3 Replies View RelatedI have a main form which is linked through a [PackageID] field to a subform. i wast to use the same form for both shipments in and out. the subform has a list of serial numbers add for each [package id].
On the main form i have addresses ect and then a combo box onthe [PackageID] field which brings up all the serial numbers that came in, in that package.
This is perfect for sending a large container back out unopened, however there are times when the database will need to 'pick and choose' serial no.s from several packages. To do this i made the [SerialNo] field on the subform a combo box - looking up all the serial no.s in stock - however when a serial no is selected it doesn't update the other 15 fields in the subform.
Any sugestions? Got a feeling thats its quite an easy thing to do but its beaten me!
Many thanks
Ed
I have a main form with a subform which in-turn also has a subform (in datasheet mode). When the user clicks a button on the main form I want to disable all of the controls on the subforms. This works fine until the user clicks the button while the focus is on one of the text fields in one of the subforms. It rightly complains that the control can't be disbled while it is in focus. To circumvent this problem I've tried setting the focus to another field before disabling the control. However this doesn't seem to work. It seems to ignore the setfocus and still flags the original error. Is it not possible to set the focus of a subform from the main form?
Example:
[subfrm1].Form![Field2].SetFocus
[subfrm1].Form![Field1].Enabled = False
This fails if the focus was in Field1 at the time of executing the code.
Any ideas?
platform : access (adp) / sql server
Problem : form filter not executing in subforms
When I goto one of my subforms I can activate the form filter.
When executing the form filter no records show up, it just keeps showing my criteria. When disactivating the form filter I receive an error message telling that my view must be misspelled (it's about spaces). My view is called Vw_people , as a record source it works fine so it can't be misspelled.
Is the problem the adp connection or the subform? I don't know
Every time i try to get info from a sub form or its table ,Things never sem to work.Is there something special you have to do for eg maybe going via the main form?I am trying to use dsum as an alternative to multiplying info in the sub form.This is the code
=DSum("SoldAtPrice*Quantity","[Order Details]","IDNewOrders=" & [OrderID FK]).
I have an orders subform displaying the line items in an order.
I have two combo boxes in the subform that allow the user to select 'Product catagory' and 'Product'. To enter a product the user must first selct a product catagory which filters the products available for selection. If the exact product is not listed then on option to 'Add new item' must be offered
The problem:
At the moment the combo boxes show the same product catagory on every line of the order, even though each line is different and the second combo box is empty
How do I:
1. make the combo box only display the entry for the line it is on
2. force it to filter the available entries for the second combo box
3. offer an option in the second combo to 'add new item' (if the users selects this then Access should open the products entry form and pass the vale of 'Product catagory' from that line as a parameter to preset the form.
other info:
The data for the subform is generated by a query on 3 seperate tables all linked by relationships.
(tblProductCatagory, tblProducts, tblOrders)
The combo boxes are unbound
Thx.
Kev.
I have an IIF function specified on a continuous sub-form as below - basically it checks to see if the value of two text boxes is equal, and if they are it displays 'And', if not it displays the value of the column EntitlementName. I'm trying to work around grouping not working in continuous forms.
When I view the form directly it works no problems but when I view the form as a sub-form instead of showing the correct output it shows #Name? Both the text boxes I refer to have the correct values in them.
=IIF([txtPrevValue]=[txtValue], Format("And"),Format([EntitlementName])
I have a subform that has the Expense Code from the Expense Codes Table and I want to look up the Description (yes I know its not correctly spelled in the formula but it is in the table)
=DLookUp("Expense Discription","Expense Codes","Expense Code=" & [ExpCombo])
But I keep getting "error" returned
I have double checked spelling field names etc...