extra unwanted record entry from linked form/subform operation

[DM]

I am having this trouble in Access 2007 and 2002 SP3


I had a sign in roster with an input form that was macro driven. When our
office upgraded from 03 to 07 some of the macros no longer work. I have no
clue when it comes to building macros. I can, however, create one to do a
similar operation to another form/report by using an existing one as a
guide.

So, with the upgrade and needing our databases to work with no time to learn
how to fix them properly, I used brute force and ignorance to delete the
corrupt macros.

Now, our goal is to open a data entry form, put the class name and
instructor name into two main fields and then students can sign in and hit a
command button titled submit (new record function) so the next student can
sign in. All of this with the instructor and course field being populated to
all respective records.


What we have and what the problem is:
I built a form based on the roster table and inserted the two fields
(instructor/course).
I inserted a subform with the student info and the two main fields and
linked the subform to the main form.
during test, i found that after opening the form (data entry=yes) and
putting the course name and instructor in the fields, everything appears
correct. The respective fields in the subform update and even so when the
student puts their info in and hits the submit button and so on and so on.
Only after I closed the form and checked the table to see how everything is
working, I noticed the first record has the course and instructor but no
student info. The rest of the fields were fully populated and all students
are accounted for.
My investigation shows that it happens as soon as I select either the course
or instructor or both it populates the extra field. Then when one goes from
the main form and starts entering the student info it starts a new record
set. I found this by only entering a course with all other fields un-touched
and closing the form to check the table.


My frustrations? I have done this many times for other office data base
functions and never had the extra record entry. Now I am trying it in both
2007 and 2002 in blank, test databases which are resulting the same way.
What am I over looking as I have become complacent or what am I doing that I
shouldn't be doing?

Much appreciation to anyone that can help.

 

[DM]

Thanks, that makes since on what I found out this morning (separate tables
for each form). I created a table for courses with a primary key and a table
for students linked to the course table by the key.

I guess I tried to keep it too simple.


Now I know how keys and indexing works.

 

[DM]

just as much fun as helping!

I'll tell ya, learning all the new little niceities of 07 is even better.

Learning is fun isn't it?

Thanks, that makes since on what I found out this morning (separate tables
for each form). I created a table for courses with a primary key and a
table
for students linked to the course table by the key.

I guess I tried to keep it too simple.

Now I know how keys and indexing works.

AFAIK when the record is Dirty, Access has *always* saved the current
record

[quoted text clipped - 56 lines]

Much appreciation to anyone that can help.

--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com