Please Please Help!

M

marko

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
 
T

Tom Wickerath

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
__________________________________________

:

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
 
T

Tom Wickerath

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
__________________________________________
 
M

marko

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
 
P

pietlinden

'******** 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.
 
Top