Run Time Error '2465'

[proballin]

I am getting the error that says "Microsoft Office Access cant find the field 'l' referred to in your expression" It happens at this line of code:

If ([Mk/Frm/Func_Table].Market = Me.Market_Combo2.Column(1)) Then

Mk/Frm/Func_Table is in brackets due to the '/' being part of the table name. Any suggestions?

 

[KeithG]

I would suggest renaming you table.

 

[RuralGuy]

Is the Mk/Frm/Func_Table table the RecordSource of your form or just another table in your db?

 

[proballin]

Keith:
I did rename the table and that didnt help.

Rural:
Mk/Frm/Func_Table is just another table in my db.

 

[proballin]

I apologize Rural...Mk/Frm/Func_Table IS a control source for my form.

 

[RuralGuy]

I apologize Rural...Mk/Frm/Func_Table IS a control source for my form.

Then try:
If [Market] = Me.Market_Combo2.Column(1) Then
...and see what happens.

 

[proballin]

That worked! Thanks Rural...you came through in the clutch, lol.

 

[RuralGuy]

Glad I could help. As you can see, if you are referencing the RecordSource of the form, it is not necessary to specify the table name.