The linked master field on the main form is [Ref].
The Linked Child field on the subform [TLinks_subform] is [ARef].
These allow the records to be associated. The actual subform (table) field I am interested in is [Link] as seen above.
Thanks Ranman256.
The report is built and works for the parent form. The data is linked in terms of the underlying query and records for the main form.
I don't know how to append one of the existing report's fields from the subform recordset.
Can I modify my existing code to achieve this...
Hello all,
This relates to a previous SOLVED post of mine and the use of a Form to show records based on an Action Table (previous post discussed email attachments).
The form (FActions) also has a subform (TLinks_subform) shown which allows Users to record references (record numbers) for...
Solved it !!!
Spotted Typo in original code "RecorsetClone" ( I read this lots of times and missed it)
Modified code also includes wildcard to attach multiple file types (not just PDF).
Code now reads:
' Add attachments for each any every linked file
Dim rs As DAO.Recordset
Dim strFile...
Hi.
I am trying the code above but am getting a runtime error 2465 "Application defined or Object defined error" in the following line...
Set rs = [TLinks_subform].Form.RecorsetClone
I have also tried...
Set rs = Forms![FActions]![TLinks_subform].Form.RecordsetClone
Same result.
Of course !! ( I forget how helpful Access is at doing some of the hard work for you).
I'll give this a go today and let you know how it goes.
Thanks for your time.
Thanks very much for the replies.
The suggested VB looks like a great start but there is one modification required I think.
Not all the items in the subform / recordset should be attached. Only those where TLinks [ARef] matches the current Action Record on the main form (FActions). (This is...
Hello, Can anyone help with this at all...
I have a Form (FActions) that shows a record from a table (TActions).
The form also shows a subform (TLinks_subform) that relates to a "linked files" table (TLinks).
The User can associate reports (TReport) with the Action record (one to many) by...
Hi,
I'm new to the forum.
I've been using Access for a number of years and have several successful systems in use.
I am not however a programmer in that I am able to make use of / tweak existing VB code but lack the knowledge and (in many respects) the time to develop writing my own VB...