InputBox function

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

Guest

I am trying to add the inputbox function to an existing macro.

ie. enter date
company
contact, etc.

I have tried using the string provided in help but keep getting errors. I used to be able to do this several years ago but apparently I'm doing something wrong now as I'm getting Compile Error Expected: list seperator or ) when using
InputBox(Enter Date,[DATE])
 
Loree,

The Message and Title arguments of the InputBox function need to be
specified as strings, i.e. enclosed in ""s. For example...
InputBox("Enter date","Date")

I am not sure what the reason for the []s around the word DATE in the
expression you gave in your example... but if it indicates that you have
a field or contro named DATE, then I would advise against this, as this
is a reserved word (has a special meaning) in Access.
 
Back
Top