Macro missing

[Mike Powell]

Hello all,
I have built a purchase order db and created a box that shows my last purchase order number, so I can see it before entering a new number. ( I do not want autonumber) I have put in the code ( DMax .....) and it works fine. But... every time I run the form, it works. When I close or move through the records I get the following Macro missing message.
Microsoft Access can't find the Macro "Me". (This is in my source) The Macro doesn't exist or it is new and not saved. (Yep) The form works so it knows it's there, but I have no Macro's. I have removed the Me bit from the form "On current" line, but it still persists. Any idea's?

Thanks

Mike

 

[pdx_man]

What code is running with the OnCurrent event? Paste it here if you would. Do you have a textbox with the control source with something like:

=DMax("Ord_Num","Tbl_Orders")

or is this a part of the code that runs OnCurrent?

Are you accessing any functions in a Code Module where you copied a procedure from a Form Module that had the Me reference and now needs to be fully qualified? Just some thoughts ...

 

[Mike Powell]

macro error

PDX Man
My On current event code is: Me.Last PO Number.Requery
I have a text box with this code in that gives me the last record number. =DMax("[Purchase Number]","Purchase Table") I have removed the Me. but the error still shows every time I move through the records.
I have no Macros at all.

Mike

 

[pdx_man]

Give this a try:
Me.[Last PO Number].Requery (Try not to use spaces in field and control names. Use an underscore instead.)

also, just quote out the line and see if you get the error:

' Me.[Last PO Number].Requery

 

[Mike Powell]

Yipee

Work a dream.


Thanks,

Mike