Re: Form linked to table but will not add data to table

Your first issue is that you are entering a new record into a table from a
form but the record is not saving. You will never be able to edit a
non-existing record in your second form.

Are there any required fields that are not being populated in the first
form? Can you whare your "hit continue" code?

--
Duane Hookom
MS Access MVP


"DigiVamp" <DigiVamp.208wam@xxxxxxxxxxxxxxxx> wrote in message
news:DigiVamp.208wam@xxxxxxxxxxxxxxxxxxx
>
> I have one table and two forms.
> The table is called orders and stores typical data you would expect to
> find.
> The first form is called PreOrderDetails.
> you use combo boxes to enter who you are, which site you are ordering
> for and which company you are ordering for. (a hidden orderID field set
> to autonumber also populates on this form) [This table is set to Data
> Entry only so it always opens with blank fields for the user to fill
> in]
>
> Once you have entered these three bits of info you hit continue. This
> closes the preorder form and opens the main order form to the newest
> order record for you to enter the rest of the info (like what you want
> to order)
>
>
> I just noticed that when you hit continue and the main order form
> opens, the info displayed is not the latest order. when I checked the
> table both forms are sourced to (orders table) it has not got any new
> orders added to it.
>
> I've spent about two weeks working on this DB and its driving me
> insane, I'm sure this worked a couple of days ago when I tested, and as
> far as I know I hvae not changed anything to affect it but since it
> stopped working, I'm guessing I've done something.
> Any help anyone can offer would be gratefully appreciated.
>
> Dv
>
>
> --
> DigiVampPosted from - http://www.officehelp.in
>


.

Relevant Pages

  • Re: Spidey Pics from The Korn up
    ... The three stand up targets to Sandman, will they drop similar to AFM ... I wonder how that upper right flipper is going to work? ... stays open long enough after a shot or if it opens automatically when ... ball will hit it and backtrack straight down the right outlane. ...
    (rec.games.pinball)
  • Re: Looping
    ... then open form ... then you will see that code stopped at breakpoint ... When I hit F9 it places a> breakpoint, then when I hit F5 it opens a Macro screen. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Unauthorized Movers!
    ... Hit alt-F11 to get to the VBE ... Use the dropdown on the top left of that window to choose: ... Kindly remind me how I get to these two event handlers. ... uncheck it when he opens the file and recheck it when he exits (or when he ...
    (microsoft.public.excel.programming)
  • Re: Odd behaviour
    ... interactive environments, not in programs. ... EXCEPT for your mention of the SPR. ... set view to ss (view that's been saved, opens up all of the ... Hit exit in the Course Information window (notice I haven't made ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Odd behaviour
    ... EXCEPT for your mention of the SPR. ... set view to ss (view that's been saved, opens up all of the ... Hit exit in the Course Information window (notice I haven't made ... -It highlights ANOTER line in the code, again an unchanged line, ...
    (microsoft.public.fox.programmer.exchange)
Loading