refresh combo boxes with a random record

[Guest]

I have two unbound combo boxes that are based on the 'look up a record' combo
wizard.

When the form opens they both query the same underlying table and offer up
two criteria for the underlying form query to display a set of records on
some Subforms on the page.

RunFromCombo
RunToCombo

All works fine.

I want a button that will requery the two combo boxes to offer up some new
records on a random basis (it's for a quiz).

at the moment my button Event has the following code:


Private Sub Command58_Click()
Me.RunFromCombo.Requery
Me.RunToCombo.Requery
End Sub

but when I hit the button, nothing happens.

What am I doing wrong?

 

[Guest]

Does anyone have an idea how I can make this work?

I have two unbound combo boxes that are based on the 'look up a record' combo
wizard.

When the form opens they both query the same underlying table and offer up
two criteria for the underlying form query to display a set of 'From' - 'To' records on a Subform

The Controls are