Run Query Button Not Working

[SusanHRO]

Hi.
I have a query, and as the criteria for one of the fields I have it referencing a drop box I made in a form. It works: I can open the form, select my option, go to my query, click run, and it all works fine.

But now I want to put a Run Query button onto my form, so that others can easily use it without going to the actual query to click run.
I used the Command Button - selected Miscellaneous,
Run Query, clicked the correct query, and gave it text and a title.

However, when I go to my form and press this new Run Query button, nothing happens. What am I doing wrong?



Any help is appreciated!

[SusanHRO]

I went to View Code and I believe this is the code for my button, if that's helpful to anyone. (I don't now how to use MVB so its greek to me)

Private Sub Command8_Click()
On Error GoTo Err_Command8_Click

Dim stDocName As String

stDocName = "Project Specific Query"
DoCmd.OpenQuery stDocName, acNormal, acEdit

Exit_Command8_Click:
Exit Sub

Err_Command8_Click:
MsgBox Err.Description
Resume Exit_Command8_Click

End Sub

[rpeare]

If nothing is happening and you went through the command button wizard I suspect that you've changed the name of your button after you created the event procedure. Make sure the NAME of your button (the very first field when you look at the properties) is Command8. If it's not, change all the references in your code that you posted from Command8 to whatever the button is currently named.

[boblarson]

And if it is named Command8 then make sure that you are running the database from a TRUSTED LOCATION so that code is enabled.

See here for more about that:
http://www.btabdevelopment.com/ts/de...aspx?PageId=13

[SusanHRO]

No luck ... it's so strange that I don't even get an error box or anything. Nothing at all happens.

[rpeare]

can you enclose a sample database (with fake data) to look at.

[boblarson]

Susan:

Not strange but just needing to troubleshoot.

Go into the form in design view, click on the button to select it, go to the properties dialog and the EVENTS tab and look in the click event and make sure that [Event Procedure] is listed like that. Sometimes some things can disassociate it (like copying to or from a tab control) and then you have to go back and select [Event Procedure] again.

[SusanHRO]

Event Procedure is listed correctly.

rpeare - what exactly do you want to see? i have a monster table, a query referencing that, a query referencing the query, and then a form trying to run that query.

[rpeare]

Just a copy of the database, without any sensitive information in it so that there should be at least *1* record in the return query. From your description the query is not returning anything (the button is not even doing anything) so if you blank out all of your data and put in 1 or 2 records then zip up this copy and post it here (access 2003 or below please) we can look at it