do i need a custom record selector 1

[LikeThisName]

here is my problem

i have two listboxes who's record sources are based on a record id.

but it doesn't requery when record id is moved to the next with record selector now if i requery on gotfocus it works fine but users see's inaccurate options until they click on listbox, that aint right.

i tried afterupdate and change events with record id but when changed via record selector those events aren't triggered.

in much need of enlightenment,

TIA,


LikeThisName <- ? Sorry It's Taken =)

 

[ByteMyzer]

Try pasting the following code in your form's Code Module:

[COLOR=blue]Private Sub[/color] Form_Current()
    Me.ListBox1.Requery
    Me.ListBox2.Requery
    [COLOR=green]' Change [b]ListBox1[/b] and [b]ListBox2[/b] to the actual names of the listboxes[/color]
[COLOR=blue]End Sub[/color]

See if this works for you.

 

[LikeThisName]

thanks
i had tried...

Private Sub Form_Current()
'If Me.ProposalID.Value <> Me.ProposalID.OldValue Then
Me.AttorneyPool.Requery
Me.List2.Requery
'End If
End Sub

but commenting out the unnecessary if statement works great!

AGAIN THANKS!


LikeThisName <- ? Sorry It's Taken =)