Please HELP Having problems aith an Orders DB

[mick3911]

Hi All,



I am hoping that you can help me.

I haven’t used Access to build anything for a few years so Ihave forgotten more than I knew.

I need a DB where I can send out invoices out to people sothat they know that they need to pay for something.

As I said, I have forgotten mare than I knew so I knew thatthat Access 2000 (from Office 2000) had an Orders template so I thought I woulduse that after modifying it and that is where I need your help.

I have uploaded my DB to make it easier for you tounderstand/see what is going wrong. When I place an order the screen ‘jumps’after I have entered the details and try to exit the form I keep getting thefollowing message ‘You cannot add or change a record because a related recordis required in table ‘Orders”. Then I get a ‘Can’t save the record etc etc’. So,I click OK. Then go back into the form click on the order then leave the pageand it works???????

Can someone please have a look and see where I have gonewrong and how to fix it.

Many thanks Orders.zip

[aytee111]

Remove the sub "Order_Details_Subform_Enter". Replace it with OnCurrent:

Private Sub Form_Current()

    If Me.NewRecord Then Me!OrderDate = Date

End Sub