Updating a Combo Box

I'm trying to design a form with 2 combo boxes. I would like to enable the user to select a value in the first combo box (currently linked to a list of fields) which will trigger the list of values (in this case the values in that field from a related table) for the second combo box.

Sponsored Links:

Related Topics

Update Value in Combo Box
I want to be able to update value in text box based on the value in a combo box. This would be in a Access form.

For example, I have the following values in a table.

Name Number
Johnson 1234
Curtis 5678
Jones 2468

So, I did the following.

The Row Source of the combo box needs to include both columns (fields).

=[YourComboBox].Column(1)

This worked (when entering data in name field, number field updates in the form) but now I am finding when I add data thru the form the number fields are not updating in the table. All the other fields in the form are updating.


Prevent combo box from updating a table
My application includes a Combo Box which gets it's values from a query, when I close the form it inserts the value which is in the combo box into the table from which that data came from. How do I prevent the insert?


change textbox value after combo update
I have combo box. Its values are from a query. No I want that after updating value of combo the value of text box will change. For example

1. I have a table named table_bill containing Item & Description field
2. In a form name form_bill containing one combo box. Values of this combo box is items of table table_bill.
3. Now I want that when I change the value of combo box automatically value of text filed Description will change. And the value will be corresponding description of item from table_bill


Combo Search Box not updating after Form Edit
I have a combo box on a form where I am allowing users to edit.

The combo search box updates correctly when the user does not edit the record in a form. however, after editing a record an error comes up and the form does not update with the new value in the combo box.

[CODE]

when the error occurs it high lites Me.bookmark=rs.Bookmark


Updating Unbound Combo Box based on pop up form
I have an unbound combo box (Combo9) on a form Fm_Data_Entry. I use a click button to open a pop up form from fm_data_entry which adds in another value to the source table of the unbound combo box, however, I can't get it to update yhe combo again with the new value without actually closing the fm_data_entry and opening again.

Howcan I get the unbound combo box to update the new table value without closing the form down?


Populate combo box based on selection from another combo box
I've been trying to find a way to filter one combo box based on another combo box selection. My problem lies herein. The first combo box is a list of import dates. I need the second combo box to populate with the Vendor names that were imported on the date that has been selected from the first combo box. Based on the selection of the second combo box I then need my form to populate the records that are associated with the two selections. I would like to do this using VBA.


Populate one combo box based on the selection of another combo box
I have a combo box that displays values based on the selection of another combo box. My problem is that when I make a different selection in the first combo box, the text in the second combo box does not change. Although the drop-down items are correctly changed in the second combo box...


Combo boxes requiring enter key
I have a db that I've used for a couple of years. I was updating a form and now every combo box on every form requires the enter key to be pressed to select an item from the list and change focus to another field. Whyyyyy? And how do I remove the need to press the enter key to make a selection in every combo box


new problem: Updating Combo box
I have a Form and a subform in detail section which has another subform in Formfooter. The Combo box is in second subform and is dependent to a field in first subform. Its row sourse is a query which show me the data just for first time.by the way both of subforms are continues.


cascading combo
In creating a cascading combo 3 to be exact. It is as follows.
1st - Make
2nd - Model
3rd - Year

I know I don't know how to do it that's why I came to the EXPERTS for advice, guidance and help! Also please consider how to do the updating of the data on each combo box


Synchronize Two Combo Boxes on a Form
This topic illustrates how to synchronize two combo boxes so that when you select an item in the first combo box, the selection limits the choices in the second combo box. For example, you may want the products displayed in a combo box to be limited to the category selected in another combo box.
Learn how to limit the choices in a combo box when selecting an item in another combo box.


Updating a date text box from a text box
I've got a form with a text box that has a date field that the user has to pick a date. I also have a combo box on the same form with different lengths of time in there the user also chooseseg 6 months 1 year 2 years etc.
What I want to happen is the third date field text box To look at the first date filed text box add the period from the combo box and automatically update the third date text box.


Automatic Query for every change in record
I have a form that keeps tracks of jobs. On the form there is a combo box for customer numbers. Beside the combo box there is a list box that displays the name(s) of the customer with that number.

