Integrating 3 forms into 1 form

[JFo]

OK this is causing me some serious frustration. I have 3 forms frmInspections, frmSearch and frmAddEquipmentToInspection (including frmChecklist)

it is killing me trying to integrate these 3 forms into one form. By themselves they work OK (except I have broken frmChecklist somewhat trying to integrate them)

What I want frmInspections to do is to create or edit a current inspection, then you should be able to use the functionality in frmSearch to find equipment to add to the inspection. When a piece of equipment is selected it should display frmChecklist with the specific questions for that piece of equipment as well as default answers, etc and populate tblResults

I can get most things to work separately however no matter what I try I cannot get them to work in one form

Here is my current db with the current versions of the 3 forms
Attachment 5033



and here is my original database where I had the tblResults populating correctly
Attachment 5034

(notably in this old design you have to select values in frmMainMenu first and work your way through creating a new inspection and adding equipment

Any help or feedback is much appreciated


Thanks

[June7]

That zip holds an rar file. I can't extract rar files. Sorry.

[JFo]

Attachment 5036

Sorry June7

Here is a zipped version, Rar just compresses much better than Zip and winrar is free

Thanks

[June7]

I looked at frmAddEquipmentToInspection. One thing that seems problematic is that frmChecklist AllowAdditions property is set to No. You might really want that set to Yes. Also, think the subform should be in Detail section and main form set to SingleForm view.

[JFo]

Thanks for your response June7, been struggling with this myself and would love a bit of help again

I started again from scratch and tried to re-create what we did in the first place in frmInspections

Not worrying about search for now I just want to add or edit inspection and then select equipment from menu which opens checklist with the correct questions and default answers etc

I think I am fairly close however can't seem to populate answers or even select them at the moment I will work on the validation after

Thanks very much for your input

Attachment 5054

[June7]

Comments from my previous post still apply.

[JFo]

Thnaks for your tips

One thing that seems problematic is that frmChecklist AllowAdditions property is set to No. You might really want that set to Yes.

I did this but it doesn't seem to make a difference

Also, think the subform should be in Detail section and main form set to SingleForm view. Not sure what you mean by this all subforms are in the detail sections and main form is in single form view (frmInspections)

Any ideas why my Answer combo is not populating?

frmAddEquipToInspection was not working properly so I started again

Thanks

[June7]

The form frmAddEquipmentToInspection I examined had all controls in the header. I made the changes as I suggested and the form/subform displayed properly.

[JFo]

Thanks June7, I will try getting it to work, I have changed my design again so may take me a while

[JFo]

I must be missing something, I allowed additions (even though the last version I have that is working properly is set to no) and moved sub-form from header to detail section and now it doesn't do anything, doesn't even populate the check-list

I have now been trying for untold hours in many different ways and I really do not understand this. Why can't I just copy or import the working forms for this part, it never works for me?

I am actually trying to initiate the checklist opening from frmInspections (in either edit mode or add new mode) however I can't even get it to work from stand-alone, please help June7

Thanks

[JFo]

OK so another few hours later and at least I have got it to sort of display, however does not change/ requery

Open frmInspections --> select clientsite and it will open the inspection with equipment added to it

If you then click on add edit it opens another form where I want to perform the inspection, it opens it up fine and I have managed to transfer all important data however cannot get the check-list working properly

It should open in new or edit mode depending whether the piece of equipment was inspected before

Thanks for your assistance

[June7]

Check out this revision.

EDIT: Purpose served, file removed.

[JFo]

awesome thanks June7

I will test this out thoroughly and try not to bother you again... I just remembered the reason allow additions was turned off was to not show extra question

Thanks again