Re: Help!! Problem with query

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


Date: Thu, 29 Apr 2004 21:18:39 -0500

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
> > >
> > >
> >
> >
>
>