If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Autofill text box
I am looking to create a textbox that is automatically
filled in everytime a value is changed on a combo box on the same form. Any ideas? |
#2
|
|||
|
|||
Autofill text box
What do you want to fill it with?
"Niall" wrote in message ... I am looking to create a textbox that is automatically filled in everytime a value is changed on a combo box on the same form. Any ideas? |
#3
|
|||
|
|||
Autofill text box
It depends what you want to fill in and if you want the
item stored to a table field. Except for time-sensitive information, such as the current price of a product, you generally want to avoid redundantly storing data or calculations that you can retrieve or calculate faster in a query without wasting disk space and risking subsequent changes that compromise your data. If you just wish to display additional fields from the combo box Row Source, you can either: - base your form on a query. When the key field is selected in the combo box, other fields will display. or - include all fields you wish to display in the Row Source, setting their width to 0" if you don't want them to display in the combo box itself. Then set the Control Source using the combo box' Column property: = YourComboBox.Column(ColumnNumber) ColumnNumber is numbered 0,1,2, etc. HTH Kevin Sprinkel -----Original Message----- I am looking to create a textbox that is automatically filled in everytime a value is changed on a combo box on the same form. Any ideas? . |
#4
|
|||
|
|||
Autofill text box
I have a table called references which has a referenceCode
and referenceDescription. On the form the combo box has the referenceCode. When I select a particular referenceCode form the list I want the referencDescription text box to automatically fill in, and change whenever I change the referenceCode. -----Original Message----- What do you want to fill it with? "Niall" wrote in message ... I am looking to create a textbox that is automatically filled in everytime a value is changed on a combo box on the same form. Any ideas? . |
#5
|
|||
|
|||
Autofill text box
You would need code similar to the following in the the AfterUpdate event of
the combobox... Private Sub SomeComboBox_AfterUpdate() On Error Resume Next With Me!SomeComboBox If Not IsNull(.Value) Then Me.Recordset.FindFirst "ReferenceCode=" & .Value End If End With End Sub wrote in message ... I have a table called references which has a referenceCode and referenceDescription. On the form the combo box has the referenceCode. When I select a particular referenceCode form the list I want the referencDescription text box to automatically fill in, and change whenever I change the referenceCode. -----Original Message----- What do you want to fill it with? "Niall" wrote in message ... I am looking to create a textbox that is automatically filled in everytime a value is changed on a combo box on the same form. Any ideas? . |
#6
|
|||
|
|||
Autofill text box
I want to do the same thing but insert in text box the
current date when a selection of "signed" is choosen in a list Box... Any ideas -----Original Message----- It depends what you want to fill in and if you want the item stored to a table field. Except for time-sensitive information, such as the current price of a product, you generally want to avoid redundantly storing data or calculations that you can retrieve or calculate faster in a query without wasting disk space and risking subsequent changes that compromise your data. If you just wish to display additional fields from the combo box Row Source, you can either: - base your form on a query. When the key field is selected in the combo box, other fields will display. or - include all fields you wish to display in the Row Source, setting their width to 0" if you don't want them to display in the combo box itself. Then set the Control Source using the combo box' Column property: = YourComboBox.Column(ColumnNumber) ColumnNumber is numbered 0,1,2, etc. HTH Kevin Sprinkel -----Original Message----- I am looking to create a textbox that is automatically filled in everytime a value is changed on a combo box on the same form. Any ideas? . . |
#7
|
|||
|
|||
Autofill text box
In the AfterUpdate event of "Signed",
Me!YourDateTextBoxName = Date() HTH Kevin Sprinkel -----Original Message----- I want to do the same thing but insert in text box the current date when a selection of "signed" is choosen in a list Box... Any ideas |
Thread Tools | |
Display Modes | |
|
|