How can I set up a command button to ask for input to change the default value of a text box in a form?

Question

First, I'd like to say that I am 98% self taught so I'll freely admit that I may be a little dense when it come to some things here.

So here we go. What I am trying to do is to change the default value using a command button, since I am just writing the database and others will be using it. So I am doing my best to idiot-proof the database. Here is the code I am using:

Forms!frmMainentry!txtStation.DefaultValue = """?"""

Where the ? is, is where I need to be able to change the default value. To give you an idea why, at our facility we have 7 assembly lines, each line has 5 to 8 work stations, each work station has 2 to 15 racks of parts. Most of these were set up to quickly and have been changed and moved around to the point that people have a hard time finding stuff. This database is just meant to be a short term fix until the engineers decide to fix things.

So far, my form works as intended. Once this is working, I can go on to the easy stuff. LOL Since I have been working on this button for more than 3 days, ANY help you can give will be GREATLY appreciated.

Answer 1

Something like:

Forms!frmMainentry!txtStation.DefaultValue = Chr(34) & Me!InputTextbox.Value & Chr(34)