Combo Box Population Help
Sep 15, 2006
Hello:
I am hoping someone can point me to a direction to help me achieve what I am trying to do.
I have a form (shown below)
I have 2 combo boxes, type and state
What I to do is when some one chooses the type, it automatically populates the state that the type coresponds to.
For example if I choose Type 1, it will populate, IL. WI, MI, NY into the State combox box and then the user can select the state they want.
If they choose Type 2, it will populate NV, CA, CO, TX into the State combo
box.
I know how to populate a single value, but to populate all relating to a type, I am not sure.
Here are the screens:
http://static.flickr.com/84/244052119_404aaf8c26_o.jpg
http://static.flickr.com/87/244052121_52859f3f9f_o.jpg
http://static.flickr.com/95/244052123_b274f51b97_o.jpg
Here's the table that the data has:
http://static.flickr.com/83/244052125_0f5ca3ec82_o.jpg
I appreciate any help anyone can provide.
View Replies
ADVERTISEMENT
May 6, 2014
I have a form set up so that a supplier code combo box is populated with a simple SQL statement to get values from a lookup table. I have a second combo box that is populated when the supplier code is selected by the user. It works well. For example, if the user selects supplier Dog then the current record value of the Product field is displayed and the combo box shows all Dog products. So that's great.
My problem arises when the form loads. I can't convince Access to fill the Product combo box with the current products. For example, if the first record has Cat as the supplier, I want it to display the Product value for the first record and to show all the Cat products in the drop down. It isn't doing it on load or on record navigation. It does work if the user reselects the supplier.
I have tried various events.
Right now I have the following code in the AfterUpdate event of cboSupplier:
qry = "SELECT SupplierCodeProductCodeEquityTypeQuery.Product.Nam e, SupplierCodeProductCodeEquityTypeQuery.ProductCode ,
SupplierCodeProductCodeEquityTypeQuery.SupplierCod e, "
qry = qry & "SupplierCodeProductCodeEquityTypeQuery.Supplier.N ame, SupplierCodeProductCodeEquityTypeQuery.ProductId FROM SupplierCodeProductCodeEquityTypeQuery "
qry = qry & "WHERE SupplierCodeProductCodeEquityTypeQuery.Supplier.Na me = '" & cboSupplier.SelText & "';"
Me.cboProduct3.RowSource = qry
View 3 Replies
View Related
Jan 9, 2014
The datasheet is populated in a subform, based upon a table.
Code:
SELECT DEV_List.*
FROM DEV_List;
Within this datasheet, I have several combo boxes.It is easy to give them a query to show all values possible.
Code:
SELECT tbl_PPV_RPM.Createdby
FROM tbl_PPV_RPM
GROUP BY tbl_PPV_RPM.Createdby;
This gives me a list of all possible values in "tbl_PPV_RPM.Createdby".What I want, is to be able to select only the relevant values in this combobox, based upon a materialnumber in the same row. "tbl_PPV_RPM" contains a row named "Material". The datasheet also contains a row named "Material". These need to be linked. When I try to link them through the query builder, I get this:
Code:
SELECT tbl_PPV_RPM.Createdby
FROM tbl_PPV_RPM
WHERE (((tbl_PPV_RPM.Material)=[Forms]![frmSub_TD_List_Edit].[Material]))
GROUP BY tbl_PPV_RPM.Createdby;
But then I get a popup box, requesting for the Material number in "frmSub_TD_List_Edit".So, it does not recognise the Materialnumber in the row I'm trying to select a value.
View 2 Replies
View Related
Nov 4, 2013
I'm building a test registration form, and I want to populate 2 additional fields based on the TestID ComboBox selection. This same TestID table has a Requirement and Expected result field, that I want to display for the end user, to make sense of the test in question. Multiple fields in the ComboBox does not work since you cannot select a single testID; you can click on the relevant testID, but the table remains in view, rather than displaying only the relevant testID.
View 7 Replies
View Related
Nov 23, 2005
Hi all, could help me with a problem. I have a form that displays only the records for a specific field. in my table I have many records so I have narrowed the records I want to display by displaying only the records with the same pin number. So if Pin number 2550 has 10 records then on my form there will be 10 records. Now I would like to add a record to make it 11 so I would like to have my fields populated from the information that I already narrowed. so the user doesnt have to enter it again. IE. my phone number, my name, and the current date doesnt change so I would like to be able to have that data appear when the button is clicked. any help would be great. So Any code Ideas would be great!:) Thanks
View 14 Replies
View Related
May 24, 2005
Hi, I was wondering if someone could look at this code and see where I am going wrong. I open form 2 from form 1 and Form 2 has date fields populated by a calendar. When I click the search button on Form 2 I am trying to populate the listbox on form1 with records between the selected dates on form2. I think the listbox is requering as if flickers. Hope this makes sense!
Here is the code so far:
Private Sub cmdSearch_Click()
On Error Resume Next
Dim sSql As String
Dim sCriteria As String
sCriteria = "WHERE 1=1 "
If Me![StartDate] <> "" And EndDate <> "" Then
sCriteria = sCriteria & " AND tblWO.Created between #" & Format(StartDate, "dd-mmm-yyyy") & "# and #" & Format(EndDate, "dd-mmm-yyyy") & "#"
End If
sSql = "SELECT DISTINCT [work_priority], [UDF1],[WOnumber],[Status],[Property],[Description],[Requested],[RequestedBy],[Service],[Created],[Phone],[Asset] from tblWO " & sCriteria
[Forms]![FrmFilter]![Listbox1].Form.RowSource = sSql
[Forms]![FrmFilter]![Listbox1].Form.Requery
End Sub
View 7 Replies
View Related
Feb 2, 2006
Hi All,
I am having trouble getting a form to populate a table with certain information. Sergeant was good enough to help me out with getting two combo boxes to work together in the form but now the information from the two boxes are the only info from the form that will not populate the tbl.
The fm is Sightings and the tbl is sightings too, the two conbo boxes in fm sightings sorce is, tbl BBList. The two combo boxes are called CommonName & Species.
I have attached the DB in a zip file, it only very small and really only a trial run, so if anyone could put me out of my misery and tell me how to do it I would be most grateful.
I have tried relationships and queries but to no avail, I am as you will be able to tell very new to DBing. I am using Access 2002 in Office XP
View 4 Replies
View Related
Dec 4, 2006
hi Guys
I have a request from a customer to create an form to view images in a table. The idea is this....
a really quick scanner scans 100's of images to a folder. But because they're all different, we dont want to use expensive OCR software....here's the thing:
I can view the images if I import their location (from a CSV file) but I wanna be able to view them directly out of their folder. So the user scrolls through each image, renames the filename and then moves the image to another folder....
The part that confuses me is this:
How do you populate a list box with a list of files in a folder? And then, how do you move the images????
Sorry to lay this on ya's but its driving me mad right now. I've never worked with the DIR() functionality :(
View 1 Replies
View Related
Jan 21, 2008
Hi guys....I m facing problem with Text field population that comes from query. I successfully get the value on comboX.Rowsource from one query. Like comboX.Rowsource =" Select count[field1] FROM Table".
But how can I do the same result with Text field. My email address saif009972@gmail.com
View 1 Replies
View Related
Nov 23, 2004
Hello, we are creating an input form to update a file in access. We would like to enter an order number and use that number to retrieve extra data from, a non access database. The extra data would be used to populate the
fields in the access file.
View 9 Replies
View Related
Aug 23, 2012
I have a table where names are associated with information. However, we are now not allowed to have any identifying information with the information, so I need to move the names to another table with some kind of indentifier to associate which patient goes with which information. I was thinking about having the auto assigned ID numbers act as the ID numbers for each set of information.
So I need find a way that when someone enters information in the main table, they then enter the name into the "ID table" with the same autoassigned number. The problem now is there is already information in the table, and since data has been deleted, the ID autoassign field has gaps. I also don't know if I can set up an autopopulate field. How to make this easier or how to create the auto-population.
View 3 Replies
View Related
Dec 30, 2014
use a continuous form to allow users to quickly enter any number of records. One of the fields in this continuous form is an ID (not a foreign key, actually not a key in the database but crucial for other purposes) which is incremental from the last one stored in a table.
I am able to use a combo box and a query to get the ID but I cannot save the value to the text box on the first record, and then requery and get the next id when the user moves onto the next record..and so forth..
View 4 Replies
View Related
Mar 20, 2014
I am putting together a simple database to do with monitoring maintenace of buildings. I was the building number to automatcially populate when the building name is select.
I have got the the point where I have building name and number in the building name combo box but i'm stuck with the after update code builer part.
I currently have:
Me.Building_NameControl = Me.Building_Number.Column(2)
But doesn't seem to work.I don't really understand syntax!
View 12 Replies
View Related
Aug 3, 2015
I've created a table with a form that includes multiple fields that autopopulate after I enter a certain date into the "reciept date" column. After I hit enter or tab, the autopopulation accures. After I completed the table and form for autopopulation, I was tasked with adding even more autopopulating columns to the tablel that was completed. After adding the additional columns to the table and adding the extra code in it's proper place, doing everything exactly like the night before, the autopopulate does not work for any of the columns.
View 2 Replies
View Related
Aug 1, 2013
how to automatically populate a certain field. To add some context, I have a form which registers the details of a contact with standard information of contact details. There is a subform which shows the different products that the client from the main form is interested in. This is a actually a data sheet which returns the results of a query (selecting from the relevant table the client in question and the products he/she wants).
I have added a button which opens up another form and allows a product (and hence a new record) to be added for that particular client. I would like that the form automatically populates one of the fields in the form that is the client id. Given that the subform is opened from a form which already identifies the client, how do I do this?
View 14 Replies
View Related
Mar 16, 2014
I have a sheet of inventory I am working on creating. The price for storage for an item is determined by 2 things. 1. the type of material and 2. the size of that material. I have created a table with the material types and sizes. Is there a way that I can have the price automatically populate when I select the type of material and then size?
View 3 Replies
View Related
Apr 14, 2007
I need to write a query which populates an empty field in the current record with information from a specific field in the next sequential record. Any ideas?:confused:
View 3 Replies
View Related
Aug 5, 2013
I have several comboboxes (6) on my form.How to populate these comboboxes with values depending on selected value in previous combobox.
Example.Lets say that you select value "Audi" in combobox 1, then available values in combobox 2 should be "A4","A6","TT" etc. and if you selected "BMW" in combobox 1, then available values in combobox 2 should be "3-series", "5-series" etc...
View 1 Replies
View Related
Mar 31, 2014
I have a form that currently uses a "catch all" table for listing available equipment to choose from for an equipment field. I call it tblEquipment. What I want to do is to make it so when I type a name in (1 of 35) in one field of the current record, the record source for the equipment field immediately looks at a different table that has equipment available only for that name. To do this I plan on making 35 different tables with limited data originally found in tblEquipment. I would call these tblEquipment1, tblEquipment2, etc. I do not use a sub form, nor do I want to.
So my questions are:
1) can this be done
2)If it can be done, how can I do it?
View 3 Replies
View Related
Oct 20, 2005
Hi everyone,
I have two combo boxes on the same form bound to a table. I want the contents of the next combo box to change based on the previous combo selection e.g
cboContinent cboCountry
Africa Zambia
Africa Congo
Africa South africa
Europe England
Europe Holland
If I choose Africa in cboContinent, I want to see only Zambia, South Africa and Congo under cboCountry and if I choose Europe I want to see only England and Holland
Thanks
Humphrey
View 1 Replies
View Related
Apr 27, 2013
I have a Suppliers database which contains a form that will allow me to place orders with Suppliers.The Main form has a combo box that allows me to select the supplier. The combo box is called SupplierID with the following:
Row source: SELECT Suppliers.SupplierID, Suppliers.CompanyName FROM Suppliers ORDER BY Suppliers.CompanyName;
The subform is called Stock Subform witha combo box called ProductID with the following:
Row source: SELECT DISTINCT Products.ProductID, Products.ProductName, Suppliers.CompanyName, Products.Discontinued FROM Suppliers INNER JOIN Products ON Suppliers.SupplierID=Products.SupplierID WHERE (((Products.Discontinued)=0)) ORDER BY Products.ProductName;
Event Procedure - AfterUpdate: Private Sub ProductID_AfterUpdate()
On Error GoTo Err_ProductID_AfterUpdate
Dim strFilter As String
' Evaluate filter before it's passed to DLookup function.
strFilter = "ProductID = " & Me!ProductID
[code]..
The Link fields are done on the Purchase Order ID (PONoID).What I want to achieve is to select the supplier from the combo box (SupplierID) on the main form and then the combo box (ProductID) on the subform to filter to only show products directly supplied by the Supplier selected on the Main Form.
View 11 Replies
View Related
May 21, 2014
I'm looking for a way to have a text box auto fill based on the selection of a combo box on the same form. I cannot use the method i find all over the internet of using multiple columns in the combo box and basing the text box on that because the combo box already has multiple columns being used to determine its own possibilities and other combo box possibilities.
I would really just like the text box to work like this, but im still kinda inexperienced in VBA...
If combo box is "F004-001", then text box is "237"
If combo box is "F004-003", then text box is "280"
I know how to add in an "after update" thing, but i do not know how to do If/then statements.
View 1 Replies
View Related
Jul 11, 2012
I'm have quite a difficult time getting a form in Access 2010 to perform the way I would like it to. I have multiple tables that I've created, and a query that contains the data from the various tables. I then ran the form wizard to select the data from the query that I wanted to populate in my form and I've added 2 combo boxes.
What I want to do:
1. I want users to be able to select a category in combo box #1 (example: "Bag")
2. I want users to be able to select a detail in combo box #2 based on the category they selected in combo box #1 (example: Combo box #1, "bag" would populate the following selections for combo box #2: "sandwich" and "tool")
3. I want users to then receive a list of suppliers that provide the product they have selected, either "Bag: Sandwich" or "Bag: Tool"
I have combo box #1 populating a list of categories already. However, I am not able to get combo box #2 to provide choices based on the selection chosen for combo box #1.
View 1 Replies
View Related
Mar 11, 2012
Let's assume we have 3 tables:
Order_Category (Order_Category_ID, Order_Type_Name) with 2 records:
1, Minor
2, Major
Order_Type (Order_Category_ID, Order_Type) with 4 records:
1, Book
1, Pencil
2, Car
2, House
Orders (Order_Category_ID, Order_Type, value) with 2 records:
1, NULL, NULL
1, NULL, NULL
2, NULL, NULL
I want to create a Multiple Items form presenting Orders table with two Combo Boxes:
1. A combo box to select Order_Category_ID.
2. A combo box to select Order_Type. When 1 (Minor) is chosen in the first combo box it should show Book and Pencil, when 2 (Major) is chosen it should show Car and House.
Examples in the Internet show how to do it on a 'single row' forms using the RowSource property. I tried to use a query like:
SELECT Order_Type
FROM Order_Type
INNER JOIN Orders ON Order_Type.Order_Category_ID = Orders.Order_Category_ID
WHERE Order_Category_ID = [comboBoxOrderCategoryID]
But it sets same values for all records in the Multiple Items form and it should return different values in each rows based on value in the first combo box (Order_Category_ID).
View 5 Replies
View Related
Aug 4, 2006
Here's the deal:
I'm an extreme newbie, I do not know access very well, nor do I know VBA, I do know PHP.
I have a for in access that has 2 user input fields, one for prodid one for shipid. I have a combo box that upon entering data into the previous 2 fields, it does a query against an MsSQL database looking for a record that has both. In any case there will only be 2 outcomes, either 1 record, or null. I would like to have that same combo box automatically use the result as it's value so that users don't have to check the box, because they won't, and so that the rest of my VBA will be able to function properly.
Can anyone assist?
Thanks.
View 2 Replies
View Related
Sep 7, 2006
Thanks in advance for your help.
I would like to set up rules/constraints such that the value selected in combo box A determines the available values in combo box B. For example, "Combo box A" is bound to the [PartnerType] field and "Combo box B" is bound to the [PartnerRole] field. Let's say that the two choices in Combo Box A are "LLC", "LP", and "Corporation". There are 5 possible choices in Combo Box B: "X", "Y", "Z", "Q", and "U". If a user selects "LP" in Combo Box A, I would like Combo Box B to only show choices "X" and "Y". And if a user selects "LLC", only choices "Y", "Z", "Q", and "U".
Similarly, I would like to set this up so that Combo Box B is not initially visible--it becomes visible when a user selects "LLC" or "LP". If a user selected "Corporation", Combo Box B would remain hidden.
View 2 Replies
View Related
