Please Please Help!

marko

unread,

Sep 4, 2005, 4:27:34 PM9/4/05

to

I would like to fill out a form containing let's say 3 fields and then
when i go to the next record. Now the next record would be blank except
the last field wich would have the value of that same field from the
last record. How can i do that?
Some People from the group answered my question,they told me to use VBA
but i don't know how! :( Can enyone help me? There is a topic about my
problem on this web page http://support.microsoft.com/?id=210236. It
says that i have to create a module so i create it with that code in
STEP 3 but what then? In STEP 5 it says that i have to change the
OnCurrent property. So i go to the form,click design view,properties
and change the OnCurrent property and make that text box and so on...
But it wont work!
Please help!
Is there some other easier way? I'm a beginner so can someone help me?
Thanks,

Marko

pietl...@hotmail.com

unread,

Sep 4, 2005, 4:35:41 PM9/4/05

to

check www.mvps.org/access

look up "carry" and that'll give you an example

marko

unread,

Sep 4, 2005, 4:39:00 PM9/4/05

to

Thanks! But i don't know how to use this code! Can u please help me?

Marko

AT @comcastdotnet Tom Wickerath

unread,

Sep 4, 2005, 4:39:03 PM9/4/05

to

Hi Marko,

Since I am the one who provided the earlier answer pointing you to KB
210236, I will volunteer to help you out if you are willing to send me a
compacted (and preferably zipped) copy of your database.

If my answer has helped you, please answer yes to the question that reads
"Did this post answer the question?" at the bottom of the message thread.

Tom

QWaos168@XScom cast. Dnet (<--Remove all capitalized letters and spaces).
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

marko

unread,

Sep 4, 2005, 4:41:59 PM9/4/05

to

I'll send it to you! just a sec! :))
Thanks!

marko

unread,

Sep 4, 2005, 4:42:32 PM9/4/05

to

marko

unread,

Sep 4, 2005, 4:46:26 PM9/4/05

to

I have sent you an email! Will you please confirm me that you have
received it?

AT @comcastdotnet Tom Wickerath

unread,

Sep 4, 2005, 4:44:01 PM9/4/05

to

Disregard the part of my answer that read:

"If my answer has helped you, please answer yes to the question that reads
Did this post answer the question?" at the bottom of the message thread."

since you did not use the Microsoft web portal to post your question....

Tom
__________________________________________

marko

unread,

Sep 4, 2005, 4:49:08 PM9/4/05

to

I didn't understand you, my english is very bad,
what do you want me to do?
I would be very happy if you could help me!

Marko

pietl...@hotmail.com

unread,

Sep 4, 2005, 6:24:48 PM9/4/05

to

'******** Code Start **********
const cQuote="""" 'Thats two quotes
me!Control.DefaultValue = cQuote & me!Control.Value & cQuote
'******** Code End **********

you put the code behind a button... then you can make setting the
defaults optional.

marko

unread,

Sep 10, 2005, 5:17:33 PM9/10/05

to

Thanks!!

Marko