refresh combo boxes with a random record

E

efandango

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?
 
E

efandango

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

efandango said:
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
Click to expand...
The Controls are
 
Top