Update a Text Box from Combo Box

[NickFazer]

Hi Everyone


I am having difficulty getting a text box to update from a combo box selection on a form. The cbo is called Stage1 and the text box is called S1LengthDays, both are fields in the same table. I am getting an error message in the code window. "Compile error. Method or data method not found"


Private Sub Stage1_AfterUpdate()
Dim S1LengthDays As Integer

Me.txtS1LengthDays = Me.cboStage1.Column(2)
End Sub



Thanks


Nick Fazer

 

[RuralGuy]

When you type the period "." after Me, intellisense will show you all of the possible valid entries.

 

[Alansidman]

Look here.

http://baldyweb.com/Autofill.htm

Alan