Populate Form Fields From A Combo
Jul 30, 2005
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.
Any help appreciated
Andy
View Replies
ADVERTISEMENT
Feb 21, 2011
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.
View 8 Replies
View Related
May 26, 2013
I'm trying to create a form using a combo box to populate multiple fields and tables.
I've created a text field to display the added information using this format:
=Comboboxname.Column(x)
in the text box control source field, and this works for display purposes.However, I need it to populate this data into a field on a table.
For example:
My combo box looks up data that has 2 columns, Part Number and Description.
The control source for the combo box is "Part Number". And that populates the part number in the "Main" table no problem.
The text box I created using the above format in the control source populates the field in the form, but not the "Main" table.
Is there a way for the other (description) field to also populate the "Main" table as well?
View 5 Replies
View Related
Mar 27, 2006
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
View 2 Replies
View Related
Jan 23, 2013
I have three tables with the following columns:
MoldReq
Mold_NoPart_NamePart_NoMaterialDateWork_Ord(Pri Key)
MoldLog
Log_IDMold_No(Pri Key)Part_NameLog_DateTime_InTime_OutHours
Molds
Mold_No(Pri Key)Part_NamePart_No
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
View 14 Replies
View Related
Jul 18, 2014
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?
View 5 Replies
View Related
May 27, 2015
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?
View 14 Replies
View Related
Oct 5, 2006
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!!
View 13 Replies
View Related
Feb 7, 2006
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?
View 3 Replies
View Related
Mar 17, 2006
Hi
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?
View 2 Replies
View Related
Aug 7, 2006
Hi all,
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:
Private Sub Form_Open(Cancel As Integer)
Me.CatID = stLinkCatID
Me.CatName = stLinkCatName
Me.OwnerID = stLinkOwnerID
End Sub
But I get the error 2448 'Can't assign a value to this object'.
However if I put the same three lines into the start of the subform's btnARSave_Click event it works fine:
Private Sub btnARSave_Click()
On Error GoTo Err_btnARSave_Click
Dim stDocName As String
Dim stDocName2 As String
stDocName = "OwnersAndCats"
stDocName2 = "AddReservation"
Me.CatID = stLinkCatID
Me.CatName = stLinkCatName
Me.OwnerID = stLinkOwnerID
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
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
Exit_btnARSave_Click:
Exit Sub
Err_btnARSave_Click:
MsgBox Err.Description
Resume Exit_btnARSave_Click
End Sub
What am I doing wrong? Why can't I populate the fields on open?
Many thanks
PT
View 1 Replies
View Related
Oct 28, 2005
hi
when a value is selected in a combo box then values shud be set to the textboxes in the same form
plz let me know hw to do it.
Please reply ASAP
thnx
View 2 Replies
View Related
Jul 16, 2006
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.
View 14 Replies
View Related
Sep 6, 2006
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:
View 1 Replies
View Related
Oct 5, 2004
Can I populate unbound fields on a continious form, if it is possible would you give me some code to look at or direct me to an article
Phil
View 2 Replies
View Related
Aug 30, 2013
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:
Me.emailbody.Value = DLookup("[Escalation_1]", "Status_Emails", "Status_Emails.Status =" & (cboStatus.Value))
My error reads: "Syntax error (missing operator) in query expression 'Status_Emails.Status = LOCATION NEED MORE INFO'.
LOCATION NEED MORE INFO is the value in my criteria cbostatus.value.
View 4 Replies
View Related
Jul 18, 2013
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 #.
View 1 Replies
View Related
Jun 24, 2013
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?
View 6 Replies
View Related
Jun 3, 2015
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).
View 4 Replies
View Related
Mar 12, 2013
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.
View 2 Replies
View Related
Feb 5, 2014
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 ")".
View 14 Replies
View Related
Aug 5, 2013
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...
View 1 Replies
View Related
Jul 11, 2012
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.
View 1 Replies
View Related
Mar 6, 2007
Hey all,
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.
Suggestions?
Thanks,
- MT
View 1 Replies
View Related
Jun 26, 2012
Is there a way to populate fields in Access from fields in Excel in Office 2010? If so, what do I need to do?
View 6 Replies
View Related
Jul 2, 2004
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!
View 10 Replies
View Related
