[AccessD] Clear the display in a combo box

Bobby,

This ListIndex property is pretty interesting.  I had never looked at it 
before.  As of now, I'm not doing it right - and since setting the combo 
box to Null works well, I have a solution for now.  However, I am 
interested in knowing some more about using this property.  I tried it 
according to what I understood the syntax to be, by Dimming the form 
name and the control name as strings (stFormName and stComboName) and 
defining them:

Dim stFormName As String
Dim stComboName As String

stFormName = ""frmMemberLookup"
stComboName = "cboMemberLookup"

Forms(stFormName).Controls(stComboName).ListIndex = -1

I got the error message that I wasn't using it the right way, and 
decided this was something I would learn later.  I can see lots of uses 
for this ListIndex property if I can learn to use it correctly.  Would 
you tell me more about how you use it?  Thanks,

Tina

Bobby Heid wrote:
> Tina,
>
> Either before you go to the second form or when you get beck, try setting
> the ListIndex property to -1.
>
> Bobby
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Tina Norris
> Fields
> Sent: Monday, September 01, 2008 12:20 PM
> To: AccessD at databaseadvisors.com
> Subject: [AccessD] Clear the display in a combo box
>
> Hi,
>
> I know this should be easy, but I'm not getting it.  I have a combo box, 
> I make a selection from the list, I click a button that opens another 
> form based on my selection in the combo box.  So far, so good.  I close 
> the second form and return to the form with the combo box on it.  I want 
> the box to be empty of the choice last made.  That is, I want the form 
> with the combo box to appear the way it does before it gets used.  I 
> don't want the previous selection to appear in the textbox portion of 
> the combo box.  What action or method do I want?  And should it be 
> called in the On Activate event?
>
> Thanks,
> Tina
>
>
>