combobox question

[djcamo66]

Hi, I have a sub form that displays employees working on a particular project.

There is a combo field to show the employee name, however, I only want to be able to select employees whose status is active but still show their name on old project.

As soon as I make someone inactive the name no longer displays in the combo box.

Does any one know a way around this?

Regards
David

 

[Gloops]

I only want to be able to select employees whose status is active but still show their name on old project.

Hello,

Could you please explain what that means ?

 

[John W. Vinson]

Hi, I have a sub form that displays employees working on a particular project.

There is a combo field to show the employee name, however, I only want to be able to select employees whose status is active but still show their name on old project.

As soon as I make someone inactive the name no longer displays in the combo box.

Does any one know a way around this?

Regards
David

There are a couple of ways. One would be to put a textbox on the form,
carefully superimposed over the text area (left of the dropdown arrow) of the
combo box, with a control source using DLookUp to display the name; the combo
itself would be based on a query of just the active employees.

Another would be to change the Rowsource of the combo box to such a query in
the combo's GotFocus event. This would display both current and former
employees ordinarily, but only active employees when the combo has the focus.
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com

 

[djcamo]

There are a couple of ways. One would be to put a textbox on the form,
carefully superimposed over the text area (left of the dropdown arrow) ofthe
combo box, with a control source using DLookUp to display the name; the combo
itself would be based on a query of just the active employees.

Another would be to change the Rowsource of the combo box to such a queryin
the combo's GotFocus event. This would display both current and former
employees ordinarily, but only active employees when the combo has the focus.
--

             John W. Vinson [MVP]
 Microsoft's replacements for these newsgroups:
 http://social.msdn.microsoft.com/Forums/en-US/accessdev/
 http://social.answers.microsoft.com/Forums/en-US/addbuz/
 and see alsohttp://www.utteraccess.com

Thanks John, much appreciated