PDA

View Full Version : Macro: error 2950



wasim_sono
08-22-2007, 10:35 PM
Dear All

I'm using Access 2007. I created a macro for searching a record by clicking S.No. on the form. The S. No. property 'Display as hyperlink' is set to "screen only". The macro runs perfectly but as that form ( display by macro result) close a message window of macro displaying on the screen as highlighting the button " stop all macros" and "error Number 2950".

The details of macro is given below:


EditInBoxMail, Form, , ="[S No]=" & Nz([S No],0), , Dialog
CurrentSNo, [S No]
CurrentSNo, nz(DMax("[S No]",[Form].[RecordSource]),0)
requery
, , First, ="[S No]=" & [TempVars]![CurrentSNo]
CurrentSNo


Is there an error in macro or It just displaying window. If so how can I hide it?

Thanks.

Wasim