UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Closed TopicStart new topic
> Available Options In Dropdown To Disappear As They Are Assigned?, Access 2010    
 
   
MrWrap2
post Jan 11 2017, 03:18 PM
Post#1



Posts: 78
Joined: 10-January 17



I'd like to create a dropdown control on a form that you can choose a job, but once that job is assigned, it is not listed as an available option for the next record.

in example; available jobs are Quality Assurance, Team Lead, Team Member. Bob is the Quality Assurance, and when Steve goes to select his job, only Team Lead and Team Member are available.

Is this possible?

-TIA, Mike
Go to the top of the page
 
doctor9
post Jan 11 2017, 04:22 PM
Post#2


UtterAccess Editor
Posts: 17,756
Joined: 29-March 05
From: Wisconsin


Mike,

Did my suggestion from this earlier discussion not work for some reason?

Dennis

--------------------
(;,;) Li'l Cthulu says: Please talk about what you're trying to do, as well as how you're doing it.
Changing your real table name to "Table1" and your real form name to "Form1" in your posts makes it more difficult to understand what's going on, not easier.
Guidelines for Posting Questions
Go to the top of the page
 
MrWrap2
post Jan 11 2017, 04:35 PM
Post#3



Posts: 78
Joined: 10-January 17



Dennis,

your suggestion seems logical, I'm just unsure how to accomplish it.
Go to the top of the page
 
GroverParkGeorge
post Jan 11 2017, 06:27 PM
Post#4


UA Admin
Posts: 30,750
Joined: 20-June 02
From: Newcastle, WA


Rather than start a new, unrelated thread, why not follow up in that thread then?

I'm going to close this discussion and ask you to please carry on with that on-going discussion.

--------------------
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    22nd October 2017 - 08:34 AM