Recordset filter and ADP file

ASP Free Forums Sponsor:

April 14th, 2006, 11:40 AM

Contributing User

Join Date: Jul 2004

Posts: 258

Time spent in forums: 1 Day 4 m 16 sec
Reputation Power: 5

Recordset filter and ADP file

Could someone tell me what is wrong about the following? I'm getting an invalide use of property. Can you not filter using a variable?

Code:

rst1.Filter ("Claim_ID = " & intClaimID)

BTW - I have an adp file - this is an ADODB recordset, if that matters.

April 14th, 2006, 08:52 PM

Doug G

Grumpier Old Moderator

Join Date: Sep 2003

Posts: 10,143

Time spent in forums: 3 Weeks 4 Days 23 h 19 m 36 sec
Reputation Power: 181

Try

Code:

rst1.Filter = "Claim_ID = " & intClaimID

__________________
======
Doug G
======
I didn't attend the funeral, but I sent a nice letter saying I approved of it. --Mark Twain

Viewing: ASP Free Forums > Programming > Visual Basic Programming > Recordset filter and ADP file

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

Forum Jump