[thelist] VB syntax help
dn at dittodesign.co.uk
dn at dittodesign.co.uk
Tue Jul 30 07:12:01 CDT 2002
Can anybody please help me with this bit of VB.
Its not my bag and I need to get it sorted out today.
Trawling the web and searching Access help is getting
me nowhere.
Private Sub Calculate_Phones_Click()
Me.Filter = " PostcodeMain = '" & PostcodeMain & "' AND NumberOfPhones >= "
&
FirstNumber & " AND NumberOfPhones <= " & SecondNumber
Me.FilterOn = True
End Sub
I'm struggling to get a basic filter to work.
I want a user to enter two figures and the filter to return records
between and including these figures when the button on a form is pressed..
This is the breakdown -
tbldata(all) - table
PostcodeMain - field
NumberOfPhones - field
FirstNumber - text box
SecondNumber - textbox
Calculate_Phones - button
any help much appreciated.
Darren Yates
dn at dittodesign.co.uk
http://dittodesign.co.uk
0161 281 1190
More information about the thelist
mailing list