Hello everybody,
I have a looked into this question quite a bit, but I have yet found a working answer. I'll do my best to explain...
I have a main form, "fMain", that uses a tab index. On each page is a subform for a different area of my job ("purchasing", "tracking", "dispatching", etc.). On each of these subforms, the controls are set to display a specific record AND a (subform) query that shows all records. What I want is that under purchasing I can view the history of my purchases in the query, and select one to show in greater detail on the parent form. Everything is in place, and I have managed to get a few simple macros off, but the macro I'm really trying to build just isn't working the way I want:
1. I can't seem to change the record of a parent form from a selection in a child form, on a grandparent form..
2. I can't "goto" the selected record without using some vba
Here's what happens when a child form query "ID" is selected:
SelectObject (Grandparent form)
Type: Form
Name: fMain
InDWindow: No
GoToConrol (Parent Form, sub to fMain)
Control Name: f01JobsDetails
GoToRecord
Object Type: (Blank)
Object Name: (Blank)
Record: GoTo (Right now it's next for testing purposes, but it should pull the selected "ID" field from the query)
Offset: ???(Blank)
I've tried various syntaxes for the control name and select object commands, but to no avail. Any help would be greatly appreciated.
Thanks
I have a looked into this question quite a bit, but I have yet found a working answer. I'll do my best to explain...
I have a main form, "fMain", that uses a tab index. On each page is a subform for a different area of my job ("purchasing", "tracking", "dispatching", etc.). On each of these subforms, the controls are set to display a specific record AND a (subform) query that shows all records. What I want is that under purchasing I can view the history of my purchases in the query, and select one to show in greater detail on the parent form. Everything is in place, and I have managed to get a few simple macros off, but the macro I'm really trying to build just isn't working the way I want:
1. I can't seem to change the record of a parent form from a selection in a child form, on a grandparent form..
2. I can't "goto" the selected record without using some vba
Here's what happens when a child form query "ID" is selected:
SelectObject (Grandparent form)
Type: Form
Name: fMain
InDWindow: No
GoToConrol (Parent Form, sub to fMain)
Control Name: f01JobsDetails
GoToRecord
Object Type: (Blank)
Object Name: (Blank)
Record: GoTo (Right now it's next for testing purposes, but it should pull the selected "ID" field from the query)
Offset: ???(Blank)
I've tried various syntaxes for the control name and select object commands, but to no avail. Any help would be greatly appreciated.
Thanks
