Re: Help!! Problem with query

From: gene (gene_at_gte.net)
Date: 04/30/04 

Date: Thu, 29 Apr 2004 21:30:30 -0500

Here is a very simple test app I am testing with

this is the SQl statment

SELECT Table1.*, Forms!Form1!inviocedate AS Expr1
FROM Table1;

Yes the form is still open

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