By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,946 Members | 720 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,946 IT Pros & Developers. It's quick & easy.

Bound Combo Box on Subform displaying records with active status in list.

P: n/a
I have a subform that display requisition information. One of the
fields in the subform is a combo box that shows who requested the
requisition. The users can change who requested the requisition and I
would like to only have them be able to choose active employees. So,
I have written the query for the rowsource for this combo box, which
is based on an employees table, to look at all active employees and
the employee that is currently chosen in case that employee is
inactive. The query looks like this:

SELECT tblEmployee.EmpoyeeID, [LNAME] & IIf(IsNull([LNAME]),"",", ") &
[FNAME] AS FULLNAME
FROM tblEmployee
WHERE (((tblEmployee.STATUS)="A")) OR
(((tblEmployee.EmpoyeeID)=[FORMS]![frmrequisition]![FRMREQSUBFORM]![cboRequestedby]))
ORDER BY tblEmployee.LNAME, tblEmployee.FNAME;

Properties of the combo box:
Limit to list = Yes
Number of columns = 2
bound column = 1
column widths = 0;1

The problem comes when the subform shows several requisitions and some
of the employees who requested the requisitions are inactive. What
happens is if I am on the current record where the employee that
requested it is inactive the employee is displayed but on another
record that has a different employee that is inactive shows up blank
because it is not in the drop down list. It is fine if the list of
requisitions being displayed all has the same person that requested it
but is confusing to the users when they don't see a name in the
requested by field but then go and click on it and the name appears.

Is there any way to get around this?

Kelly
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Kelly, just a suggestion, why not create a checkbox and use it to inactive
employees or terminated etc and base your query on True or False boolean?
Nov 13 '05 #2

P: n/a
lu*************@aol.com (Lumpierbritches) wrote in message news:<20***************************@mb-m24.aol.com>...
Kelly, just a suggestion, why not create a checkbox and use it to inactive
employees or terminated etc and base your query on True or False boolean?


Probably should have used True/False to indicate active and inactive
employees. The problem that I have would still exist though unless
you are indicating that I should display the active/inactive status in
the drop down list along with the name and remove the criteria in the
query that shows only active employees so all employees are listed and
the responsibility to choose the active employee falls on the user.
That could be a work around but am hoping for something else.

Thanks,
Kelly
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.