issue with non active fields

[djcamo]

Hi, i am having an issue with a field within a table that is not
active.

I have a table of employees and if they leave they become non active
(yes/no field).

We do this so that on other forms when we select employees from a
combo box they do not appear.

The issue is that for existing records where this person was involved
the name combo field shows blank as they are now deemed non active
(seen here - http://wishlistsolutions.com.au/files/demo.png)

The combo box's SQL is only showing employees who are active hence any
non active one do not display.

I cannot think of a way around this and would appreciate any help.

Cheers

 

[Arvin Meyer]

Hi, i am having an issue with a field within a table that is not
active.

I have a table of employees and if they leave they become non active
(yes/no field).

We do this so that on other forms when we select employees from a
combo box they do not appear.

The issue is that for existing records where this person was involved
the name combo field shows blank as they are now deemed non active
(seen here - http://wishlistsolutions.com.au/files/demo.png)

The combo box's SQL is only showing employees who are active hence any
non active one do not display.

I cannot think of a way around this and would appreciate any help.

If the must show up in the combo box, you must change the SQL which is the
row source, and eliminate the Where clause which states:

Active = False (or Active = 0)

--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://access.mvps.org
Co-author: "Access Solutions", published by Wiley