F
FBTRon
I have a form [Tracking Main] which contains a subform [Engineering Projects
Query Subform] thats built off of a Query[Tracking Query Main] and I want to
be able to use the "OnClick" feature to open the selected project from the
Tracking Main Form in the another form [Detail Screen] so that I can then
update informaiton in this record
This is the statement that I have tried to use but it is not working the way
I would like it to. What happens is that when you click it pops us a window
asking for the Project Number(the control field), and what i would like to
happen is that it simply go to that record in the selected form [Detail
Screen].
Action: Open Form
Form Name: Detail Screen
View: Form
Filter Name:
Where Condition: [Project#]=[Forms]![Engineering Projects Query
Subform]![Project#]
Data Mode: Edit
Windows Mode: Normal
Does anyone have any suggestions. Also if anyone has any suggestions about
where I can find resources for writing macros it would be greatly appreciated
since this is a real weak spot of mine.
Query Subform] thats built off of a Query[Tracking Query Main] and I want to
be able to use the "OnClick" feature to open the selected project from the
Tracking Main Form in the another form [Detail Screen] so that I can then
update informaiton in this record
This is the statement that I have tried to use but it is not working the way
I would like it to. What happens is that when you click it pops us a window
asking for the Project Number(the control field), and what i would like to
happen is that it simply go to that record in the selected form [Detail
Screen].
Action: Open Form
Form Name: Detail Screen
View: Form
Filter Name:
Where Condition: [Project#]=[Forms]![Engineering Projects Query
Subform]![Project#]
Data Mode: Edit
Windows Mode: Normal
Does anyone have any suggestions. Also if anyone has any suggestions about
where I can find resources for writing macros it would be greatly appreciated
since this is a real weak spot of mine.