Creating a parameter in a macro

[cwindoma]

Hi all...

Does anyone know how to create a parameter in a macro (Access 2007)?

I'm using the SetValue action with an argument of...

Item [Intro_Call_Date]
Expression =[Please enter the date of the call.]

So, I need it to prompt a user to enter the date of the call.

Any ideas?
-Cindy

 

[alvechurchdata]

Try:

InputBox("Please enter the date of the call","Call Date")

as the expression.

Geoff Franklin

http://www.alvechurchdata.co.uk