G
Ghulam
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
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