InputBox function

[Loree]

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])

 

[Steve Schapel]

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.