I am using Access 2000. I have 1 main form which is displayed all the time. I have a Command button on this form which opens a smaller form for data entry. How do I keep this data entry form on the top or active until all data is entered and the form automatically closes. As it is now, if the user clicks anywhere outside the smaller form the main form now has focus and the smaller data entry form is now hidden in the background. Can I capture the cursor with the smaller form until all data is entered ? Or perhaps there is another way ?
Thank you for looking and any suggestions.
Thank you for looking and any suggestions.