The query attached to the list box works fine, whenever I change the value in the combo box it updates properly. Below is the VBC

Private Sub cmbPartner_AfterUpdate()
Me.lstPartnerNameID.Requery
End Sub

Private Sub cmbPartner_Change()
Me.lstPartnerNameID.Requery
End Sub

The problem is when I go through all my records in form view the partner name is not updating. It only updates when I update/change the value in the combo box manually. Is there a way for the query to re-query itself automatically when the record changes?


Refreshing a combo box
I am using the following command after a user selects a combo box for an item and I want the person related tot that item to be updated through a different combo box, the command I am using is;

DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70

I put this in the After Update on the first combo box and I tried it on the On Got Focus and they both work fine except there is a 5 - 10 second delay before the 2nd combo box populates. Any ideas on how I can make the second Combo Box populate faster?


Refreshing a combo box
I am using the following command after a user selects a combo box for an item and I want the person related tot that item to be updated through a different combo box, the command I am using is;

DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70

I put this in the After Update on the first combo box and I tried it on the On Got Focus and they both work fine except there is a 5 - 10 second delay before the 2nd combo box populates. Any ideas on how I can make the second Combo Box populate faster


Set Value of TextBox(different value than cmbx) based on yes/no Combo Box
I have a yes/no combo box, default value set to yes. After that value is updated, I want the value of a text box to be a decimal value.

Example: if combo box = yes, then text box = .02, if combo box = no, then text box = 0

I think I can do this with a macro in the after update of the combo box but I'm not sure about the syntax.

This is on one form built off one table. The text box is not on the form, just the combo box


Updating subform based on combo box change
I have the following tables: COMPANY and PROSPECT. I've set up a one-to-many relationship between them. I have a COMPANY_VIEW form and on it a bunch of subforms - one of which is PROSPECT_VIEW. A PROSPECT has about 50 fields. I have a Combo Box that is bound to PROSPECT_NAME, and populated by a query that works. The other 50 fields populate when you first load; it loads the first PROSPECT by default.

Here's what I want: when you select a different PROSPECT_NAME in the Combo Box, it should refresh all of the other fields from the PROSPECT with that PROSPECT_NAME.
I've had the PROSPECT_NAME combo box on the PROSPECT_VIEW subform, but tried moving it to the COMPANY_VIEW form and it still didn't work.

I'm guessing I need to do something with the Combo Box's AfterChange event but every "requery" solution I found online and tried did nothing. I think that's because it's re-running the original query, which just populates the Combo Box and selects the first PROSPECT by default. But I don't know how to force it to select a different PROSPECT.


filter subform combo box by mainform combo box
Here is my problem. Trying to solve from last week. I am working with case files. In my main form I have a combo box named cboCaseType and in my sub form I have another combo box names cboCaseStage. I want to filter sub form combo box (cboCaseStage) by main form combo box (cboCaseType). I learned that I need to cascade combo boxes. but I can not understand what code I should write to filter sub form combo box by main form combo box. file attached with the post. Any help will be appreciated. Pls help me if you can. Thanks and


Basing combo one combo box on another
I have a sub-form on a form that I use 3 combo boxes to filter down choices for a certain field. I have the first combo box that shows 'Type of Source', the next combo box is 'Advertiser Name' and the final box shows 'Campaign '.

So the user picks a Type of source, and then the advertiser box only shows advertisers that are the same type of source picked, then the user picksa campaign that has been assigned to that advertiser.

I am having problems with updating the combo boxes. On form current I have all three combo boxes re queried

ComboSource.RequeryComboAdvertiser.Requery
ComboCampaign.Requery

On form load I have the following

[code]

When I create a new entry and fill in the data, the criteria works ok, but when I navigate to an old record, the combosource and comboadvertiser boxes stay the same and don't change, and when I go back to the record I created only the comboCampaign box shows the correct information, the other two are blank.


combo box values dependent on selection another combo box
what I want to do is populate a combo box whose values are linked to a specific value in another combo box.

depending on what value is selected in the first combo box will dictate what values are shown in the next combo box