Hi, thanks for the reply and sorry for not making myself clear.
Here goes again:
I have one main form, in which there are a number of tabbed pages. Due to there being many different tables, each tab has a subform displaying the data, and is linked to the main forms record with the member of staff's ID. This is fine, as when i click the button to go to next or previous record, all the subforms and the main form, is updated. However, the problem i was having initially is this. When i was looking at the main form, and i used the mouses scroll wheel, as access does it scrolled through the records, and all the subforms were updated as well, HOWEVER, if i was looking at a subform and then used the scroll wheel, what was hapenning was that only that subform scrolled through records, and did not change the staff ID for the entire form and all other subforms, thus the data shown in that subform was not the same persons data shown in the other subforms and main form. What i decided to do, was completely remove the ability to scroll through records using the mouse wheel, so i was able to find this solution from Microsoft by creating a DLL file and adding this to the database, along with a small piece of code in the forms. This worked as it was supposed to in the main form, however on all of the subforms, as was supposed to it wouldn't scroll, but it also stopped me being able to enter fields with the mouse. I was able to tab to them, but i couldn't click in them. Simply wouldn't work. What i was wondering if i could do now, was to remove this code so the scroll wheel would work, for the main form, however, have a piece of code on the subforms that basically says when the scroll wheel it moved, set the focus to the Staff ID box (on the main form) and then scroll, thus changing the data in every form.
Hopefully that was more clear, if not then i can try and explain again.
Thanks
