Subform listbox problem 1

[ajking]

I have an subform on my main form. This sub form has 4 listboxes which are used to populate textboxes on the main form. This works fine but when I go to a new record and then enter the sub form, the listboxes have retained the selections from the previous record.
It's probably very simple but I am having a "friday brain dump"! TIA

'Life is what happens to you while you are busy making other plans' John W. Lennon 1940-1980

 

[missinglinq]

That's the normal behavior for unbound listboxes, actually for any unbound control.

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[missinglinq]

Sorry, Premature Submission! I assume you assign the value from the listbox to your textbox in the AfterUpdate of the listbox. This'll "reset" the listbox to it's original state.

Private Sub YourListBox_AfterUpdate()
 Me.YourTextBox = YourListBox
 YourListBox = ""
End Sub

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[ajking]

Many thanks for your swift reply. I said it would be simple and that I was suffering a "friday brain dump"
cheers

'Life is what happens to you while you are busy making other plans' John W. Lennon 1940-1980