Windows 7 64bit 
Access 2010 32bit
Using Macros within a form/subform to set values between master and child forms- Help
Hi
I am new to this forum and not sure if this is a form or macro issue (both). Having finally discovered the solution to SetValue in 2010 (without using unsafe command) - which not very commonly explained but simple. Use Set Property and Value with expression from standard list of options. I now have a problem moving focus of macro.
I am using Macros rather than code as not sufficiently able with code but fully ok with macros.
Putting it simply
I have a a subform (timesheet) within a main form (job) in one to many configuration
In the detailed records of the subform I capture time and values.
On creating a detail record I capture detail from other tables and pass the Latest Data from detail record updated on sub form to update the master form.
On opening the following detail record I capture the latest data from Master and place that in fields storing previous data on the detailed record.
(this is so that the detailed record holds all the data I need from the current record and the previous detail record for calculating time durations, etc).
Problem from the sub-form I can set property / value of calculated fields in teh subform. When I try to get the macro to then set property of a control (field in the main form) the control name is not recognised. I have tried numerous variants but cannot seem to find a way to get the marcro to move to the current record in the main form (which is the one to the many and storing last record details).
Anyone have any ideas. I'm pulling my hair out. Guess it is something to do with moving the focus but never had the issue before. The forms and subforms were created buy the subform wizard and use the relationships in the underlying tables to keep referential integrity and display the correct records in teh sub form.
Thanks for idea.
OKC
Reply With Quote
