how to set (in a form) a default equal to previous entry value

[marq]

Hi all, i really hope you can help me!

i am creating a Data Base and i prepared a form to record all the invoices i receive into the INVOICE tab.
Since 3 fields as SUPPLIER, DATE, INVOICE NUMBER must be copied many times i am trying to set the form so when i click on the button ""NEW ENTRY" the previous entry will be copied to the new one, applying just to these three fields i told you.



Could you explain me how does it work?

thanx

[Rainlover]

Marg

You don't do it that way.

Have you read up on Normalisation.

You need a Main form that hold the data you talked about then a sub form that is linked via a Key.

Google Normalisation or if you prefer Normalization.

[Sarina]

I wanted the category for each record to reproduce the last entry that was made in the category for the previous record. This is how I did it.

In the events tab: After Update: Select Event Procedure:

Private Sub Category_AfterUpdate()
Me!Category.DefaultValue = """" & Me!Category & """"
End Sub

[RuralGuy]

As Rain stated, your tables appear to not be normalized. You can do it the way you are doing it but it will cause you quite a bit of grief in the future trying to get the right data back out of the system. You should really read up on normalization as he suggested before you get too far into the project and data entry.

[jbarrum]

Marc,

The concern by RG and Rainlover is that you are duplicating invoices numbers. An invoice number is typically unique so why would you want to do that?