[AccessD] New vs. Obsolete Products list

Dan Waters df.waters at comcast.net
Sun Jan 15 10:26:01 CST 2012


Hi Arthur,

Based on my experience with my users, I would take a slightly different
path.  I know that what you're setting up, while elegant, would cause
questions about how it works too frequently. 

I would do something on-screen to clearly indicate what the list is showing.
This could be two lists; Existing Orders, and Create New Order.  Or it could
be one list with a couple of buttons with similar labels to select what's
going to be showing in the list.

My users want me to make their screens simple and mistake proof. 

HTH,
Dan 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Saturday, January 14, 2012 8:35 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] New vs. Obsolete Products list

A client wants to consolidate her list of products, reducing a rather
ungainly list of slightly different variants to a much smaller selection.
This occurs in the Transactions table, and the ProductID is presented there
as a combobox. I added a field to the Products table, called Obsolete.
There is no intention to backfill/correct the existing rows in Transactions,
but rather to restrict new Transactions to the Products that are not
obsolete. I have created two queries to present these two lists.
While the user is browsing existing records, I want the complete list, but
when inserting a new row, I want to change the RowSource to the query that
hides all the Obsolete products and presents only the revised list.

My question is this: on what event should I swap the RowSource? I'm not
quite sure how to approach this. Once I decide on which event to use, the
rest is simple, but which event is the right one? The code should kick in
and swap the RowSource only on entering a new record.

TIA,
Arthur

--
Cell: 647.710.1314

Prediction is difficult, especially of the future.
  -- Neils Bohr
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list