Open Form to Specific Record

[Guest]

I am using a subform, populated from a table to add information <no Problem>

I have a field (autonumber ID Field) that I was trying to use an OnClick
event with to open a form to that specific record.

DoCmd.OpenForm "frmFineMemo", , , "ID=" & Me.ID

I get the following error that I have not encountered before.

The expression On Click you entered as the event property setting produced
the following error: Object or class does not support the set of events.

Anyone know why I am getting this error and how to fix it?

 

[Douglas J. Steele]

You didn't just type that as the property, did you?

It needs to be in a module. Select [Event Procedure] for the property and
click on the ellipsis (...). You'll get into the VB Editor in the middle of
the a routine:

Private Sub ID_Click()

End Sub

Type that expression there, so you end up with

Private Sub ID_Click()

DoCmd.OpenForm "frmFineMemo", , , "ID=" & Me.ID

End Sub

 

[Guest]

No it is in VB and I still got the error.

The field is in a subform and it is called subFineEdit. The field name is
ID and it is the autonumber field of the table.

I still can't figure it out.
--
Thanks As Always
Rip

You didn't just type that as the property, did you?

It needs to be in a module. Select [Event Procedure] for the property and
click on the ellipsis (...). You'll get into the VB Editor in the middle of
the a routine:

Private Sub ID_Click()

End Sub

Type that expression there, so you end up with

Private Sub ID_Click()

DoCmd.OpenForm "frmFineMemo", , , "ID=" & Me.ID

End Sub

 

[Douglas J. Steele]

Are you saying that you're running that code on the parent form, and you
want to refer to a value on a subform?

DoCmd.OpenForm "frmFineMemo", , , "ID=" & Me!subFineEdit.Form!ID

Note that "subFineEdit" may not be correct there. Depending on how you added
subFineEdit as a subform on the parent form, the name of the control that
holds subFineEdit may be named something different than subFineEdit. You
want to use the name of the subform control on the parent form if it's
different than subFineEdit.


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

No it is in VB and I still got the error.

The field is in a subform and it is called subFineEdit. The field name is
ID and it is the autonumber field of the table.

I still can't figure it out.
--
Thanks As Always
Rip

You didn't just type that as the property, did you?

It needs to be in a module. Select [Event Procedure] for the property and
click on the ellipsis (...). You'll get into the VB Editor in the middle
of
the a routine:

Private Sub ID_Click()

End Sub

Type that expression there, so you end up with

Private Sub ID_Click()

DoCmd.OpenForm "frmFineMemo", , , "ID=" & Me.ID

End Sub

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I am using a subform, populated from a table to add information <no
Problem>

I have a field (autonumber ID Field) that I was trying to use an
OnClick
event with to open a form to that specific record.

DoCmd.OpenForm "frmFineMemo", , , "ID=" & Me.ID

I get the following error that I have not encountered before.

The expression On Click you entered as the event property setting
produced
the following error: Object or class does not support the set of
events.

Anyone know why I am getting this error and how to fix it?