Code Question

[GR44]

I'm trying to create a report filter via a pop-up box. I went to the MS website and the provided some direction and codes. One particular code creates an error and wanted to see if you all could tell me what to look for to correct it.
The code was:
Private Sub Clear_Click()
Dim intCounter As Integer
For intCounter = 1 To 2
Me("Filter" & intCounter) = ""
Next
End Sub

The error it created stated "You cannot assign a value to this object". Can anyone tell me what to look for?

 

[KenReay]

Hi

The code you posted assumes you have aa form with unbound two textbox controls with nales Filter1, Filter2 and enabled = true Locked = false

Have You? Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[GR44]

I do have two combo boxes named Filter 1 and 2. Both have Enabled = Yes and Locked=No. Is that what you were asking?

 

[KenReay]

HI

Yes

If you have those things, sorry cannot offer any more ideas as to what is wrong Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK