Solved Trouble adapting Uncle Gizmos Checklist code.

[arnelgp]

did you see my sample? it doesn't use Multiple sformData. there is only 1 sformData. it only Use the Master/Child link fields.

 

[HillTJ]

Yes,arnelgp. I have downloaded it. Excellent, but i'm unsure how to link another subform to hold data that pertains to the particular checklist tab. I had an unsuccessful go. Please see my upload. As always appreciate your input.

 

[HillTJ]

Tony, thanks. Will have a go. I think it's best to redo the logic now to avoid a potential problem later. I have no idea how successful this application may be, but if you've, with your experience have identified a problem then i should take heed of your advice. I can always work on the accident/incident recording part. Thankyou again.

 

[HillTJ]

Tony, arnelgp's approach appears much different to yours. You alluded to impending doom if i continued with the current methodology. Will arnelgp's method overcome the eventual issues?. If I could figure how to include the link Child:Master via 'Datasets' on the attachment form then all should work? I tried replicating the 'datasets' field from the checklist table to the main form thinking that it may now be 'visible'. But could not "see" it from the attachment form when trying to link parent:child. I thought this would be the answer! I don't really know what to do next. Please see my latest upload a couple of posts back.
PS - Arnelgp, your version would not let me add a new record. A teething problem?

 

[arnelgp]

you should add New List to tbList, since it is the Master list.

 

[HillTJ]

Tony, thanks for the prompt reply as always. I notice arnelgp's version uses a lot less code (He fires off an append query to capture the Checklist results). I also understand that your intention is to develop a 'drop-in' "Module" which, as a newbie I commend. Realistically, I don't imagine this application getting a lot of use, maybe a few checklists generated/week at a single site on a single PC. Or maybe split,with a few users at most. Cutting to the chase, I'm a bit confused between the two approaches. Which is better in my application? There is a bug in arnelgp's code that prevents a new record being added, but apart from that it works the same as your method, to me. But same problem linking the 'attachments' form. I don't mean to offend anyone.

 

[HillTJ]

arnelgp, I was responding to Tony, when I saw your response. Don't Quite follow you.

 

[arnelgp]

you have a Master List in tbList, then you have a tblData which has the records of tbList.
tblData is used in your Pipemaker workplace inspection list.
in order to Add new List, you add it to tbList.

otherwise, if you want to add it to tblData, remove the Master/Child link and instead
Change recordsource of subform each time you change tab.

whatever you Add to tbData must be added to tblList also.

 

[HillTJ]

arnelgp/Tony. Thanks, got it all sorted & have included a sub form attachments related to each tab. Looks great. If you'd like to see a copy, then I'd be happy to upload it once I make a few more tweaks. Thanks for your patience.

 

[HillTJ]

Tony, Thanks for remembering me! I'll do as you suggest. I understand the principle, but it will take me a while to digest. Learning all the time....... Appreciate it.