Basically I want to jump to a record on a mainform by clicking a button on a subform within the mainform:
I have a form which shows records and within each record there are several sub-records, to help me jump straight to a certain sub-record I have put a subform down the side that is linked to the mainform and lists all sub-record numbers for the record that I am currently on. Next to each sub-record number is a button, I want to be able to press this button and it takes me straight to that sub-record on my main form, basically a lookup.
The closest I have got to what I want is to click the button, it then copies the sub-record number to the main form and sets the focus on a button on the mainform that will lookup the sub-record when clicked. So basically I click on the number I want and have to press return to get to it. but I want to just press it and it takes me to the sub-record without having to hit enter as well.
So i've got the code to get the number from the subform to the mainform and the code to lookup the record on the mainform, but i can't do the whole thing from the subform?
This was really hard to try to explain so if you think you can help me then please ask questions to clarify anything.
I have a form which shows records and within each record there are several sub-records, to help me jump straight to a certain sub-record I have put a subform down the side that is linked to the mainform and lists all sub-record numbers for the record that I am currently on. Next to each sub-record number is a button, I want to be able to press this button and it takes me straight to that sub-record on my main form, basically a lookup.
The closest I have got to what I want is to click the button, it then copies the sub-record number to the main form and sets the focus on a button on the mainform that will lookup the sub-record when clicked. So basically I click on the number I want and have to press return to get to it. but I want to just press it and it takes me to the sub-record without having to hit enter as well.
So i've got the code to get the number from the subform to the mainform and the code to lookup the record on the mainform, but i can't do the whole thing from the subform?
This was really hard to try to explain so if you think you can help me then please ask questions to clarify anything.