Disabling the List Box Until all Records are Dispalyed

[patiya]

I am using MS Access ADP front end and SQL in Back end. I have a form that is bounded to a Table with 20,000 records. That form has a list box in form Header Section where users select the record and it displays in Detail Section. The forms Navigation Button Property is set to "Yes".

My question is how do I disable the list box or all other controls (combo box, check box, command buttons) until all records are counted in the Form Navigation Status. For example in Access 2000 version all records are displayed in the Navigation Status box after the form is open but in ADP version records are counted from 1 to EOF.

I know it just take 4-5 seconds to display all records but we have some picky users why stared clicking immediately the form is open. Thanks a lot for any suggestion. Appreciate

 

[cmmrfrds]

Maybe you could use the State property of the recordset.

For example.
In OnOpen.
me.field1.enable = false
me.field2.enable = false
etc....

Call ASubCheck

Sub ASubCheck
While Me.Recordset.State = adStateFetching
do something like put on the hourglass
Wend
me.field1.enable = true
me.field2.enable = true
etc....
End Sub

This is just a thought I haven't tried it.