Trying to update fields (bound) on a form (built using the wizard) from value selected in a combo box. I can get this to work with unbound text boxes using an After Update event handler and a code query along the lines of:
Me!TxtJobCode1 = Me!CboJobDesc.Column(1)
But this doesn't work where the form field is bound to a table.
So qu is - how do I achieve the same result using table fields instead of text boxes?
I could use text boxes but not sure then how I can save that data as a record in the table if it is not bound to fields.
I am using Access 2007 and have reviewed many blogs and looked at the Northwind db to try to solve this problem. I would like to create a form that functions in the same manner as the "Order Details" form in the Northwind db. Specifically, I want to create a form that will allow me to input a value and have the form get data from another table and populate the table I need populated.
I would like to populate a table "Outside", field names are Key, Name, term, Value, Date.
The table that contains the data is named "CV" and the filed names are Key, Name.
In the form, I would like to enter a value for Key into a combo box, and have it put the value for Key and for Name into the form, and allow me to enter whatever I want to in the Term, Value and Date field. When I tab out, I would like all this data to be in the table "Outside.
I have a combo box on a form that shows 3 columbs from tblparts in the drop down, I wish to select one row from the drop down, that will enter the selected data in three fields on the form.
For example my form has three fields "part code", "Description", "cost".
Part Code = combo box Description = Text Box Cost = Text box
I want to select the data from the combo drop down to populate all three boxes.
Can sombody please help, as I have been stuck on this all afternoon. Cheers
I am trying to build a form in the MoldReq section so when the user selects the mold number(combo box) it will auto populate the Part_Name and Part_No fields by pulling the data from the Molds table.
I have tried following this video where I create a change event:
Code: Private Sub cboCombo31_Change() Me.txtPart_Name.Value = Me.cboMold_No.Column(3) Me.txtPart_No.Value = Me.cboMold_No.Column(4) End Sub
I have form with an unbound combo box which is populated from a query
It should populate a field in a table which is related to another - however it only works when i query by id number (primary key) and not the text value i want - is it possible to query both so it returns say 1,option 1 - then when selected it will place a 1 in the table - which is related to option 1 in another table instead of just having to select '1' which will mean nothing to a user?
My database will be creating quotes based on employees entries. Each quote will be unique because of the part. Each part has the potential to have Precious Metals, and Base Metals included. The employee must select the number Precious Metals and Base Metals that a particular part has. The problem lies with what happens after this selection is made. There are three fields that need to be defined pertaining to each metal. I need the number selected to determine how many fields to make available. If there are two precious metals, I need to make the three fields available twice; one for both metals. I have the possibility for up to 5 Precious Metals and 10 Base Metals per part. How can I make the selection from a combo box populate that number of Metals Fields?
I'm creating a form that will have a combo box and several other fields on it. From the combo box, I want to be able to select a line from the combo box, click on the line and then have the form's other fields get populated.
I know I have to have the combo box and fields tied to either a table or to an underlying query, but what might be my best way to get the form populated?
Should I, in code tied to the form, run some coded SQL based on what I select and use the SQL results, or should I use something like recordsetclone, of which I have no experince?
Thanks inadvance to thoe who respond!! I reallyappreciate your help!!
I have very minimal knowledge of MS Access and I have to create a database to input, update and display project information. How do I write a query to populate fields on a form, from either a single table or multiple tables?
I have a form with 3 combo boxes part No, Description, Cost. I have created a table with this information in I want to be able to select the information from either one of the three drop down boxes and the other two to automatically collect the information from the other colums of the table. Can anyone help please?
I'm sure this must be a well used function by many access users but I can't find anything about it online at all - please help!
I want to open a subform "AddReservation" and populate three fields with data taken from the relevant record in the main form. So in the btnOpenAddReservation_Click event to open the subform I set global variables, then in the form_open event I have this:
YesNo = MsgBox("This reservation has been added successfully, do you want to add another?", vbYesNo + vbQuestion, "Add More Reservations?") Select Case YesNo Case vbYes DoCmd.GoToRecord , , acNext Case vbNo DoCmd.Close acForm, stDocName2 DoCmd.Close acForm, stDocName DoCmd.OpenForm stDocName DoCmd.GoToRecord , , acGoTo, stRecordNo End Select
Hi. I tried to find out if this issue was already posted, but did not find. If anyone can help me, I am trying to auto populate two fields on a subform. The field I want to populate is the description of a role. So if the user selects the role name from the combo box, the description field will automatically update. Thanks.
I am looking to add multiple lines of record to a sub-form via a module activated from another linked sub-form. As an example of what I want to do: On identifying a particular type of vehicle servicing (e.g. 6000 mile service, 12000 mile service) on a service event sub-form of a vehicle form, I want to enter a list of required parts (e.g. oil filter, oil, etc) on another sub-form called "parts", that I can then edit before recording in an underlying table. Can anyone help. Thanks Steve :confused:
I am new to access and have been staring at the same Run-time error for 3 days (pathetic I know). I cannot for the life of me figure out why it does not like my Dlookup. Esentially, I want and After Update event in my combo box to populate a Rich text textbox in my form. After reading DLookup is the easiest way to make this happen. Here is my code:
I have a Customers table and an Orders table. My Customers table is a bit different than the norm because I couldn't figure out any other way to do this.
My client's customers are either businesses (companies) with a contact person, or individual customers. So, in the Customers table, I have the following fields (there are others but do not apply to my problem):
Customer ID Company Contact Customer
So, if it is a company the data entry person would enter the company name and the full name (EX: Doe, John) in the contact field, but if it is an individual customer, then they would leave Company and Contact blank and enter just the Customer name (Ex: Doe, Jane).
So, in the Orders table, I have combo boxes for look ups for the fields Company and Customer.
That works okay, but I would really like for the Customer ID to post into a text box once the Company or Customer has been selected. In other words, the input person would enter the name, then it would show that Customer's ID #.
I am wanting to populate a control in a form based off of two different fields in one table. Is that possible?I have a table called tblEmployeeMaster and it has a LastName column and a FirstName column in which I need to have both first and last name show up in one box on my form?
I have a form that I have exported certain fields into a word doc (it is up and running just fine). I created bookmarks in word and put some VBA into my access form, so when I click on 'Create word report' it pops up and automatically populates the record I am on. Here is the tough question,
How to make this work with a continuous form? My main form has several subforms, one being a continuous form. The main form shows one bridge at a time. The sub continuous form shows information for all of the bridges spans (could be anywhere from 1 to 9).
I have built a form that holds details of training records. What I want is when a drop down is selected in the main form, that it will populate some of the fields in the subform. I have this working at the moment, that for example, when a certain course is selected, that their modules will appear in the subform. Where my problem arises is that I have a relationship between two tables that I want to appear on the subform, so that details can be filled in on the subform against the list of modules that automatically appear.
I would like to populate form fields with records from a table/query so that they are bound to the recordsource and the record to be displayed can be selected from a combobox. I am hoping that in this way, any changes made are propagated to the original table.
I have created a combobox from which the primary key can be selected and added all the fields from the table appearing on this form as values.
In my Change event for the combobox I have this code:
Private Sub cboID_Change() Me.RecordSource = "SELECT b01_Participants.*FROM b01_Participants WHERE (((b01_Participants.ParticipantID)= " & cboID.Column(1) & "));" Me.Refresh End Sub
However, I receive an 3075 error when this code runs which seems to relate to my syntax or an extra ")".
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...
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.
I'm new to Microsoft Access but I'm not new to programming. What I want to do is when the combo box triggers and On Change event, do the following:
SELECT user_email FROM user WHERE user_first LIKE '[COMBO BOX CHOICE]'
Then set the value of that query to the textbox called "reportedEmail". I know this is easy, but I can't seem to find a decent tutorial on it anywhere.
I am a self-admitted beginner so go easy . I have a query populated with all of my data. I am building a form based on two columns in the query: Pick Up Name, and Deliver to Name. Lets say I have records for company XYZ picking up at location A three seperate times, location B once, and location C four times. On the form I want to have my first combo box listing all the names of column "Pick Up Name". When I scroll down and select company XYZ, I want my second combo box to only display the three locations where company XYZ has picked up: A, B and C. Then I want the option of selecting either A, B or C and in a third box, display total number of times that company XYZ has picked up at selected location.
For example, I select company XYZ from the first drop-down. I select C from the second drop-down, from the list of three locations. I get a result of four, because company XYZ has delivered to location C four times.
Right now, I have my first combo box with the Pick Up Name data, where do I go from here? Any help or nudges in the right direction greatly appreciated!