Combo Box Populating Text Fields
Jul 19, 2006
Hi All
Been having trouble setting up a combo box in a form that displays data from the same line in the table into a text box.
I am trying this with a memo field without any luck. I am using a 2 column query for the combo box, the first column contains the name and the second contains the requirements (memo).
I have put in the after update code:
Private Sub CustName_AfterUpdate()
Me!CustReq = Me![CustName].Column(2)
End Sub
Can anyone please shed light on what I'm doing wrong?
Thanks
View Replies
ADVERTISEMENT
Dec 14, 2004
I have two questions.
I have a form with 2 combo boxes. The first pulls from a simple list. Once you make a choice, the second combo box is then filtered by the first. This works correct, except that once a choice is made in the first, the filter is locked. If you change the first combo box's value a second time it does not effect the second box. The query that I am using for the second combo box has two columns that pull the first 50 characters of a pair of memo fields. Quote: SELECT MSSS.SS_ID, Left([Application_Name],50) AS Expr1, Left([Description],50) AS Expr2, MSSS.Site_Code
FROM MSSS
WHERE (((MSSS.Site_Code)=[Forms]![Edit or Delete Requests]![Combo6])); These fields are then used to populate 2 text fields using an event procedure. Quote: Private Sub Combo10_AfterUpdate()
' Display Partial Application Name and Description based on choice
Me!txtApplication_Name = Me!Combo10.Column(1)
Me!txtDescription = Me!Combo10.Column(2)
End Sub This is working fine, but it starts the next problem.
I need to change the form to include the entire memo field into a text box. I was using the columns of the second combo box to fill them in. Since the combo box is limited to only 50 characters, i could only grab part of it. I am guessing there is a much better way to accomplish what I need, but I am too inexperienced with forms and vb to come up with it. Below are the fields I need from table MSSS
Business_Name
Application_Name
Description
Acronym
Level_1_Support
Level_2_Support
Escalation_process
Troubleshooting
Priority
Links
Modified
Disabled
Thanks in advance to any help!
View 5 Replies
View Related
Nov 13, 2006
Probably an easy one here...I have a series of cascading combo boxes where once the last once it chosen, I'd like some sales info to populate in a group of text boxes. What command would I use for this?
Also, I have a checkbox that I'd like to use to either enable or disable a textbox as well. Any ideas?
Thanks!
View 12 Replies
View Related
Nov 18, 2004
Hello,
This is my first time posting here and I hope someone can help me. I am not experienced with coding in access and only recently started using forms.
I am trying to create a text box that automaticly fills in once a selection is made in a combo box.
There are only 2 tables and 1 form I am working with. Table 1 has columns "code" and "bu". The second table has several columns, all blank, that the form fills in.
The combo box is working correctly, it displays all the "code"s. Once the code is selected I would like a text box to display the "bu" column.
Any suggestions are much appreciated.
View 4 Replies
View Related
Apr 28, 2005
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 5 Replies
View Related
Sep 29, 2005
Hi, I'm in the process of building a program in access 2003 for estimating roofs, I've ran into a little problem, as described below. any suggestions would be very useful
Populating the text box’s that relate to the chosen combo box’s with the sum of a calculation.
In other words if X combo box is chosen (There are many combo boxes to choose from) populate xx text box with the sum of a calculation.
Refer to the print screen example of my program: http://www.roofmart.net/Rest.asp
Notice under the label felts the 15lb 36” felt combo box is chosen and it displays the value of 11 and next to the combo box is a text box that displays the value of 25 The calculation will be (11*25) = 275 this value of 275 must be added to the text box values that are being shown in the forms header under 30yr where it reads $4,606.80 and 40 yr $6002.80 only, this is because the 30yr comp and the 40 yr comp combo boxes are the only chosen roof types under the label roof types above the felt label.
Hopefully this makes sense.
Thanks -- Any help with be greatly appreciated.
View 3 Replies
View Related
Nov 19, 2013
I have a text box that displays a name of a law from one table, based on that law name I want to populate a combo box with different options on how to comply with that law that come from a different table. The compliance options I need to pull in are different for each law. Finally I would like to have the selected option saved in the table the laws are coming from.
I have tried using a rowsource query [Form]![form1]![Law] for the combo box of law options but keep getting errors.
View 3 Replies
View Related
Nov 28, 2014
Now I have a combo box "cbo_items" and a text box "txt_selectedItems", I want to populate text field with items selected from the combo box, every time i select an item it appears in text box and to be separated with comma, so text box appears like this ( item1, item2, item3), and after finishing the whole thing the result appears in lable "lbl_result" as "total items selected: 3 items".
View 1 Replies
View Related
Aug 14, 2015
The main issue I'm having is trying to populate a text box based on a combo box selection. I've found threads on that - the twist that is throwing me for a loop is that I'm dealing with two different forms.
I have a main/welcome form with two combo boxes on it. Based on the user's selections in these two combo boxes, two different forms are opened for data entry. For instance, box 1 has A, B, C and box 2 has x, y, z. If a user chooses B and z, then form B and form z are opened. What I want is for a text box to be populated on one of the opened forms, not the same (main/welcome) form. In other words, when B and z are chosen, I would like there to be a textbox autofilled with "z" on form z.
View 2 Replies
View Related
Jan 23, 2006
Hi all!
It's been a while since I've used Access, and I seem to have forgotten this.
I have a form which allows entry of Borrower's details. I have 2 combo boxes on the form.
They are:
cboBorrName
cboLoanSN
Once the user selects the name from the cboBorrName, I want the cboLoanSN to display all loans associated with the Borrower so that they can select the correct loan and add repayment details accordingly.
I have added the following SQL statement as the record source of cboLoanSN
Code:SELECT * from tblBorrower WHERE tblBorrower.fldLoanSN=[Forms]![frmBorrower]![cboBorrName]
I have also added the following code in the After Update event of cboBorrName
Code:Me.cboLoanSN.Requery
However, it doesn't work.
Can someone please help me out?
Thanks a bunch!
View 6 Replies
View Related
Aug 5, 2013
On a form, I want to disable the save button, 'cmdSave' whilst the form's mandatory fields have been left blank.
I've put in a smart tag, called, 'Req' against each required field and have used the following code on the forms current event.
Code:
Private Sub Form_Current()
Dim ctl As Control
For Each ctl In Me.Controls
If ctl.ControlType = acTextBox Or ctl.ControlType = acComboBox Or ctl.ControlType = acListBox Then
[Code] ....
The save button is disabled, but it won't enable again after each field has data entered against it.
I also have this code in the AfterUpdate event in each required field:
Code:
Private Sub cboErrorID_AfterUpdate()
Call Form_Current
End Sub
View 13 Replies
View Related
Nov 23, 2005
On my form i have a list which takes information from a table. I have set column headers to "on". What i want to do is populate my combo box with the column heads in my list box. Anyone have any ideas?
Cheers,
Matt
View 1 Replies
View Related
Mar 30, 2006
Hi guys ( and girls)
Ok so Im a noob but I have a problem with populating textboxes
This is basicly the code
' dim some variables
Dim var1(10)
Dim var2(10)
Dim var3(10)
Dim var4(1000)
w = 290
y = 0
For x = 1 To 10
y = y + 1
w = w + 1
var3(x) = y
' set focus and get some data
Set ctl = Combo277
var0 = IIf(Nz(ctl.Value) = "", "", [Combo277])
var1(x) = DLookup(var3(x), "variable type", "[machine] = [machine]")
' compair the data and do some more stuff
If var1(x) = "" Then var2(y) = ""
If var1(x) = "1" Then var2(y) = "Set"
If var1(x) = "2" Then var2(y) = "Act"
If var1(x) = "3" Then var2(y) = "Prod"
' this is where I am having trouble- var 4(w) holds the name of the text box that I wish to use on my form
' and var2(y) holds the data I wish to place in the text box
' so how can I tell the code that the data in var4(w) ,290 for example, is actually a textbox name instead of
' just a numeric variable??
var4(w) = var2(y)
Next x
So any help would be excepted with blind thankx
Tankx in advance Chris
View 1 Replies
View Related
Mar 16, 2005
Dear All:
Code:
Private Sub text458_AferUpdate()
If Graduation_date = 2/1/2005 Then
TEXT_GRADUATION_DATE = "DATED AT THE CITY OF NEW YORK THIS FIRST DAY OF FEBRUARY TWO THOUSAND FIVE."
End Sub
The Graduation_date is a combobox where the dates are selected. In a textbox titled "TEXT_GRADUATION_DATE", it should return "DATED AT THE CITY OF NEW YORK THIS FIRST DAY OF FEBRUARY TWO THOUSAND FIVE."
This text box is blank.
Any ideas on how to fix this?
Many thanks in advance,
Dion
View 5 Replies
View Related
Mar 12, 2008
I am looking to populate fields of one form based on another table with about 100 records.
Information
Table Name: 1) StaticInfo
2) Data
Form Name: EntryForm (Based on the Data table)
I want to be able to select a value in a combo box in the EntryForm and have certain fields populated in that form based on the StaticInfo table.
Want to use all of the fields in StaticInfo to populate the same fields in Data. Historical data in the Data table needs to remain intact, meaning that if something is changed in the StaticInfo table, the historical records will remain unchanged in the Data table.
So, if I am able to select a department in a combo box in the EntryForm and have the fields populated in this form based on the StaticInfo table, will the records in the Data table change or not change if there are changes made to the fields in the StaticInfo table?
Also, could someone provide a method as to how I would go about populating these fields from table to form.
View 1 Replies
View Related
May 8, 2007
Good day,
I have a main form with project data and a sub form that has related financial information. Once the user selects a particular project from the ProjectType drop down box, a field called Project Codes in the subform should be populated with only project codes for that particular Project Type.
Can someone assist?
Thanks
View 5 Replies
View Related
Apr 8, 2005
Nubie question ( first real database)
I'm trying to populate a combo box with the last few entries of a record. I've been looking on SQL Queries and can see a way of using SELECT TOP on the recordset but querying/sorting the whole record every time seems a very clumsey way of doing it (especialy if the recordset gets large).
So is there a more elegant way of getting lastrecord,lastrecord-1,lastrecord-2, etc into my combobox ?.
Note as a suplemental question is there a way of a subform showing records from last to first instead of what seems to be normaly first to last?
Thanks for any help.
View 4 Replies
View Related
Aug 13, 2006
I have a list box and three text boxes on a form. the list box contains data about an individual.
I want to be able to select a certai individual and populate the text boxes with info from the list box
any ideas on how i go about doing this?
View 1 Replies
View Related
Aug 17, 2006
I have text boxes in a form displayed in a continous form with rows and columns. For ex. I populated textbox in column1, then edit some textboxes in column1. Once I go the column2 to populated textbox in column2, textbox1 is default to its orginal data, it doesn't hold the data I made changed to.
View 1 Replies
View Related
Sep 22, 2004
I have a complex problem:
I have a form that displays the result of a query in a listbox (lst_dp_results).
Upon selecting a result in the listbox other data about the selected record is displayed on the same form in listboxes
Code:Private Sub lst_dp_results_AfterUpdate() With Me.lst_dp_productname .RowSource = _ "Select M_Paint.Product_Name FROM M_Paint " & _ "WHERE M_Paint.Catalogue_Code = '" & Me.lst_dp_results & "'"End Sub
As all these fields are listboxes displaying a single value based on the "rowsource" string, they are not editable.
I will like to have these as textboxes instead of list boxes but I guess textboxes do not have anything like 'rowsource'...
Can anyone suggest some method to display value from a field in a textboxt AND be able to edit it??
View 1 Replies
View Related
Mar 23, 2007
I have a text box that I'd like to update from a table like a combo box. I text box is for a order type depending on the order type there can be a sub order type. How I would like to handle this is to have the list box with the primary order types and after the user chooses a primary they can type a semicolon and are given a list of sub order types. Is this possible?
View 1 Replies
View Related
Jul 31, 2014
I am new to access but I am creating a form on access 2010 for a Pass Request. On the form so far I have two cascading combo boxes that work great so far. The problem is that once a name is selected from the second combo box(cboFullNames) I want a textbox underneath to populate(txtOrg). I have tried using requery and refresh but it never works. The only thing that seems to pull up the information is pressing the refresh button.
View 14 Replies
View Related
May 24, 2005
I wasn't sure where I should have posted this question so please feel free to move it if necessary.
I am not even sure this is possible and I didn't know where to begin but these forums have always been extremely helpful.
What I would like to do is export data directly from Access (via form, table or query) and populate it directly to an existing, external webpage.
A little background. My company orders cars an for certain manufacturers, Toyota for example, we order via a secure website. All of the other manufacturers have their order directly transmitted to them. The orders for Toyota take 3-4 times longer to place and I was hoping to speed the process by exporting existing order information directly to the webpage.
Please let me know if it seems like I am smoking something and I will gladly step away from the pipe....=)
Thanks in advance,
Brian
View 4 Replies
View Related
Jun 17, 2005
I have search the forum but dont seem to be able to find the solution i am looking for. I am hoping its because it has a simple solution .......
I have a database which records grant applications for the current year. What i also have is a table which stores all the grant applications from last year and i have a search form which the user can search to see if the applicant applied last year. What i want the user to be able to do is if the applicant did apply last year - to be able to double click on the particular applicant on the search form and populate the fields in the new applicant table, show on the new applicant form, and delete the applicant from last years table. This would save the user time because they would not have to retype name, address etc. Can someone please point me in the right direction? I seem to have a mental blank with this one.
View 5 Replies
View Related
Nov 28, 2005
I deal with freight carriers and each one is assigned a code. There are over 30,000 carriers so I don't want them all in my carriers table.
I have them all in a CarrierCodes table. I would like to open a form that would allow the user to search for the appropriate carrier and when they choose it would populate that data to my Carriers table.
Any help and suggestions will be appreciated.
Thanks.
Gary
View 2 Replies
View Related
Mar 21, 2006
I have a form based on a table named <Staff>. The fields in the form are StaffID, Surname, Name, Grade. What I am trying to achieve is that when a particular StaffID is selected, the other corresponding fields (Surname, Name, Grade) are filled up automatically. Could anyone assist? Thanks.John.
View 8 Replies
View Related
