Forms Help Please!

[Scott_66701]

I have 5 forms which I have continuing from one to another using buttons. I
have the buttons set to open the new form when clicked. When I try to save
the database however, the forms wont' save cause it says the primary key
isn't inputed. I put a value in the primary key textbox on form 1 but how
can I get the value to continue through the other forms so when I save the
database all the forms will save together into one record.

 

[Mike Painter]

I have 5 forms which I have continuing from one to another using
buttons. I have the buttons set to open the new form when clicked.
When I try to save the database however, the forms wont' save cause
it says the primary key isn't inputed. I put a value in the primary
key textbox on form 1 but how can I get the value to continue through
the other forms so when I save the database all the forms will save
together into one record.

Why do you have five forms if they all contain data from one record?
A tabbed form will solve all your problems.

Since they all deal with teh same record you can use OpenArgs to pass the
key to the next form and load the record into that.
If th forms stay open you will probably have to trap error messages when you
go to close one or more of them.

 

[Scott_66701]

I have 5 different tables...thats why I have 5 forms. Am I able to use
tabbed form with 5 tables? Sorry, I don't know much about access. Thanks

I have 5 forms which I have continuing from one to another using
buttons. I have the buttons set to open the new form when clicked.

[quoted text clipped - 3 lines]

the other forms so when I save the database all the forms will save
together into one record.

Why do you have five forms if they all contain data from one record?
A tabbed form will solve all your problems.

Since they all deal with teh same record you can use OpenArgs to pass the
key to the next form and load the record into that.
If th forms stay open you will probably have to trap error messages when you
go to close one or more of them.

 

[John W. Vinson]

I have 5 different tables...thats why I have 5 forms. Am I able to use
tabbed form with 5 tables?

How are the tables related? If there is a "master" table and four "child"
tables you could use a Form with four Subforms; it's convenient to put those
four subforms on tab pages, especially if they're large.

If the concept of tables being related isn't clear, you might need to read up
a bit on relational database design; here's some good sources -

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

Roger Carlson's tutorials, samples and tips:
http://www.rogersaccesslibrary.com/

A free tutorial written by Crystal:
http://allenbrowne.com/casu-22.html

A video how-to series by Crystal:
http://www.YouTube.com/user/LearnAccessByCrystal

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

 

[Mike Painter]

If you need to have the same key in all o them then thre is a relationship
and your forms should be built on a query joining these tables.
I'd suggest telling us what you want to do and reading the help file that
explains a bit about relational databases.

I have 5 different tables...thats why I have 5 forms. Am I able to
use tabbed form with 5 tables? Sorry, I don't know much about
access. Thanks

I have 5 forms which I have continuing from one to another using
buttons. I have the buttons set to open the new form when clicked.

[quoted text clipped - 3 lines]

the other forms so when I save the database all the forms will save
together into one record.

Why do you have five forms if they all contain data from one record?
A tabbed form will solve all your problems.

Since they all deal with teh same record you can use OpenArgs to
pass the key to the next form and load the record into that.
If th forms stay open you will probably have to trap error messages
when you go to close one or more of them.