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 Complete Forum Thread with Replies
Related Forum Messages:
Autofill Based On Selection - Please Help
I am learning Access fairly quick, but still a newbie and stuck on an autofill problem. I have read everything I could find and it seems there may be code involved, which I'm not sure about. The problem seems simple enough: I want to populate field "Rate" in the table "Services" based on the selection from a dropdown menu referencing ClientID in the Clients table. Specifically, my form uses a drop down menu to select ClientID for the Client table to associate with fields in the Project table and I have imbedded another form at the bottom which contains fields from the Services table including the Rate field I want autofilled based on the ClientID selection. Here are the tables and fields I'm working with... ...table... Client ...fields... ClientID (PK) Rate <and more> ...table... Project ...fields... ProjectID (PK) ClientID <and more> ...table... Services ...fields... ServicesID (PK) ProjectID Rate <and more> Please be easy on me if this is a simple problem. Thanks!!!
View Replies !
Updating Another Field Upon A Selection From A Combo Box
Hi, Im trying to get one of combo boxes to update a field automatically.. There are two choices in this combo box "Gatwick" and "Woking" what i need is when one is selected the JobNo field will update itself to GWO-(the first Unused JobNo) Ive used some VBA to make atleast the GWO- or WWO- appear and it works, but i have no clue as to how to get the next unused order number to appear after it. This is what i have so far: Private Sub JobLocation_AfterUpdate() If Me.JobLocation = "Gatwick" Then Me.JobNo = "GW0-" Else Me.JobNo = "WWO-" End If End Sub Any help would be greatly appreciated. Cheers Marc.
View Replies !
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 !
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 !
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 !
AutoFill From A Combo Box
Hi there everyone. Please could someone help me with a problem! I have a form running from two qry's deceided by grp selection, written in the back end with VB. My problem arises when I attempt to autofill txt fields with the record connected to the selection made in the cbo box. Can anyone give me advice (all of which will be greatly appreciated) and can anyone see a good way of doing this. Thank you for taking the time to read this and I look forward to any guidance. Chris.
View Replies !
Autofill Combo Box
I have 2 forms with 1 combo box in each form. I would like to be able to choose, for ex. a date in 1st combo box and be able to have that displayed in the 2nd form in the 2nd combo box.
View Replies !
Autofill Via A Combo Box
Hi sorry I am only new to this, I am trying to learn as I go so please excuse my ignorance. (I have done some searching on this forum but am just getting more confused) Anyway I have a form which is based on a table that holds all the info for orders placed by customers. It holds info on all the orders plus some info about the customer Example of Orders Table Order ID Customer No Suburb State Item Number Qty Ordered Description Length Weight Order Type Day Received Last Dispatch Day Actual Dispatch Date Comments Date Due at Customer On this form I would like a combo box which is linked to a Customer table which has all the details regarding the customers. When I pick the customer I would like all the other fields relating to the customer on this form (Customer No, State, Suburb) to be auto populated to save entering data individually. Example of my Customer Table CustomerID Customer Name Customer No (not unique) State Suburb Customer Factory Rail Terminal code Destination Rail code Destination Road code Cust Code I have tried many different ways but no success. Any help or advise would be most appreciated Tks
View Replies !
Autofill Input Box (non Combo)?
Anyone know if an input box can have an autocomplete like Comboboxes? So say I type the string "Blue House, Red Carpet, Green Grass" and enter it. the next time I go to enter in a value and start typing "Green Grass", the form, auto inserts it, and as I start typing "Blue House", it is also auto inserted. anyone know if this is doable?
View Replies !
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 !
Multiple Combo Controls And Autofill
Hi I have three cascading combo controls. What I am looking to do, is that when the value of combo one is chosen, the second combo box is requeried. What happens at the moment, is that when the second combo value is choosen the third combo is requeried and depending on that value a text box it autopopulated. Ideally what I want to happen is that when the second combo value is chosen, the values which at the moment appear in the third combo box will autopopulate 2 text boxes. There will only ever be 2 values in this box. I hope that I have explained this properly. So rather than using autopopulate to fill text boxes using the columns of a combo box, I want to do this using two rows in a cascading combo box. Hope this makes sense
View Replies !
Autofill From Many Combo Boxes In One Form
Hi all! :D I'm trying to make a form to autofill with customer data (from a database), with 4 columns (= 4 customers). Each column contains on top a combo box and below 5 text boxes with address, phone etc. So i created a form and placed a combo-box (from wizard) with the option "Find a record on my form based on the value i selected in my combo box". The problem is that this one combo box controls all the text boxes. Even if i create an other one, it still controls all of them. So i'd like to ask: How can i link a combo box, to autofill specific textboxes?:confused: Thanks... :)
View Replies !
Autofill From Combo To Text Box Questions
Hi all I use a form that has a combo box and a text box.The combo box values are Email,Cna,Dna.I manage to make users to select values from combo box and show it in the text box.I want to ask if it is possible when user select "Cna" and "Dna" from the combo box the same will appear to text box but the text box will be locked.If you choose email it would be enable. Thanks
View Replies !
Autofill Text Boxes Based On Combo Box
:confused: I have a combo box on a form that is used for data entry that allows the user to pick the date. This is based on a table that includes date, week ending date and month, all very specific for our business. I used a function that says Me.txtBox=ComboBox.Column1 for example. So my combo box would include all the information, and all but the actual date is not visible. I want this to feed into another table that will be used for reporting, and that table has the same fields of date, week ending date and month. I keep getting an error saying that the value selected from the combo box doesn't fit the criteria, and I believe what is going on is that it is taking all the fields instead of just the date. Any suggestions how I can still have the text boxes update if I only have the date in the combo box?:confused:
View Replies !
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 !
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 !
Autofill Of 1 Field
I have 2 forms (school and venue) I have a button on the school form that opens the venue form. I want the school field that is on the venue form to auto fill with the same information that is in the school field on the school form. Any help would be awesome. Martha
View Replies !
Autofill Field With Employee
Hello all! Ok, lets get down straight to the point. What i want to achieve is that when i login that automaticly the name has been filled in on every form. I have a login form. I put my name in there like "Michiel" and ofcourse the password. After that its going automaticly to the mainpage. In that mainpage i want to create a field that automaticly filles in my name (so if somebody else log in that their name will be filled in). After that i want when i go the incident form that automaticly the employee form has been filled in. (The person that at the moment is logged in that his name automaticly been filled in) Ive tried various ways to achieve this goal but nothing worked. Im not that very expert in Access but im trying to understand and learning pieces by pieces the Access world. So if somebody could help me because im getting desperate! Thanks in advance all! :D Greetz. Creegfire
View Replies !
Have Data In 1 Field Autofill Another, Easy?
Here is what I want to do. I have a table called "TblRates" and in the table are two fields called "Description" and "Rate" the description field has data in it like "PC Repair", "Onsite Repair" and the "Rate" field has currency data "$50.00" and "75.00". I have a for called "FrmRates" and I want to be able to select "PC Repair" from the "description" field and have it auto fill "$50.00" into the "Rate" field and the same for "Onsite Repair" and have it bring up"$75.00". That is the best way I can describ it. I would like to either know a macro or somthing easy I can type in VB code which I know nothing about. Please Help
View Replies !
Question About Autofill Fields From One Individual Field
I have a form with the following Fields: Customer Name, Address, City, State, Postal Code, and Phone Number. I also have a field called License Number. This question is that once the data is entered the first time, is there an easy way so that if an individual that has been entered into the database comes back you can enter there License Number only and the other fields will fill in automatically. If so How. I am assuming so kind of query but i need help. Please Help..thanks
View Replies !
Autofill Fields Based On Results From Another Field In The Table?
I have an Access database with several tables and a multitude of subforms which are displayed on a single master form. The subforms are used to facilitate data entry. In several of the tables there are fields which are related and I would like to have some of these fields updated based on the results entered in the related field (i.e. the answer for one field depends on the other). Field 1Field 2 [facing][DISC_CODE] un3 up1 dn2 Field 1 is a simply a description of the basic dataset. This field is already set-up on form as a combo box that allows the user to choose one of three options. Field 2 is a code number used by another piece of software to identify a particular symbol. It is a new field being added to the database. There are 200 codes that identify a wide range of symbols for different types of data and I don’t want to have to look them up when I, or my assistants, are doing data entry. My question is this; is there anyway to have the DISC_CODE value, Field 2, automatically entered in the table when the value for Field 1 is selected in the combo box on the form?
View Replies !
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 !
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 !
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 !
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 !
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 !
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 !
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 !
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 !
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 !
|
TRACKER
