Iif in textbox in datasheet to run event to open form

[PeterPeterson]

Using one of the templates from the Microsoft site I found the datasheet view of contacts that included a column with a hyperlink "Open" to open the contact's details very useful. The control source is

=IIf(IsNull([StudentID]),"New","Open")

I have modified it to "Students" and use VB instead of a macro to open the student details form.

Private Sub Open_Click()
   
   If Not Me.NewRecord Then
      DoCmd.OpenForm "frmStudentDetails", _
        WhereCondition:="StudentID=" & Me.StudentID
   Else
      DoCmd.OpenForm "frmStudentDetails", acNormal, , acFormAdd
   End If

End Sub

This works well.

I have applied exactly the same logic and code to qualifications,however, the word 'Open' is replaced with '#name?' letting you know immediately somethingis not quite correct.

Clicking on the link results in the following error:
"This error occurs when an event has failed to run because the location of the logic for the event cannot be evaluated. For example, if the OnOpen property of a form is set to =[Field], this error occurs because a macro or event name is expected to run when the event occurs."

Control Source is

=IIf(IsNull([QualificationID]),"New","Open")

The VB Event is:

Private Sub Open_Click()

If Not Me.NewRecord Then
   DoCmd.OpenForm "frmQualificationDetails", _
     WhereCondition:="QualificationID=" & Me.QualificationID
Else
   DoCmd.OpenForm "frmQualificationDetails", acNormal, , acFormAdd
End If

End Sub

I hope someone can point out to me where my error is.
Thanks
Peter

[June7]

The acFormAdd is in the wrong position for both statements that use it. How did that happen if VBA intellisense popup tips is working. Don't know how the first one could run without error.

DoCmd.OpenForm "frmQualificationDetails", acNormal, , , acFormAdd

Also, try this for the OpenForm with WHERE CONDITION

DoCmd.OpenForm "frmStudentDetails", , , "StudentID=" & Me.StudentID

[PeterPeterson]

June7,
Thank youforyour reply. I have corrected the two lines of code (I don't know how I missed the ",").
I have also changed the WHERE CONDITION line.
However, the issue I had is still there.
I am still some way off getting this little application to a point I can replace our current paper based system we have at work. It is only used to manage 2 courses a month, but I am enjoying learning more about Access.
I wish to use the StudentBrowser as the main screen and use the buttons on the header to open other browers from where the 'details' form can be opened to add new records.
I have attached the database which may assist in locating my original error which is still present.
Thanks again
Peter

[June7]

I think the form is corrupted. I created a new form and copy/pasted the controls from existing form to the new one and it works.

[PeterPeterson]

June7,
Thanks so much for your help - I recreated the form to find it works also.
I have spent the last few days trying various things without success.
Thanks again
Peter