queries/switchboard manager??

[thunderstorm]

how do i add queries into a form of my switchboard using the manager? what option is it? thanks

 

[dd/mm/yy]

how do i add queries into a form of my switchboard using the manager? what option is it? thanks

do you mean you want to load a query from the switchboard, or include information from a query on the switchboard?

if you want to load a query from your switchboard, you have to either use a macro or VBA, suggest VBA though because macros produce errors easily:

Function runQry()
On Error GoTo runQry_Err

    DoCmd.OpenQuery "QUERYNAME", acViewNormal, acEdit


runQry_Exit:
    Exit Function

runQry_Err:
    Resume runQry_Exit

End Function

then in the switchboard manager select Run Code and in Function Name put "runQry".

obviously change QUERYNAME to read the name of your query to run.

HTH

dd/mm/yy