Access 2007 user input to drive opening a new form
Posted on 2013-01-24
I have a start Form that has a button on it that will open up another form.
The code that is on this button that opens the second form is below. This code works perfect. My question is I need this button to ask the user a question after it has been clicked and place the users typed answer into a text field on the new form that it is opening.
It need to ask… “what Is todays letter” and the user will type in l or g or z .. (a letter) any ways.. how can I ask this question after clicking the button and placing this result in “text24” of the new form that is being opened?
Private Sub Command20_Click()
On Error GoTo Err_Command20_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "Input_Form_with_Drop_down_box"
DoCmd.OpenForm stDocName, , , stLinkCriteria