Default Fields

H

HARI TJAHJO

I have a problem here, please help me ....
i have a form which enter some data. when i enter date (i.e : doc date =
01/08/2003) i want that date is still showing in next new record, not
cleared.
 
H

Hugh O'Neill

HARI said:
I have a problem here, please help me ....
i have a form which enter some data. when i enter date (i.e : doc
date = 01/08/2003) i want that date is still showing in next new
record, not cleared.

Put the following code in the After Update event of the text box
control where you want the data repeated:

Private Sub txtName_AfterUpdate()

Me![txtName].DefaultValue = """" & Me![txtName].Value & """"

End Sub

where 'txtName' is the name of your text box control. There are four
double-quote marks at each end!

hth

Hugh
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top