Error with macro while opening access.

[Trisha]

Dear,

I am facing a strange error in MS access due to one macro while opening one form.

But the error in only showing in my machine. In my colleagues machines the form is opening without any error.

"expression after SHIFT input parameter as the event property is a erreur.L 'object or class does not support the set of events.



*the result of the expression is the name of a macro, the name of a defined function or not In User Event procedure.


*an error may have occurred during the evaluation of a function, an event or a macro"

Above is the english translation of the below error message.

[RuralGuy]

Do you have any *bogus* MISSING References?

[John_G]

What happens if you try to open the form without using the macro? Do you still get the error?

If you do get the error, check the values for the Event properties on the form. It's only a guess, but is Après MAJ the name of something in your database? If so, the blank in the name may be causing the problem. To may knowledge, there is no event called After Shift or On Shift in Aceess 2000.

John

[Trisha]

Dear John_G,

The form is opening without any error message.
In the form there is a field named Reference (Text) comimg from a table.
On selecting a reference value the form get populated with the data related to the reference.

But during selecting the reference in the field I get the error message.


The macro code for fetching the record set of the selected reference is:

Private Sub Modifiable20_AfterUpdate()
Dim rs As Object
Set rs =Me.Recordset.Clone
rs.FindFirst "[Reference] = ' " & Me![Modifiable20] & " ' "
If Not rs.EOF then Me.Bookmark = rs.Bookmark
End Sub

[John_G]

Hi -

I think your error is here:

Your code line Set rs =Me.Recordset.Clone

should read

Set rs =Me.RecordsetClone (no period after recordset)

John

[RuralGuy]

To add to John's post: Recordset.Clone is an ADODB method and RecordsetClone is a DAO property. Good catch John!