Well, I seem to be having a conversation with myself here. But Chuck (if you're reading this), I just had a thought. If I recall, you said your index on authtype.authtype is a 'regular' index. That means that you can have duplicate values in authtype.authtype after inserting m.at. That being the case, did MS tech support give you any advice about how to tell if setting list1.value to m.at is giving you the correct line?

I'd appreciate it if somebody besides me would jump in here. <s>

Alan

>Sorry, my fingers outran my brain. What I meant to say in the second paragraph is that I don't know what I'm talking about. All it really requires is that you know the field value of the field that the list box is using for it's own value. Looks perfectly ok.
>
>>Ok, yes, please send them along to me. I'm curious to see what value the Seek line provides considering that it should put you on the same record you are already on after doing the insert.
>>
>>The only reservation I have about this (and it isn't much) is that it requires that the index tag used in the table matches the value field listed in the listbox. Normally that makes sense, but I wonder if there are times when the list1.value might not be the field used by the table's index tag.
>>
>>In your case of course, it's not an issue, so this looks like the best (and fastest) possible way to handle it. Glad you found it.
>>
>>Alan
>>
>>>(snipped a mass of wasted codes)
>>>INSERT INTO AuthType (AuthType) VALUES (m.at)
>>>ThisForm.List1.Requery()
>>>SEEK(m.at)
>>>ThisForm.List1.Value = m.at
>>>ThisForm.List1.SetFocus()
>>>ThisForm.Refresh
>>>
>>>I finally called MS Tech Support (g). This is what they solved for me. Now, it is working great. I have a listbox sample he send to me (two files of one form in one zip, 2K, thats all). He made it so easy, man! :-) If you like this sample, I am willing to attach to email for you, only if you ask for it (yeah, I think it's without a virus (g)).
>>>
>>>Chuck