>Hi Sandi
>
>I hope you made your view like this...
>
>Create Sql View v_SomeView As Select * From SomeTable Where DateField = ?lcDateParameter.
>
>To run this view from the command window, just do this...
>
>use v_SomeView nodata
>lcDateParameter = date()
>=requery()
>
>HTH

Yes, I made it that way. I can do what you told me to - no problem. The problem is when I don't preset the parameter (lcDateParameter has not been defined). Then it pops up a dialog to enter the parameter and it is there that is doesn't like whatever I write. I am doing this because I need to for debugging purposes on a form. I want to enter it in the dialog, but can't get past the abiguous date error.

Sandi.