Combo Lostfocus

[Torilyn73]

I posted this earlier... or thought I did... anyway.. it's doesn't
appear in the list so I'm reposting it.

Can someone please explain to me how to set up the lostfocus event
for a combo box. I need the combo to return to its default value when
the user clicks away from it ... either somewhere on the form itself
or another app. I have no clue how to do this and would really
appreciate some help.

Thanks!

[Larry Linson]

"Torilyn73" wrote

Can someone please explain to me how
to set up the lostfocus event for a combo
box. I need the combo to return to its
default value when the user clicks away
from it ... either somewhere on the form
itself or another app.

I trust that this Combo Box is unbound. If it is bound to (has a Control
Source of) a Field in the RecordSource of the Form, what you describe will
make it useless.

Please clarify before anyone wastes both their and your time and effort.

Larry Linson
Microsoft Access MVP

[Torilyn73]

yes it is unbound. I can make it bound if need be. Let me explain what
I'm trying to do... I can also email a test copy of my db. I can't see
how to attach it to this message.

My form has one memo field and many combo boxes. I want to remove the
memo field from the form and instead have the selection made in the
combo box appear in a pop box, be automaticallly copied to the
clipboard and then when the user clicks anywhere else (be it in the db
or another application) the pop up closes and the combo box returns to
the default value. Here is the process I want to end up with. I have
the form set up with the memo field and combo boxes and the default
values set up for each combe box.

1. User chooses item in combo box
2. pop up appears with the selected record showing (only one field
from
the record will be there, a memo field)
3. the text in that popup box is automatically copied to the
clipboard.
4. the user then clicks on the application we work in (this causes the
popup to close because the focus moved to another window) and does
ctrl
V (or right click and past) to paste the text into the application we
work in.
5. The next time the user goes to the database to make another
selection, the pop up is gone and the combo box has reset to the
default value it is set for.

I was told to go here: http://allenbrowne.com/func-07b.html

and I'm sure that is excellent info however it is over my head.

I need some help here.
On Jan 28, 4:39 pm, "Larry Linson" <[e-mail]:

"Torilyn73" wrote

Can someone please explain to me how
to set up the lostfocus event for a combo
box. I need the combo to return to its
default value when the user clicks away
from it ... either somewhere on the form
itself or another app.

I trust that this Combo Box is unbound. If it is bound to (has a Control
Source of) a Field in the RecordSource of the Form, what you describe will
make it useless.

Please clarify before anyone wastes both their and your time and effort.

Larry Linson
Microsoft Access MVP

[Torilyn73]

OK,, since no one can answer that question lets back up try another
tactic. Forget the pop up. How about just setting the combo box so
that when the database looses the focus, it returns to it's default
value. Can anyone give me an explanation how to do that. I have tried
using the Microsoft help but its about useless.

Thanks!

On Jan 28, 5:21 pm, "Torilyn73" <[e-mail]:

yes it is unbound. I can make it bound if need be. Let me explain what
I'm trying to do... I can also email a test copy of my db. I can't see
how to attach it to this message.

My form has one memo field and manycomboboxes. I want to remove the
memo field from the form and instead have the selection made in thecombobox appear in a pop box, be automaticallly copied to the
clipboard and then when the user clicks anywhere else (be it in the db
or another application) the pop up closes and thecombobox returns to
the default value. Here is the process I want to end up with. I have
the form set up with the memo field andcomboboxes and the default
values set up for each combe box.

1. User chooses item incombobox
2. pop up appears with the selected record showing (only one field
from
the record will be there, a memo field)
3. the text in that popup box is automatically copied to the
clipboard.
4. the user then clicks on the application we work in (this causes the
popup to close because the focus moved to another window) and does
ctrl
V (or right click and past) to paste the text into the application we
work in.
5. The next time the user goes to the database to make another
selection, the pop up is gone and thecombobox has reset to the
default value it is set for.

I was told to go here: http://allenbrowne.com/func-07b.html

and I'm sure that is excellent info however it is over my head.

I need some help here.

On Jan 28, 4:39 pm, "Larry Linson" <[e-mail]:

"Torilyn73" wrote

Can someone please explain to me how
to set up thelostfocusevent for acombo
box. I need thecomboto return to its
default value when the user clicks away
from it ... either somewhere on the form
itself or another app.

I trust that thisComboBox is unbound. If it is bound to (has a Control
Source of) a Field in the RecordSource of the Form, what you describe will
make it useless.

Please clarify before anyone wastes both their and your time and effort.

Larry Linson
Microsoft Access MVP- Hide quoted text -

- Show quoted text -