Private Sub Form_Current() says syntax error?

thunderstorm

Registered User.
Local time
Today, 05:22
Joined
Jan 16, 2004
Messages
18
this part of one of my codes

Code:
Private Sub Form_Current()
doesnt work, it says that there is a syntax error in it, what is wrong?!
 
in properties of the combobox i have in the after update row it linked to a macro. the macro has the actions gotocontrol and then findrecord. the findrecord, under find what is =[FindIt]. FindIt is the name of my combo box.
what im trying to do, is that if the user navigates the records by another method than the combo box, the company name listed in the combo box will change with it (continue to be syncronised). the combobox is in the form header...
so i chose form properties (of the form, not the header or the detail bit), and then under the row on current click ... to go to code builder. i then added

Code:
 FindIt = CompanyName
to the code already there, and the complete code for this bit was just
Code:
Private Sub Form_Current()
    FindIt = CompanyName
End Sub
 

Users who are viewing this thread

Back
Top Bottom