How do I bookmark currently displayed form's record to copy

When I bring up a form, how do I bookmark the currently displayed record so
it can be repeated for a new record when the form is opened again?

"When I bring up a form, how do I bookmark the currently displayed record so
it can be repeated for a new record when the form is opened again?"

I think you need to explain what you're trying to do in a little more detail.
What you're saying above, basically, is that you want to copy the data in the
first record of your form, so that when you close the form and then re-open
it, you can place this data in a new record.

As written, it really doesn't make a lot of sense.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via http://www.accessmonster.com

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


"Linq Adams via AccessMonster.com" wrote:

"When I bring up a form, how do I bookmark the currently displayed record so
it can be repeated for a new record when the form is opened again?"

I think you need to explain what you're trying to do in a little more detail.
What you're saying above, basically, is that you want to copy the data in the
first record of your form, so that when you close the form and then re-open
it, you can place this data in a new record.

As written, it really doesn't make a lot of sense.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via http://www.accessmonster.com