[AccessD] One report using alternate sources

John,

That's par for the course in our line of work.  If you don't use it, you
lose it.

Glad I could help.

Bobby

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Clark
Sent: Tuesday, April 12, 2005 7:52 AM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] One report using alternate sources


Thanks Bobby.

I'm a dolt...I always forget about the "me" when I am in a form. I don't get
to program in Access for months sometimes, and then I get back into it and I
keep forgetting the same stuff. The thing I love about my job is the same
thing I hate about my job...variety. I'll do Access for a bit, then I'll do
some IP telephony for a while, and then we mix in some net admin duties and
some other assorted tidbits, and VOILA! you've got confusion ;)

But, it doesn't get boring ;)

Thanks again!

John W Clark

>>> bheid at appdevgrp.com 4/11/2005 3:21 PM >>>

I use something like (warning - air code):

Dim strSQL as string

	strSQL="SELECT * FROM SomeTable;"

	me.recordsource=strsql


Bobby