Button coded with MVB

[cmfog]

When I click the button that I have on my form it is giving me a pop up saying "Run-time error '3061' Too few parameters. Expected 1."

So then I go to debug it and the highlighted line "Set rstCompNames = qdfCompNames.OpenRecordset." When I hover of it it says "rstCompNames = nothing."

I am not sure why it stopped working or how to correct it

 

[BlueIshDan]

could you provide the entire sub?

 

[KenHigg]

If you could post the entire code block maybe someone can help - ?

edit - have to be fast around here

 

[BlueIshDan]

chances are you want

        ' This is guessing that CompNames is the name of your query.
        Set rstCompNames = CurrentDb.OpenRecordset "CompNames"

 

[cmfog]

Thank you all but I figured it out

 

[KenHigg]

glad you have it working