Form linked to table but will not add data to table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DigiVamp - 18 Dec 2005 16:31 GMT

I have one table and two forms.
The table is called orders and stores typical data you would expect t
find.
The first form is called PreOrderDetails.
you use combo boxes to enter who you are, which site you are orderin
for and which company you are ordering for. (a hidden orderID field se
to autonumber also populates on this form) [This table is set to Dat
Entry only so it always opens with blank fields for the user to fil
in]

Once you have entered these three bits of info you hit continue. Thi
closes the preorder form and opens the main order form to the newes
order record for you to enter the rest of the info (like what you wan
to order)

I just noticed that when you hit continue and the main order for
opens, the info displayed is not the latest order. when I checked th
table both forms are sourced to (orders table) it has not got any ne
orders added to it.

I've spent about two weeks working on this DB and its driving m
insane, I'm sure this worked a couple of days ago when I tested, and a
far as I know I hvae not changed anything to affect it but since i
stopped working, I'm guessing I've done something.
Any help anyone can offer would be gratefully appreciated.

D

--
DigiVampPosted from - http://www.officehelp.i

Reply to this Message

Duane Hookom - 18 Dec 2005 17:30 GMT

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?

Signature

Duane Hookom
MS Access MVP

> I have one table and two forms.
> The table is called orders and stores typical data you would expect to
[quoted text clipped - 23 lines]
>
> Dv

Reply to this Message

DigiVamp - 18 Dec 2005 18:10 GMT

The code tied to the continue button;

Private Sub OpenOrderForm_Click()
On Error GoTo Err_OpenOrderForm_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "Orders"
DoCmd.Close
DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_OpenOrderForm_Click:
Exit Sub

Err_OpenOrderForm_Click:
MsgBox Err.Description
Resume Exit_OpenOrderForm_Click

End Sub

But this seems very generic. There are only three editable fields an
whilst I am doing the testing myself I know I am filling in all thre
before I hit continue

--
DigiVampPosted from - http://www.officehelp.i

Reply to this Message

DigiVamp - 18 Dec 2005 18:18 GMT

Fixed it,
I made a dependent Field in the table to be required and hadn'
included it on the pre-Order form, it was a date field.
Soon as I took it off required the forms work again.

Thanks for your help though.

DigiVam

--
DigiVampPosted from - http://www.officehelp.i

Reply to this Message