Setting data defaults programmatically

J

Jim Kennedy

Hi,
Instead of changing the default value of the table, I
would focus on the form. Here's one way I did this. I
added a command button next to the text box I wanted to
set the default value and added this code:

Private Sub cmdAccession_Click()
Dim strDefault As String

strDefault = Chr(34) & Me.Accession & Chr(34)

Me.Accession.DefaultValue = strDefault

End Sub
 

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

Similar Threads

Prompt for LastName 8
IsText? 8
Word macro that can call cells out of Excel for a find and replace 0
How to Set More than One Table Default Values from a Form 0
filtering a form based on the values of a subform 0
Why wont the Wildcard * work in this? 1
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Word VBA - Delete text from bulleted paragraphs 1

Top