Visual Basic Query

[terry]

I have written a small update query which will not work. I have one of the fields named CODE. Is CODE acceptable for a field name?

Terry

 

[SOS]

According to the list of reserved words, Code is not one, so it should be fine.

What is your SQL of your query?

 

[terry]

Here is the code, basically updated a field.

Private Sub Code_AfterUpdate()
Me.AccountName = Me.Code.Column (1)
End Sub

 

[SOS]

That isn't an update query.

But besides that - what actually happens when you select from the Code combo?

 

[terry]

Fixed it!
Don't know how, but it is working.

Terry