Setting a default value for a field on a form

[Darlene]

I have a form for which I would like to prompt the user for a default field value each time the form is opened. For this application the "project ID" will be the same for the entire day. I'd like to prompt them when the form opens and have that field value be the default until the form is closed. I know I can put a prompt on the query which populates the form, but I don't want it filtered to that value - I just want that value as the default for new records.



I am a very light Access user so if you have the patience to really spell this out for me I would greatly appreciate it.

How can I do that? Thanks.

[June7]

Need VBA code, probably in form Open event. One approach to try:

Me.textboxname.DefaultValue = InputBox("Enter default value.")

Review
http://office.microsoft.com/en-us/ac...010341717.aspx

[Darlene]

Thank you so much for the quick response! I put in the code, I get the nice prompt, but when I add a record that field displays #Name? as shown below. I'm sorry I am a very beginner. Do I need to add something to the default value field within the field's properties also or should that vb code take care of it. Thank you.

[Darlene]

Actually, I figured it out. Once I entered the value in quotes it worked. Is there a way to force the quotes into a person's entry so the user doesn't have to enter them?

[June7]

Try:

Me.textboxname.DefaultValue = """" & InputBox("Enter default value.") & """"

[Darlene]

You are my new best friend !! I found that the ending concatenate & was missing - but added it and it works wonderful. Thanks a million.

[June7]

Ooops! Glad you caught it. And I edited the post.