Hi All,
I have a form that contains a listbox which is used to select a product and the form navigates to the selected record.
I also put 2 radio buttons on the form called Active and disactive. These buttons toggle what the listbox contains:
here is the code for one of the buttons:
Private Sub ActiveProducts_AfterUpdate()
Me.InactiveProducts = False
List324.RowSource = "qryStdCostListBoxActive"
Me.Requery
End Sub
When selected it changes the row source for the listbox to contain only active products.
Its very straightforward.
My problem is that the form doesnt navigate to any record of the active set. My listbox changes to active products and works when i select a record, however I
would like the form to go to say the first record of the active set. I thought the requery in my code would do it but im wrong!
What do i need to add to the code to get the form to go to the first record of the set?
Thanks for any advice,
BJF
I have a form that contains a listbox which is used to select a product and the form navigates to the selected record.
I also put 2 radio buttons on the form called Active and disactive. These buttons toggle what the listbox contains:
here is the code for one of the buttons:
Private Sub ActiveProducts_AfterUpdate()
Me.InactiveProducts = False
List324.RowSource = "qryStdCostListBoxActive"
Me.Requery
End Sub
When selected it changes the row source for the listbox to contain only active products.
Its very straightforward.
My problem is that the form doesnt navigate to any record of the active set. My listbox changes to active products and works when i select a record, however I
would like the form to go to say the first record of the active set. I thought the requery in my code would do it but im wrong!
What do i need to add to the code to get the form to go to the first record of the set?
Thanks for any advice,
BJF