[AccessD] combo box 101

Well, you've forced my hand. Here is where I am parked.

When my rowsource is populating a listbox (or several on a form) - and when
I give people options for what will drive the sql ... such as sometimes the
entity might come from table X, sometimes table Y ... or sometimes the field
I want out in front is Global_Customer_Name and other times it is
Regional_Customer_Name ... which are different fields in the underlying
query ... I definitely want to control the SQL through VBA.

If I have a subform which is riding a query that is riding ... down the
line, a cross tab ... so that I need to turn off the recordsource for the
subform, check the result of the crosstab through a recordset which copies
its SQL -- then modify the downstream queries ... then turn back on the
sourceobject for the subform ... I prefer to see the required modifications
in VBA.

I think those who are comfortable with a lot of queries in their database --
which there is no easy way to tell where that query is being used, either in
rowsources or in dependent queries ... probably work in very stable object
environments.

I seldom do.

And that's my style, right or wrong. I consider myself very versatile and
increasingly skilled, but granted, I always feel like I am juggling a few
balls which could have mo' better' ve been left on the ground.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark Simms
Sent: Tuesday, August 09, 2011 3:37 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] combo box 101

I'm definitely not with you on that.
I don't know what's worse: Scattered SQL Strings Or Database Connection
Strings.

> I think it is a matter of taste.  I prefer SQL to Querydefs as the
> source of table based
> comboboxes - I find it easier to maintain.
>
> --
> Stuart


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