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