I have a form for entering data. I use a combo box linked to a table to select a record that has a person's SSN, Name and city. Once the proper record is highligted and selected only the first column is visible in the combobox. Is there any way to keep all 3 columns visible once a record is selected in the combobox?
View RepliesI am trying to use a combobox called Manufacturer to select which table the combobox called Model gets it's rowsource from using the code below.
Code:
Private Sub Manufacturer_AfterUpdate()
If (Me.Manufacturer.Value = "Siemens") Then
Me.Model.RowSourceType = "Table/Query"
Me.Model.Recordset = "SeimensTable"
Me.Model.RowSource = "SELECT Model FROM SeimensTable"
Else
If (Me.Manufacturer.Value = "Samsung") Then
Me.Model.RowSourceType = "Table/Query"
Me.Model.Recordset = "SamsungTable"
Me.Model.RowSource = "SELECT Model FROM SamsungTable"
End If
End If
End Sub
But when I run the form and select Manufacturer. Combobox Model remains empty. tell me what I'm doing wrong?
How would I modify multiple comboboxes in subforms at the same time. For example.. In main form ComboboxA user selects 1992, Combobox1 in subform1 is also changed to 1992, as well as Combobox2 in subform 2.
Whats the best way to do this?
I have 2 comboboxes, the first one is called "activity", whereby I have 3 options to choose from, and the second is called "level".
When I click an "activity", for example Drawings, I want the "level" combobox to list a unique set of options for that category. and if I click on a different "activity" for example Planning, I want the "level" combobox to show a completely different set of options.
If anyone can give me any help on how to do this then I would be very grateful!!
Thanks
Angela :eek:
I've tried searching the forums and haven't found quite what i'm looking for. I would like to be able to change the source for a combobox based on another combobox. The simplest way i can summarize that is i want to be able to choose A or B, depending on my choice i want another combobox to display all the values that A or B can have.
Thanks
Jim
I'm not sure I worded that very well. :(
Hey all,
I've read some tutorials on this sort of thing, but I can't seem to piece it all together to achieve what I want.
I have a table Products that contains the fields Product, Size and Brand. I also have a form, frmProducts, that has a combobox linked to each of the fields in the Products table. I want to be able to select a product from the first combobox, tab to the Brand combobox and have only those brands associated with the product already selected.
This is how I think it should work:
1.ComboBox1 selects productA
2.ComboBox2 takes its options from a query that searches Products table for all instances of productA and displays all available brands. brandA is selected.
3.ComboBox3 get its options from another query that searches for all instances of productA that also have brandA and displays all available sizes.
What I'm having trouble with in particular is passing the data between queries. For example, I can't figure out how to tell the query to search for all instances of productA when its defined by the first combobox. Do I have to store it as a variable somewhere?
I hope I've been clear.
If I want the combo box to read entry's from one table and then store in another table how would this be done? I think it has to be done with the query builder but I am not sure. I am sorta new to Access.
View 2 Replies View RelatedHello,
I have an invoice form with its detail subform that I have been stuck with for a while. The main problem is on the detail subform, here is what I have:
1. I have 5 fields, DepartmentID, ProductID, Qty, Price, Total.
2. The department is a combobox and I want to select the department that the product is from. Example: If I will be selling a pvc pipe I should select PVC Department.
3. Once I select the department I want the product combobox to only show the products from that department. So I select Electrical Department I can only see what items belong to the Electrical Department.
That is basicaly what I need it to do. So, I worked hard on this looked at samples, read threathds, pull all my hair out, almost done eating all my nails, and most of you know how that goes!!!!
Well finaly after sleepless nights I got something to work!!! I was able to make the product combobox only show the items from that department, Man I was jumping of joy!!! I turnon my radio and put on "Eye of the tiger" and started boxing away!!!! jejeje
Well, I started to make it look pretty, changing the looks and changing the comboboxes to show me the name of the department not the ID, worked good, than I changed the product combobox to show the name not the ID and something went wrong......
The department combobox does a requery of the product combobox everytime I select the department for a new item. So for some reason it makes the product code from the other item disapear....I cant figure it out!!
I have attached the DB, goto frmFactura there is already one invoice started, I have selected the PVC Dept and the Product, you can also see the prtoduct code, once you goto the next item and select another department the prodcode desapears but the prodid stays...
CAN YOU HELP ME PLEASE!!!!!
Hallo,
Simple question, is their a way of showing the value on the combo box without saving it in a table. Therefore, when you open the form again next time the value last selected is viewed again.
Thanks
On a form i have 25 comboboxes with names the form is based on a table (tblpersons) with the key personID now how can i in all the comboboxes in the event before update
doing the following:
when i select a name in a combobox before update i want to search in all the combobowes of that name i selected not 2x selected is and and if not then the name must in the field otherwise it would tell me that thr name al is selected in another combobox. If the name i selected is ok then this name must not again availible in the combobox
can someone help me with that code please?
Is this with a loop?
I want to have a combobox draw its information from more then one column in the same row from the table, but show as only one column when a user clicks on the combobox in the form.
Example of what I am doing...
Table with contact information:
Contact, Phone1, Phone2, Phone3
Combobox on form for contact log: (what I want but not sure how to do)
Phone = (Phone1, Phone2, Phone3 in a single column)
I need the combobox to be able to select each phone number seperatly from that contact so I can show which number was called.
I know there have been old threads on this issue. I have done a search and read them. That is how I got this far. I was able to search the Web, find a Govt site with a list of every zipcode in the country. It was a text file so I converted it in excel and then imported into an Access table. I now have a 4 field table with every zip in the country-city,state,and Zipplus a auto number field as my primary key. My db is name and address intensive in multiple tables. I want to use a combobox to lookup and display city,state and zip on my forms from this table instead of storing the information. However, If I do this and then want to generate a mailing list how can I do this if the city,state,zip info has only been displayed from a combobox and not stored in the underlying table? Since I am using an autonumber as the primary key for the city,state,zip table can I include a field for that pk in an invisible field and just store that? If anyone wants the table of zipcodes let me know. I'll be happy to upload it.
View 1 Replies View RelatedWhen i try to update a field using a lookup instead of giving me the name of the employee and Customer it only offers their respective ID numbers. How can i change this?
View 1 Replies View RelatedI've been searching these forums but couldn't find what I'm looking for. Here's what I need - maybe I'm going about it the wrong way.
I have a table called Customers. For each customer (custid) there can be multiple contacts - contact1, contact2, etc. each with their own phone, e-mail, etc.
I have a form called New Job - when I enter a new job and select the customer - I would like to have a drop down box of the available contacts for that customer (based on custid). Everything I've seen so far only allows me to have a drop down from the same field - not multiple contact fields.
Any thoughts?
Thanks!!!!
i searched for similar combobox features, nut didn't find any that helped.
i have 2 unbound combos that get heir values from different tables
first combo1 gets its values from a query
SELECT [tbl_music].[MID], [tbl_music].[Artist], [tbl_music].[Song], [tbl_music].[CID] FROM tbl_music;
combo2 gets values from
SELECT [tbl_category].[CID], [tbl_category].[Category] FROM tbl_category;
IDs are autonumber and primary
The CID fields in the tables are in a 1..* relationship
Both are constructed with the wizard and the ID columns are hidden.
What i need is:
when selecting something from combo1, the combo 2 should show the right category for that song.
Hope i explained clearly enough.
I tried to use the dlookup function, but i get error 94, invalid use of null.
i'm using the afterupdate event.
I can update a textbox text, but can't do so with the combobox value.
Any ideas what i'm donig wrong :confused: :confused: :confused:
Hi I really have a problem in MS access.
I created a combo box which as 2 columns, eg Plant ID and Plant name
I need to have the Plant ID on the left and Plant Name on the right which it is at them moment, however....
When I choose an option inthe combo box, it will display the Plant ID number in the textbox because it is on left (its the 1st column in the drop down box)
.... I want it to show the plant name instead, but still have the plant id colun on the left and plant name onthe right when i click the arrow of the drop down box,
sry if its confusing, i need an anwser ASAP, thanks!
I've seen comboboxes before that by typing the first letter of the word your looking for it will go to the first word matching that letter, but then by typing that letter again it will go to the next word starting with that letter:
Such as in a "Choose Your State" box by typing "M" it selects Massachusetts then by typing m again it selects Maryland, the third time it selects Maine... and so on. I would like to add this to a cbobox on a form but havent had any luck. I have searched the forum but didnt find anything pertaining to this. Any help or suggestions on where to get this info is greatly appreciated.
JO
hi, i'm a newbie, i've got a question about combobox:
i've a form "Order" and a subform "suborder" with a combobox based on a table "Object" with this value: ID, Object, Price, Category. When i choose a value, the combobox returns to the "suborder" table ID value...now, is possible to returns also the others value to that table??
Please answer me....sorry for my bad english i'm italian
Thanks early!!!
hi, i'm a newbie, i've got a question about combobox:
i've a form "Order" and a subform "suborder" with a combobox based on a table "Object" with this value: ID, Object, Price, Category. When i choose a value, the combobox returns to the "suborder" table ID value...now, is possible to returns also the other values to that table??
Please answer me....sorry for my bad english i'm italian
Thanks early!!!
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
Hi,
i have placed a combo box on my form using the wizard. the form is based on a table which is related to a query to reduce the amount of entries. when i scroll through the records, i only see the correct numbers based on the event however, when i add the combo box, it shows ALL entriesin the table instead of the ones i can scroll through. the numbers seen are-
1,7,9,10,23,24,28,29,32,33,38, these are all payment numbers based on a name. the combo box shows all payment numbers 1,2,3,4,5,6,7,8,9,10 an so on. can this be altered to show only the available record numbers?
the payment number is also the primary id number for that table.
many thanks,
Nigel
Hi guys I know how to count a listbox value, but how can I count a combobox, I'm trying to count the results in the combobox. for example if the comobobox has three itmes in it how can I count them in a textbox?Thanks.
View 1 Replies View RelatedHello Everyone,
I wanted to know how I can set a default value into the combo box. The value I type in the Default value box doesn't seem to work.
Here's what i want to accomplish.
My default value should be my computer user id
=Environ("UserName")
How can I do this?
Thanks,
Hi,
I have data of type "number" shown in the drop-down combo-box in a form. It has some codes in the event of "After Update".
My problem is that i can't type in something like 13* in the combo-box in order to get anything starts from 13. It says "The value you entered isn't valid".
The reason is that i want user to be able to use the wildcard. I know that i can do this with text. I'm not allowed to change the structure of the table in the database.
This combo-box shows IDs from one of the exisiting tables. That IDs is of type "autonumber" in the table.
Is there a better way of doing this?
Thank you in advance
I'm not entirely sure if this is possible, however I'm pretty sure I have seen it done in the past. But I've been racking my brains and scouring google for the solution with no luck what-so-ever.
What I'm trying to do is display a query, where one of the fields will have a drop down box that you can select from multiple values. I dont want to give away much information about the database structure (sensitive data, and all that fun stuff I'm sure most of you are familiar with). So I'm going to make up a hypothetical situation here.
Table: Person
Fields: pID, pFName, pLName, sID
Table: Status
Fields: sID, sDescription
Here is the basic query:
Select pID, pFName, pLName, sDescription
FROM Person, Status
WHERE Person.sID = Status.sID;
Then when the query is displayed, I'd like the status description to be capable of dropping down a list of the other possible selections. Now I know this wont work on a standard query. So what I did was create the query, then a form that displays in a query view. I have the one field as a combo box instead of a text box. However I'm just having trouble linking it up, it just shows what the current value is but not the other possible options.
If anyone could point me in the right direction, I would surely appreciate it.
Thanks
I have a form with a combobox called fraShipDay. How do I reference the value of the user's selection in a query? I've tried using Forms![Form1]![fraShipDay] but it's not working.
View 2 Replies View Related