Runtime 438 object dosenot support this property or method
You need to change the code to
Forms!FormName
syntax. This is one of the conversion issues in moving to
VBA.
BTW -- you did not need to crosspost so many newsgroups. One
would have sufficed (formscoding or modulesdaovba).
--
MichKa
-------------------------------------
don't send questions by e-mail unless
you're paying for it. (TANSTAAFL!) :-)
random junk of dubious value and
replica error and problem fixing at:
http://www.trigeminal.com
Quote:
> After I converted our database from 2.0 to 97 I am getting
this message for
> code bellow
> 'opens notes form limiting it to notes associated with the
current
> application
> Dim curform As Form
> Set curform = Screen.ActiveForm
> DoCmd.OpenForm "NotesForm", , , "[LinkedTo] =
'Application' and
> [LinkedTableID] = " & curform.ApplicationID
> Forms.[NotesForm].[TableName] = "Application"
> Forms.[NotesForm].[TableID] = curform.[ApplicationID]
> Forms.[NotesForm].[TableTextID] = curform.[FCC File]
