Automatically populate combos from one subform to another

[JFo]

As per the attached database I have a number of forms/ subforms that populate certain tables.

If you open fromMainMenu and then populate combo boxes and click on add new inspection, it opens frmInspections and then frmEquipment and finally frmChecklist

with all the data carried through these forms frmChecklist will open with the certain questions required for an equipment checklist (at the moment only 1). This all works well except the user must click on the frmChecklist before the questions are visible/ populated



When the Equipment is selected from combo box I would like this to populate or be visible automatically (I will add a button for example 'add piece of equipment to inspection')

Does anyone know how to do this?

Thanks

[June7]

Not really understanding what you want. User clicks into ChecklistID combobox on frmChecklist and makes selection from droplist? Sounds like acceptable behavior.

[JFo]

Yes this is acceptable behaviour and is not a major issue as it is functional however it is not working the way I would like.

Ideally I want the user after selecting the item from the combo to click a command button that displays the form with the values already visible in the combo boxes for the questions.

I will not be using datasheet view and want to display multiple questions per page

I am trying to make frmChecklist not visible and then trying to use code like

Private Sub cmdOpenChecklist_Click()
[Forms]![frmInspections]![frmEquipment].[Form]![frmChecklist].[Form].Visible = True
[Forms]![frmInspections]![frmEquipment].[Form]![frmChecklist].[Form]![txtComment].SetFocus
End Sub

However both those lines of code mean that the question combo is not displayed at all, the only way I can get it to display the values is to click on the form

As I will be putting multiple questions on each page the form must be set to not visible to start with and made visible as it will cover the whole screen and having the questions displayed without having to click on them is also essential

Thanks

[JFo]

I figured it out eventually using a macro to make form visible followed by macro gotocontrol

Thanks anyway