jepoysaipan
Registered User.
- Local time
- Today, 09:01
- Joined
- Nov 4, 2007
- Messages
- 133
Hi,
As usual I am here again to seek help and guidance to the Masters .
Ok, I'm using Access 2K7, I have an unbounded "Main Form" which houses a Tab with 4 pages, on each pages is a datasheet subform.
Now I wanted that when every time I switch pages the datasheet be requeried, I tried putting the Forms!mysubform.requery on each pages on the "On Click" event but it doesn't trigger, but when I created a command button which I store all the requery on my pages it works like magic
The reason why I want to requery the datasheets is that whenever I selected a data on any datasheet it will open a separate form for editing/adding/deleting the record, so I have to requery the record to update the datasheets on my tab.
Am I missing something?
Thanks again for all your help.
Jeff
As usual I am here again to seek help and guidance to the Masters .
Ok, I'm using Access 2K7, I have an unbounded "Main Form" which houses a Tab with 4 pages, on each pages is a datasheet subform.
Now I wanted that when every time I switch pages the datasheet be requeried, I tried putting the Forms!mysubform.requery on each pages on the "On Click" event but it doesn't trigger, but when I created a command button which I store all the requery on my pages it works like magic
The reason why I want to requery the datasheets is that whenever I selected a data on any datasheet it will open a separate form for editing/adding/deleting the record, so I have to requery the record to update the datasheets on my tab.
Am I missing something?
Thanks again for all your help.
Jeff