473,320 Members | 1,910 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

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

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
2 2519
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Tina McGibben | last post by:
I basically have a form with a subform with two combo boxes on the main form which filter the subform. The code below works except I cant seem to get it to show all the worksheets when there is...
0
by: zlib101892NoSpam | last post by:
Error: failure of the list portion of a combo box to remain visible The error appears to be due to code in a conditional statement that set the ControlTipText property of the combo box to...
1
by: Salad | last post by:
On you form you have a combo box of a list of employees. In the Employee table you have the employee name, employee id, and an ActiveInactive status. Initially, the list contains the names of...
7
by: badboybrown | last post by:
I know that this is an age old question and it has been approached a few times, but I've hit a wall and require some help. I have various combo boxes that contain values that are both "current"...
8
by: salad | last post by:
I was wondering how you handle active/inactive elements in a combo box. Let's say you have a combo box to select an employee. Joe Blow has been selected for many record however Joe has left the...
4
by: virtualgreek | last post by:
Dear All, First of all I would like to take the time to thank you all for your efforts and time spent at this wonderful forum. I have found it very helpful with numerous examples available for...
1
by: lawton | last post by:
Source: this is an access 2003 question My knowledge level: reading books, internet, and trial & error; no formal training I'm trying to get a running sum of what's filtered in a subform which is...
14
kcdoell
by: kcdoell | last post by:
Hello: I have a form (Default view =single form) with a subform (Default view =continuous forms) embedded into it. In the form I have three controls that display the Division, Working Region &...
18
by: Richard Penfold | last post by:
I have a form with a subform in my database that I use to manage deliveries. A combo box on the subform displays items of inventory and thier current status. The code behind the combo box is......
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.