[AccessD] Unbound Subform Revisited

Keith:

Put a debug statement to print the SQL string right before the
me.recordsource = and post it.  Someone will see that there's probably a
syntax/punctuation error.

Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Keith Williamson
Sent: Wednesday, December 20, 2006 7:05 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Unbound Subform Revisited

Hey Guys,

 

If I want to change a bound form to an unbound form, am I going about it
correctly if I do the following:

 

1)       Add (3) unbound text fields for variables in form header;

2)       Delete Record Source for form;

3)       Add button to form header;

4)       Add Event to button, to set form.recordsource = (original sql
statement for record source, deleted in step 2, but also add where
statements for the (3) variables in the unbound text fields)

 

Shouldn't this run?  I keep getting a syntax error on my sql statement,
when I click the button.  Even if I change the sql statement to exactly
equal the original recordsource statement....I get the syntax error.

 

??

 

Thanks,

 

Keith E. Williamson | Assist. Controller| kwilliamson at rtkl.com

RTKL Associates Inc. | 901 South Bond Street | Baltimore, Maryland
21231-3305

410-537-6098 direct | 410-276-2136 fax | www.rtkl.com
<http://www.rtkl.com/> 

 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.432 / Virus Database: 268.15.25/593 - Release Date: 12/19/2006
1:17 PM