Open New Form on Update

[Julie966]

I have a large DB that lists contracts and I want to be able to keep all the
contracts that are currently entered. I have a field that when a date is
entered it opens a new form to update the data.

I am really GREEN at writing code and using the fields associated with
making this work.

What I need is for this new form to copy the primary data from the original
form, such as name, state, etc., and then I want to create a unique ID that
uses part of the "auto number" ID from the original form.

Am I asking too much? Can anyone help me?

 

[Jeff C]

Remember that your form is nothing but a window into the dataset (table or
query) you are working with. The second (new) form you refer to is not going
to copy anything. It can display any information that is in the table or
query it is using as the record source.

It sounds like what you may want is a second table using an autonumber as
the primary key and a number long integer field that will hold the autonumber
for each record of the first table, making a basic one to many relationship
between the two.

Other than doing searches in this forum, which willcertainly give you all
the answers you need, try picking up a reference book on Access and that will
help you. I still refer to Access For Dummies (you know the bright yellow
book). It is a good basic reference.