This is my first posting as a beginner n i would really appreciate any help possible:

The following code results in a "too few parameters. expected 1". it bottoms out on the set recordset line. I believe this is because the recordset i am trying to open is dependant on a control in the form which is open at run time.

i really need help and any would be really appreciated

set Recordset = CurrentDb.OpenRecordset("qryfindherocard")

If Recordset.RecordCount < 1 then

DoCmd.OpenQuery "APqryAddNewHeroFromNorpass"

else:
DoCmd.OpenQuery "UDqryAddNewHeroFromNorpass"

End If

me.RecordSource = "qryFreeNorpassRecords"
me.Requery