New forms has old info populated when opening up

[batteryman]

Good morning

Can someone please assist me?

I have written a little database that helps me keep track of orders I am placing.
The problem is when I open the database to enter a new order I just placed, the fields all contain info from previous orders.

Where am I going wrong?



Thanks

[ssanfu]

Can someone please assist me?

So here is what we know about your dB:
1) "You track of orders."
2) "When you open the database to enter a new order, the fields all contain info from previous orders."

There is no way to give a good answer with that little info.

Post a pic of you relationships, pic of the form in design mode, state the form record source.
Or post your dB with a couple of record for demonstration. (do a "Compact & Repair", then Zip it)

[batteryman]

Thanks Steve, give me a bit to load the db for you.

[batteryman]

Hi Steve

I have attached the DB as requested.

Thanks for the assistance

Gideon

[ssanfu]

There is nothing wrong with your form or dB.

.... other than the usual things:
spaces in object names, (always a No No)
look up FIELDS in tables, *** see below
"ID" as the PK field name in all 3 tables, (should take the time to rename objects with meaningful names)
3 objects with the same name "FNB EC IT Order record" (use a naming convention)

(and you use... Macros... )


Currently, you open the form and the first record is displayed. To add a new record, click on the "New Record" button.

If you want to open the form to a new record, options are:
- have 2 identical forms - but one is in data entry mode and the other (current form) that lists all records. You open the form you want to use.
- create a menu form with 2 buttons. 1 button opens the current form, the other button opens the same form but in data entry mode using this button code

Private Sub cmdAddRecords_Click()
    DoCmd.OpenForm "FNB_EC_IT_Order_Record", , , , acFormAdd
End Sub

Private Sub cmdViewRecords_Click()
    DoCmd.OpenForm "FNB_EC_IT_Order_Record"
End Sub

*** See

The Evils of Lookup Fields in Tables
http://access.mvps.org/access/lookupfields.htm


The Ten Commandments of Access
http://access.mvps.org/access/tencommandments.htm