MS ACCESS :: Updating Another Field Upon A Selection From A Combo Box

Autofill Field From Selection In Combo Box
Hi all,

I am fairly experienced with Access but am stumped. I have a table with a primary key ID field, product name, and product price. On an order form, I want to select the product from a combo box and have that product's price automatically populate a text box beside it for further calculations. Any help would be much appreciated, thank you!

View Replies ! View Related

Help With Combo Box Selection Being Determined By Entry In Another Field
first of all, i'm new to access. the only experience i have with it is reading the "microsoft office inside out", access section, and doing some research on the web.

i work for a school district and my boss has asked me to make a database with all our assets. i used to have everything in excel, but he prefers access, so here i am. what i'm wanting help with is making a combo box that lists manufacturers like hp, dell, etc., and then having the next field show a list of models depending on what was selected in the manufacturers field. so if i select dell, i want only dell models to show up in the combo list for models.

i can make the combo lists, but i don't know how to make it so that the entry in one field affects the list in another field. i've tried putting in lookup values, i've tried doing it with expressions in queries, and a few other things. i've tried searching google, and the forums and i've found things that are kind of similar to what i want, but doesn't do exactly what i want. so here i am...is there a simple way to do this? this isn't required of me, but now it's driving me crazy because that's the way i'd like to have it but i can't figure it out.

i'd appriciate any help with this.
thanks.

View Replies ! View Related

Populating A Text Field From A Combo Box Selection.
I have a combo where the list is populated with a bit of VB code to create a two field list. When the user selects the item they want from the list it displays the item in the combo box and should populate a text box in the same row with the value from the second column.

This combo is part of an orders subform and the user is selecting a product from the list which displays the product_name and the product_id.

The problem is that the product_id is not filled in and access returns the following error:
Run-time error ‘3101’:
The Microsoft Jet database cannot find a record in the table ‘product_table’ with key matching field(s) product_id.

This is the VB code that populates the list :
[code]
Private Sub comboCatagory_ID_AfterUpdate()
Dim sProd_description As String
sProd_description = "SELECT products_table.product_id, products_table.prod_description " & _
"FROM products_table " & _
"WHERE products_table.prod_catagoryID = " & "'" & Me.comboCatagory_ID.Column(0)
Me.comboProd_description.RowSource = sProd_description
Me.comboProd_description.Requery
End Sub
[end code]

What am I doing wrong?

Thx
Kev.

View Replies ! View Related

Field Values Based On User Selection In Combo
Hello,

I'm stuck! I want to create a form which has a combo box where you select
someone's name, and their address appears in another text box on the same form. The names and addresses are in a table called "cardholders".

I'm doing separate combos for first name, surname cos I think that's the only
way you can do it.

The fields in the table are credit_add, credit_name & credit_surname. The combos are called "cardholder name" "cardholder surname" etc. This is the code in the text box where I want the address to appear:-

=DLookUp("[credit_add]","cardholders","[credit_name] = '" & [cardholdername] & "' And [credit_surname] = " & [cardholdersurname])

Can anyone help?

Thanks.

View Replies ! View Related

Updating Time Field Combo Box
Hi, I have a field of type time that I want to update by 30mins everytime a user submits the form and goes to the next record. That is, it displays 9:00 when the form opens, the user fills all information, and clicks submit, then it should display 9:30, and then the next submit 10:00. I have the following code to do that but it's not working. What am I doing wrong? Thanks!
Private Sub Timer_AfterUpdate()
Dim Test As Date
Test = DateAdd("n", 30, Timer)
Timer.DefaultValue = "'" & Test & "'"
End Sub

View Replies ! View Related

Combo Box Not Updating Table Field Properly
I have created a combo box with the two fields CompanyID and CompanyName. I used a query for my combo box and it looks at my company info table for the info. I want it to update the two same fields on my contact Table but it updates the company name field with the CompanyID and and the company ID field dosent update at all. I am not sure were I went wrong please help.

Rickilynn

View Replies ! View Related

Text Selection From A Combo Box Selection
What i need is a text box that displays the values of a of one of the field with a selected table.

To explain. I have a series of combo boxes to get dwon to the final choice of a table within the access database, eg T1_project1_121206_1200 within each table is load and displacement.

with the selected table, i would like the text box to display the values of, say Load. inorder to create a table.

Can anyone help me?

View Replies ! View Related

Change Combo Contents Based On Previous Combo Selection
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 Replies ! View Related

Combo Box Selection Triggering 2nd Combo Box Tables
I'm trying to get one combo box control what tables are available from another combo box. Example, combo box (a) includes numbers 1-5. Selecting (1) makes the data in combo box (b) specific to that selection. Selecting (2) makes the data in combo box (b) something different (pulls data from a different table).

Can anyone help me with this? Thanks!

View Replies ! View Related

VB Error Updating Text Box From Combobox Selection
I have a combobox selection ('product description') in my orders form which when updated must populate the product_id field.

The combo box displays both fields, but once the user selects the item then the value of the combo is set to the product description and the product ID field should automatically be populated.

