Disabling the List Box Until all Records are Dispalyed

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

There are some ADO recordset events you may be able use in your form page.

http://msdn.microsoft.com/library/e...bjodbrecpme.asp