Run-Time error "2501"

  • Thread starter Thread starter Andrew
  • Start date Start date
A

Andrew

I am getting a Run-Time error "2501" when I dblclick a
record in a subform to open that record up.

DoCmd.OpenForm "MPPFrm", , , "[MPPFrm]![MID] = " & Me!
[MID]

I have used this code many times, and have no clue if I
am forgetting something on the form that I am trying to
open

IT keeps asking me for the peramitor MPPFrm!MID ( and the
value that it wants)
It seems that something is not right with the form that I
am trying to open.

any Ideas, Andrew
 
Hi,
Just use the field name in your criteria.
"[MID] = " & Me![MID]

You do realize that Mid is also a native VBA function so I'm sure that will cause you some
problems somewhere!
 
Back
Top