prompt value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
I have a form based on a select query which prompts user for code when opening
can i assign its value to say a string mycode ?
Thanks
Tina
 
Tina, if the prompt is supposed to end up in the string mycode, try the
following:

dim myCode as string

myCode = InputBox("Please enter code.", "Inputbox Title")

You can then use the string value in the query or where ever else. Is that
what you were looking for?

Lance
 
Back
Top