combobox question

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
 
G

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 ?
 
J

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
 
D

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top