Popup Input Box

[Drum2001]

Is there a way to have an input box "Pop-up" on a form to capture
information? I do not want to create another form for this.

I was thinking something similar to queries when you have the criteria
= [Enter Date] and it auto generates a textbox with "Enter Date" as the
caption.

Thank you!

[Rick Wannall]

dim s as string
s = InputBox(prompt, title, default)

You'll find InputBox in Access help.

[Drum2001]

Rick Wannall wrote:

dim s as string
s = InputBox(prompt, title, default)

You'll find InputBox in Access help.

Thank you for the start.

Is there a way to bind this "input" to a field in a table?

[Rick Wannall]

No. YOu can bind a control on a form or a report. Or you can include a
field in a query. But you cannot bind a field to a command.

You can SET the field:

Me.txt = InputBox(p, t, d)

But that's not usually advisable. You ought normally to test the outcome
before you do the assigning to a bound field.

Dim s As String
s = InputBox("myprompt", "mytitle", "mydefault")

Select Case s
Case ""
MsgBox "You either hit ESCAPE or entered nothing"
Exit Sub
Case "Bob", "Judy", "Teddy"
MsgBox "Hi, " & s & "."
Exit Sub
Case "123", "456", "789"
Me.txtMyCode = s
RunCommand acCmdSaveRecord
Exit Sub
Case Else
MsgBox "You entered '" & s & "'. I don't know what to do about
that."
End Select