combobox question

  • Thread starter Thread starter djcamo66
  • Start date Start date
D

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
 
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
Click to expand...

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
 
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
Click to expand...

Thanks John, much appreciated
 
Back
Top