Lookup Combo Box

[Guest]

I have incorporated a Combo Lookup Box on a Form to Lookup a specific
Reference Number. It works fine, but is there any way that when the Record
appears the Reference Number that was looked can be automatically removed
from the Lookup Field?
Thanks for any help

 

[Guest]

Hi Roger,

I suspect you mean that you are clicking on an item in a combo box, then the
record is being displayed...

Easy to clear the item... at the end of your On Click event (or whatever
event you are using to display the record), include the code
me.cboDisplayItem = Null (where cboDisplayItem is the name of your combo box
you are selecting the record from.

Of course, this assumes that your combo box isn't bound to a field in your
table - otherwise you would be deleting your data!!

Hope this helps, and if it's not quite what you were after, feel free to
clarify with another post.

Damian.

 

[Guest]

Thanks very much Damian. It works a treat thanks to your expertise
Much appreciated.