Bill-
Consider adding an "Obsolete" Yes/No flag to the Area of Service lookup table.
If there's a code they don't want to use anymore, have them mark it "Obsolete"
but not delete the row. In your Row Source for your combo box for a new record,
add WHERE Obsolete = False.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of agent1of6
Sent: Friday, August 17, 2012 4:44 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Combo Box
I have a database that is used by a non profit agency to track the assistance
given to people in need.
On the "Needs request form" we track the area of need by selecting from a drop
down box. Areas of service include 1. Auto Repair 2. Moving 3. Shopping.....
etc.
This non profit is going to be making som adjustmets in their areas of service.
They are going to be dropping #3 shopping assistance and adding a Mobile Cloths
Closet. I have no problem adding in the new areas of service but is there any
way to keep the old areas of service showing up on the drop down list with out
affecting the old service projects done.
For example, if someone needed shopping in the past and we pulled up that
information we would still like to see the "shopping" catagory in the drop down
box but we do not want to see shopping for the new projects.
I do not know if this is even possible so I thought I would ask.
thanks for your help.
Bill
Minnesota
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar