Combo box ListIndex to -1

[Diana]

I have a combo box to select the company name and a search button. After the search is done I want to refresh the combo box to set the ListIndex property to -1. Any suggestion? Thanks.

 

[AHMED KHALAF]

I have the same problem
and i can not set the controlname to be null value BECAUSE IT IS PRIMARY KYE AND THIS IS MY LIKE TO THE PROBLEM

http://www.access-programmers.co.uk/forums/showthread.php?t=170879&page=2

so i need the listindex to -1 but i do not the way
any help i'll appreciate

 

[AHMED KHALAF]

Isn't there any code instead of the listindex -1 to do that ?

 

[AHMED KHALAF]

Hey guys
isn't there any solution for this problem ?

 

[gemma-the-husky]

is the combo box bound?

if so, then changing its value will affect the current record, so its unwise to do
if not, then it will have no effect anyway

but simply

mycombobox = 0

should do what you want

 

[AHMED KHALAF]

Thanks for your reply
but the combo box is a bound to field in table and can not have null value because it is primary key

 

[gemma-the-husky]

but if its bound, then changing it to -1 (or anything else) will set that as the value in the underlying record

why would you want to do that?

 

[AHMED KHALAF]

THIS PHOTO EXPLAIN WHAT I NEED







AND I ATTACHED MY FORM TO MAKE THE MODIFICATION
THANK YOU FOR YOUR PATIENCE

 

[AHMED KHALAF]

Is there any one have solution for this problem