Chuck,
Sure, send me the zip and I'll take a look.
>I did ThisForm.List1.Requery() but didn't quite do it. If I watch closely, I could see a flash of some data in the listbox, but that's it. Would you mind if I zip this up and you look at it (just this one area in the ClickEvent() and also maybe one more button to complete this form)? I tried quite different things around it and not seem to work well yet. I have all the texts/fields done, now need to fix the ClickEvents. Let me know and thank you.
>
>Chuck
>
>>You probably just need to requery the listbox after creating the array.
>>
>>>As I did used the code provided (thanks!), how do I activate the results into the listbox? the RowSourceType is 5- Array and the RowSource is laSQL. What's wrong here?
>>>
>>>Chuck
Brien R. Givens
Brampwood Systems