Hello All. I need help with correctly using the mousemove events without getting an error. I have attached a Word document explaining what I need to do and would appreciate the help. Thank you, Patrick:banghead:
Access 2013 VBA MouseMove Event Issue
- Thread starter pmullan
- Start date
isladogs
Access MVP / VIP
- Local time
- Today, 07:58
- Joined
- Jan 14, 2017
- Messages
- 19,311
As you've found out, you can't use the MouseMove event for this as moving over an object doesn't cause it to receive the focus
I think you need to modify your approach
1. Make the Notes box taller so its obvious that there is more space to add additional text
2. Add code to the Notes_AfterUpdate event to set the focus to the Add Record button
Then 1 click will do what you want
However, do you really need the button?
You could add code to the Notes_AfterUpdate event to save the record
OR make the Notes textbox a bound field so it is automatically saved?
I think you need to modify your approach
1. Make the Notes box taller so its obvious that there is more space to add additional text
2. Add code to the Notes_AfterUpdate event to set the focus to the Add Record button
Then 1 click will do what you want
However, do you really need the button?
You could add code to the Notes_AfterUpdate event to save the record
OR make the Notes textbox a bound field so it is automatically saved?
Basically you shouldn't need to click twice.
Do you've some code running that could disturb that normal behaviour?
Could you post your database with some sample data + a description how to reproduce the fault?
Do you've some code running that could disturb that normal behaviour?
Could you post your database with some sample data + a description how to reproduce the fault?
