ref post 8/27/07 remove from dropdown when selected in

[babs]

I have a LIst of employess - in a query it is really One query Jeff employee
Info that the combo box for a form is based on - not sure how to set up the
select statement below - the subfomr the dropdown is on it Named cbomanname
on the subform JeffSchedLookAheadGenerate I created additional queries with
employee list [Jeff Employee Combo Box Time Card-Deleting for Dropdown] - not
really any different from Jeff employee info.

syntax I have - getting error -not what I am doing
I basically want to get rid of the name from the combo box when an employee
I scheduled for a given day has been sched.- at the end of that schedule day
I would like to refresh the list for the next day sched put them back - as
sched. each OnE want them gone from the dropdown for that day. I also added
a field to the subform - available(y/n)

not clear how to go about this

MY code
SELECT [Jeff Employee Info].[man name] FROM [Jeff Employee Info] WHERE [man
name] NOT IN (SELECT [man name] FROM [Jeff Employee Combo Box Time
Card-Deleting for Dropdown] WHERE [Jeff Employee Combo Box Time Card-Deleting
for Dropdown].[man name] = Forms! JeffSchedLookAheadGenerate!cbomanname);


post by John Vinson on 8/27/07
remove from dropdown when selected in
seems to be along same lines think my IssueDescID is Man name

SELECT t013IssueDesc.IssueDescID, t013IssueDesc.IssueDesc FROM t013IssueDesc
WHERE IssueDeskID NOT IN
(SELECT IssueDescID FROM tIssue WHERE tIssue.RiskID = Forms!fRisk!RiskID);

and I KNOW Man Name is a horrible ID but the company doesn't have that many
employees and WILL NOT DUPLICATE MAN NAME
- its been here an don't want to change PK

any ideas on how I can do this?? get rid of man name from combobox when
selected??

thanks soo much
Barb