coasterman
Registered User.
- Local time
- Today, 07:16
- Joined
- Oct 1, 2012
- Messages
- 59
All I am doing is changing view from AcForm to AcDatasheet from a subform.
I can't replicate it when I build a simple Form/Subform (on a navigation form) so have had to strip out all but the form causing the issue in the database I'm actually building in the hope someone can see the issue.
From "Navigation" form I have a subform with a double click event on the 'LastName' to open that record in AcForm. The command button on the AcForm view returns user to the datasheet view.
Whilst I get to the datasheet the project locks until I Alt tab out of Access (or add a msgbox after the AcDatasheet line of code.
Whilst the message box stops the lock it's hardly elegant and I'm worried it may be something more serious with the way I have linked the subforms?
I can't replicate it when I build a simple Form/Subform (on a navigation form) so have had to strip out all but the form causing the issue in the database I'm actually building in the hope someone can see the issue.
From "Navigation" form I have a subform with a double click event on the 'LastName' to open that record in AcForm. The command button on the AcForm view returns user to the datasheet view.
Whilst I get to the datasheet the project locks until I Alt tab out of Access (or add a msgbox after the AcDatasheet line of code.
Whilst the message box stops the lock it's hardly elegant and I'm worried it may be something more serious with the way I have linked the subforms?
