Odd Parameter error

[alanMAC]

I have a Form that is based on a Query SkillsQry.

The query runs perfectly (no problems)
The Form opens AOK when opened from the database window.

When the form is opened from a button on another Forms it asks for a parameter value SkillsQry.Surname

I have checked the Forms and queries for any mispellings and/or double data entries but no luck.

If I just escape it will open the form no problem, but it is bugging me, normally I can find such a problem.

Any ideas?

 

[Norie]

Alan

What about the code behind the button?

Have you checked that?

 

[alanMAC]

The code is below Norie, I cannot see any problem .
I usually creat a macro then convert to code.

Note I have the * in the form name as a reminder that it is a "keep hold of object" as I design my DB.

Private Sub OpenSkillsfrm_Click()
On Error GoTo Err_OpenSkillsfrm_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "* Add Skills Form"
DoCmd.OpenForm stDocName, , , "[DriverID]=[Forms]![* Drivers Entry Form]![DriverID]", , acNormal

Exit_OpenSkillsfrm_Click:
Exit Sub

Err_OpenSkillsfrm_Click:
MsgBox Err.Description
Resume Exit_OpenSkillsfrm_Click

End Sub

Thanks for looking at it.