[AccessD] Run Time Error 424 Object Required

That was exactly the problem. That's what I get for cutting and pasting from one DB to another and doing a good edit.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
Sent: Tuesday, April 03, 2012 4:50 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Run Time Error 424 Object Required

Don't know if it is a copy/paste problem in your message, but if:

>         With Me.RequestDate.Value = Null 'Eliminate the previous order ID.

really is a single line, then you probably need a line break in there:

With Me.RequestDate
     .Value = Null 'Eliminate the previous order ID.
     .Enabled = True 'Indicate that the current record is the start of a new order.
     .SetFocus
End With



On 3 Apr 2012 at 16:16, Kaup, Chester wrote:

> Why might I be getting this error. Below is the code that has an issue. Error occurs at the line Enabled =.  RequestDate.Value = 4/4/2012
> 
> Dim db As Database
>         Set db = CurrentDb()
> 
>         With Me.RequestDate.Value = Null 'Eliminate the previous order ID.
>             .Enabled = True 'Indicate that the current record is the start of a new order.
>             .SetFocus
>          End With
> 
> 
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com