compile error

[dosima]

Hi
I have a compile error on my form and not sure what needs to be changed. the
following code is used to select a court name which then automatically
displays the selected courts address and number. The code for that is in the
form in the text box.

Private Sub cmbCourtName_AfterUpdate()

Me.txtCourtAddress = cmbCourtName.Column()

End Sub

the code for the text box on the form is =[cmbCourtName].[Column](2)

When i compile this code it says compile error 'argument not optional' and
highlights the .Column()

Can someone please help and tell me what i need to do in order to get rid of
the compile error.

 

[Tom Wickerath]

You need to provide a numeric index value in the empty parentheses. In VBA
code, the columns are zero-based, so Column(0) will be the same as the first
column selected in the RowSource, Column(1) will be the second column
selected, etc.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________