subforms and tab page folders

[allison]

Let's see if I can make this make sense... I have three forms
(contacts, events and payment info). I want to have my contacts form
with a tab folder. the first page will be my event form and the second
my payment history. The forms are set up that one contact might have 10
events that they have done. Everything seems to be working fine. I can
get all events for one contact and the payment info to go with it. But
when I go to close it out, it won't let me save it. so everytime I want
to go out and come back into it, My contact form hasn't any subforms or
tabs. Is this possible to do or does access not allow it? Can anyone
help me with this. I would like to have a way to display all forms at
once so you can enter info to them at once as well. Thanks for any help
you can give me.

 

[strive4peace]

Hi Allison,

if you are allocating space for up to 10 events instead of using a
parent/child relationship between tables that would create events
records only if there is a need ... then your database needs to be
normalized.

"it won't let me save it"

chances are that you are using a RecordSource for the form that is not
updateable ... it is best to set up a different form/subform for each
table you will enter data into

btw, tab controls have nothing to do with relationships, they merely
provide a convenient way to organize your form...

to help you understand Access a bit better, send me an email and request
my 30-page Word document on Access Basics (for Programming) -- it
doesn't cover VBA, but prepares you for it because it covers essentials
in Access.

Be sure to put "Access Basics" in the subject line so that I see your
message...

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*

 

[allison]

Thank you so much for writing me back. I am just trying to find the
easiest way for my co-workers to find and enter information. I have
emailed you to request the info you were talking about. Greatly
appreciate any help I can get. Having a lot of problems getting
everything to read as I would like. By the way, I am not leaving space
for 10 events. Just an example. If I click on the event part of the
form it will scroll through all the events that that one contact did.
Could be one -- could be a hundred. All my tables are linked properly
(i hope).
Thanks again,
Allison

 

[strive4peace]

you're welcome, Allison

I have sent the document

Just guessing ... the problem is probably that the RecordSource for your
form uses more than one table -- don't do this. Make a seperate
form/subform for each table you will enter information into.

Are you using LinkMasterFields and LinkChildFields to relate the main
and subform(s)? If you are not, then THIS could be the problem...

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*