Queries from a switchboard

[Ravislayer]

Can anyone tell me how i can use the switchboard user interface so a user can type a query an get a table on the screen of the results. I dont care how it does it or whether it is proffessional or not. It is a last minute addition for a GCE project and i am ruinning out of time!!!

 

[Bryan F]

Create a form called frm GetQuery put a text box on it called txtQueryName. Then create a button and just put a caption that says show table. Now create a module and put this function or one debugged in it...

Public Function OpenMyQuery(strQuery as string)
Docmd.OpenQuery Forms!frmGetQuery!txtQueryName, acViewNormal

End Function

now on your shwitchboard add a command to open getquery in edit mode

 

[Ravislayer]

OK

I have some of this working, just the form and the show table button doesnt, im an access novice can u help further plz