Re: Help!! Problem with query

From: Duane Hookom (duanehookom_at_NoSpamHotmail.com)
Date: 04/30/04 

Date: Thu, 29 Apr 2004 22:52:38 -0500

Try wrapping your control reference in CDate([Forms]![Form1]![inviocedate]) 

-- 
Duane Hookom
MS Access MVP
--
"gene" <gene@gte.net> wrote in message
news:%23e4cptlLEHA.3332@TK2MSFTNGP10.phx.gbl...
> I have also opened up the immediate window and I can run ?
> [Forms]![Form1]![inviocedate]
> and it returns the right value
>
>
> "Duane Hookom" <duanehookom@NoSpamHotmail.com> wrote in message
> news:Oqsf1llLEHA.2100@TK2MSFTNGP10.phx.gbl...
> > Show us your SQL. The form remains open, correct?
> >
> > -- 
> > Duane Hookom
> > MS Access MVP
> > --
> >
> > "gene" <gene@gte.net> wrote in message
> > news:eHaAKhlLEHA.1644@TK2MSFTNGP09.phx.gbl...
> > > Yes that happens when thy click on the command button to that runs the
> > udate
> > > query
> > >
> > > "Duane Hookom" <duanehookom@NoSpamHotmail.com> wrote in message
> > > news:uNtMvblLEHA.1312@TK2MSFTNGP12.phx.gbl...
> > > > Have you moved your focus on the form out of the date text box?
> > > >
> > > > -- 
> > > > Duane Hookom
> > > > MS Access MVP
> > > > --
> > > >
> > > > "gene" <gene@gte.net> wrote in message
> > > > news:%23JbtFOlLEHA.2932@TK2MSFTNGP12.phx.gbl...
> > > > > I am having a MAJor issue.
> > > > >
> > > > > I have an ubond form with a field I am loading with a date. I then
> run
> > > an
> > > > > update query to update a table pulling in the field from the form
> > using
> > > > the
> > > > > fully qualified name of the field. When I look at the query as a
> > select
> > > > the
> > > > > field is blanck even though I can see the date on the screen.
> > > > >
> > > > > I used to do the very same thing in an access 97 database and it
> STILL
> > > > works
> > > > > with out a problem I am trying to do it in Access 2002 I have
tried
> up
> > > > > grading to sp2 and sp3 still no help. I have tried it on 2
different
> > > > > mahcines. I am stumpted I would appreciate ANY help on this matter
> > > > >
> > > > > thanks
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>