Once this works I will want the other fields in the record to update - do I do each field the same as product_id or can I do a requery for the who record

I am using the Dlookup function (maybe the wrong thing) as it seems to do the same thing in the Northwind sample database.

this is the before and after update code :-
[Code]
__________________________________________________ _________________________________
Private Sub comboCatagory_ID_BeforeUpdate(Cancel As Integer)

REM BEFORE UPDATE on 1st combo ALL WORKS - included for info only
REM sets the RowSource for problem combo

Dim sProd_description As String
sProd_description = "SELECT products_table.product_id, products_table.prod_description " & _
"FROM products_table " & _
"WHERE products_table.prod_catagoryID = " & "'" & Me.comboCatagory_ID.Column(0) & "'"
Me.comboProd_description.RowSource = sProd_description
End Sub
__________________________________________________ _________________________________
Private Sub comboProd_description_AfterUpdate()

REM THIS IS THE BIT THAT IS BROKEN

Dim strFilter As String
comboProd_description.Value = comboProd_description.Column(1)
strFilter = "product_id =" & comboProd_description.Column(0)
Me!product_id = DLookup("product_id", "product_table" strFilter)
Me.product_id.Requery
End Sub
[end code]

This generates the following error when the item is selected from the list:
Run-time error 3075
Syntax error (missing operator) in queryexpression 'product_id'

Note: Once this works I will want the other fields in the record to update - do I do each field the same as product_id or can I do a requery for the whole record

Any help greatfully accepted.

Thx
Kev.

View Replies ! View Related

Updating Combo Box Contents Dependant On Other Combo Box
I have created a database that is used to track various programs that our organisation runs, and keeps a record of which Division the program is in.

at the moment I have a main form which has a combo box that lists Divisions, then I have a subform that has a combo box on it that lists the purchasers.

what I would like to do, is to have the Purchasers list update when a Division is selected in that main form, as depending on which Division is chosen the contents of the Purchasers list changes drastically.

Is anyone able to offer some assistance?

View Replies ! View Related

Combo Box Selection
Hi

I have table customers where i store all info about customers( lastname, firstname , company name ,address, phone #,city, zip). Right now i have a customer form where i can just enter customer info using text box, now i want it make the firstname , lastname and company name as combo box so that i can look up existing customers and edit if necessary( if the address is changed) . Mainly if i select lastname in the lastname combo box i should see only related data in the firstname and company name( this is what im trying to do) and my primary key for the table is {lastname,firstname,companyname}

Any suggestion or help for doing this is greatly appreciated.

Waiting for reply from atleast one person

Thanking you
chinna

View Replies ! View Related

Combo Box Selection
I have a form with 4 text boxes that are populated from a query with an unbound cbo box to make the choice from. There are two fields that show on the dropdown, "Customer" and "New Product Name". I created it all with wizards. Most of the Customers have only one product name but some have several. If I choose a customer that has several products, it always selects the customer with the first product it finds. How can I get it to select the Customer by product? I have looked and seen what looked like what I needed on this forum, but I couldn't make it work. I am not good a VB. Thanks in advance for any help that you can give.

View Replies ! View Related

Combo Box Selection
I have had some help on this previously but its not working the way i wanted.

I have a form called plan distribution which holds a record of all people who need a copy of a certain plan. There are several hundred contacts held in the database and i want to make this as easy as possible to choose the right ones.

To do this i want to have 3 combo boxes. One each for company, department and contact.

On the plan distribution form i want the user to select which company they want. The department combo box will then automatically show all departments within that company.

Once the user selects the department, the final combo box will hold all contacts within that department.

I have tried several ways of doing this but cant find one that works!

HELP!

View Replies ! View Related

Combo Box Selection
Text is brought into a form field as a result of a combo box selection, is it possible to use the same combo box to select another value that could be appended to the same field as the first selection?

View Replies ! View Related

Combo Box Selection
As you have read in my other posts I am creating a Rental database. Now I need to show ages in this database and the certificates they have on films. I have 2 problems

1) I have two fields one called date of birth and one called Age. I am wondering if I enter there date of birth, can I make the age appear automatically.

2) Also when im adding more films to my database I want one combo box saying with the options DVD/VHS/GAME and then the other saying the age certificates because Game and DVD certificates are different so I was wondering if the first combo box makes the other combo boxs options

View Replies ! View Related

Combo Restricted Selection
Hello,

I have Customers recorded and a number of addresses associated with each customer.

They are in two tables linked by CustomerID and are shown in forms as frmCustomers & subfrmCustomerAddresses.

From frmCustomers, I open another form which records the orders maid by that customer. What I would like on this form is to select the customer address to be used for the order.

I can build a combo, but this shows all addresses on the database. What I would like for the combo to show only the addresses for that customer only.

I do not want two combos, one which selects the customer and then another which shows the addresses. This is not very user friendly to ask for the customer again. I would like one combo to show addresses for the customer on the form.

I would be grateful for any guidance on how I can achieve this.

Thank you.

View Replies ! View Related

