combo box value

[Guest]

Hi,

I have a combo box used for searching. After a selection is made from the
drop down the relevant record displays on the form. There is navigation
buttons on the form and if the user users these to then navigate to other
records the original selection in the 'search' combo box still remains. This
can confuse the user who may have reocrd "B" displaying on the form but the
combo is displaying record "A". How can I make the combo go blank after it
has lost focus.

Cheers,

nB

 

[fredg]

Hi,

I have a combo box used for searching. After a selection is made from the
drop down the relevant record displays on the form. There is navigation
buttons on the form and if the user users these to then navigate to other
records the original selection in the 'search' combo box still remains. This
can confuse the user who may have reocrd "B" displaying on the form but the
combo is displaying record "A". How can I make the combo go blank after it
has lost focus.

Cheers,

nB

If you used the combo wizard to create the combo box add,
as the last line of code in the Combo AfterUpdate event:

Me![ComboName] = Null

 

[eos]

AUTO-REPLY From George Levitt

Please allow this to confirm a system receipt of your e-mail.

I am out of the office until Wednesday morning (1/12/05) and will not be
reviewing or responding to email or voicemail until that time.

I look forward to replying to your message on Wednesday.

Thanks and warmest regards, George

 

[eos]

AUTO-REPLY From George Levitt

Please allow this to confirm a system receipt of your e-mail.

I am out of the office until Wednesday morning (1/12/05) and will not be
reviewing or responding to email or voicemail until that time.

I look forward to replying to your message on Wednesday.

Thanks and warmest regards, George