Hi! First post here; I've read through gobs of material and cannot find my
answer.
I'd like to do something similar to the original poster in this ad, and
cannot figure it out. I'm an intermediate (at best) Access user.
I have two forms, one for personal info entry and one that uses that same
personal info at the top and then has some fields below it for exam scores.
Both are built off of the same table. I want to be able to
1. Create a new form (got that!), then
2. Type information into it (OK there too!), then
3. Click a button on my form to be taken to the other form to enter exam
data. The personal information would be there.
I do not want to just do it all in one form, as the personal data on the
second form (with the exam scores) is locked against editing. This means
that when you reaccess the second form, other seven users cannot
inadvertently change the student's information.
I was doing great, I thought. I had the macro built so that I could easily
go back and forth between forms, simply by accessing the ID number of the
student and navigating to that same ID number. It all fell apart, though,
when I tried to do it from the last record. It kept telling me that "You
can't go to the specified record. You may be at the end of a recordset." I
understand that Access does not really use record numbers (it uses Dynaset),
so I figure the answer lies in bookmarking that record and then calling up
the same record (since it's accessing the same table, that record will be in
the same place at the time).
So, the 10 million dollar question is...how do I do it? Can I use the
me.bookmark function somehow in the macro building experience without having
to write code? If I do need to do actual code, how to I access that? I'm
sorry if this is a somewhat scattered explanation. I'm pretty new to Access.
Thanks in advance if anyone can help! Happy Halloween!
Melody