Combo Box (Filter By Selection)
hi all,
another quick question (last one for awhile I promise) but is there a way to add an option to a combo box (Filter by Selection) and Remove/Filter sort without right clicking on it?
cheers,
Andrew

View Replies ! View Related

Combo Box Record Selection
I have a Main Form
Main Form [Event],[Category],[Judge Name]
The Main Form also has a subforms
Sub1[Event],[Category],[Judge Name],[Score],[Comments]

On the main form I have a combo box that is set to retrieve records that meet the combo selection. and thus the subform is related to display the corresponding records.

In my selection combo box I see all of the various selections as follows
[Judge Name],[Category],[Event]
and it is bound to the judges name

Problem Example:
Pull Down Values
1.[Sherry],[Fitness],[Mrs. Canada]
2.[Sherry],[Swim Suit],[Mrs. Canada]

In the above when i pull down the combo box to select and I select the first example above all is wonderful ; however if i want to select the second row the [Category] and [Event] Do not change and the information i input into the subform ends up being associated to the wrong category.

How do i bind a combo box to more than one [field] on the form

I have over 50 hours into this DB to this point and this is critical.

View Replies ! View Related

Combo Selection Comes Up WRONG
I have a form with combo boxes for selecting products to be purchased.

When a product is selected, the price appears in a text box. This is working fine by making the bound column of the combo box the field containing the price.

When I have two different products that have the same price, however, the combo box always displays the name of the first item of that price.

For example, a jar of Lavendar Oil costs $12 and a Small Exercise Ball costs $12. The Combo list is sorted alphabetically. When I select the Small Exercise Ball, I get the $12 in the text box, but Lavendar Oil shows up in the combo.

How do I make the combo show what I'm selecting? I assume it's something with the bound column, but can't find the resolution.

I hope someone is able to help me with this................

View Replies ! View Related

Combo Selection Does Not Show
I have a combo box set up to select a product and put the price into a text box. I am getting the cost showing up in the text box Therapy_Cost just fine, but the combo box itself does not display anything after I select something. If I remove the AfterUpdate, I do get the item displaying in the combo box, but, of course, don't get the price in the text box. Here are the details. Can anyone help?

Combo Box
Name:
Therapy_Type
Control Source:
Therapy_Cost
Row Source:
SELECT Purchase_Items.ItemID, Purchase_Items.Item_Name, Purchase_Items.Item_Cost
FROM Purchase_Items
WHERE (((Purchase_Items.Item_Type)="2"));
Number of Columns:
4 (In this order - ID, Type, Name, Cost)
Bound Column:
1
Column Widths:
0";0";1";0"
AfterUpdate:
Private Sub Therapy_Type_AfterUpdate()
Me!Therapy_Cost = Me!Therapy_Type.Column(3)
End Sub

View Replies ! View Related

Combo Box Will Not Display Selection
I have a form that calculates freight costs. I'm using a combo box for the user to select the route of the shipment from shipping port to destination port. The combo box has 2 fields. The index which is stored in the database and the description which is displayed to the user. I used the wizard to create the combo box and set the index to be saved in a table. Everything works fine, the freight cost is calculated correctly and the data is stored as designed.

The problem is when if the user goes back later and opens the screen to view the freight information, the combo box doesn't display what was selected previously. Therefore, no freight is calculated and the user has to reselect the combo box again. When I check the table, the index value of what was selected is in the table, but it will not display in the combo box.

. . . . Additional info to this post. . . . The combo box is set to use a data from a standard table. The user can only select what is displayed in the list. However, the index is then stored in another table after the selection is made. I want the combo box to do something like, if a selection was previously made then displayed what was select, if not, then display the data from the standard table.

What did I do wrong during the set up? Thanks for your help solving this problem.

Jeff

View Replies ! View Related

Combo Box Selection For Query
I'm new at Access 03. I have a combobox that is sourced by a table, Rowsource property is:

SELECT Classes.TableID, Classes.ClassID FROM Classes;

The name of my combobox is "ClassCombo".

I'm trying to generate a report based on my combobox selection, but I can't reference the value of the selection. The query tied to my report has the following SQL:

SELECT ClassesForInstructors.ClassID, Instructors.InstructorID, Instructors.FirstName, Instructors.LastName
FROM Instructors INNER JOIN ClassesForInstructors ON Instructors.InstructorID = ClassesForInstructors.InstructorID
WHERE (((ClassesForInstructors.ClassID)="[Forms]![School]![ClassCombo]"));

I'm trying to grab the "ClassCombo" value as input to my query, but it's not working. What am I doing wrong?

Thanks!

View Replies ! View Related

Multiple Selection In A Combo Box
In form "sendmail" their is a combobox "to" which gets ur email address.
i want we could be able to select multiple entries thruogh this combo box and it should be seprated by a semi colon

View Replies ! View Related

Making The Selection In A Combo Box Stay.
Hi everyone,

I have created a combo box in my form, the options for the combo box are coming from a table. It all works fine expect for some odd reason, when I click on an option in the combo box then come out of access, when I go back into the database the one I had chosen has gone. Do you know how I do so what I put in the combo box will stay?

Thank you in advance for your help.

View Replies ! View Related