Form linked to table but will not add data to table


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

.