>Hello All,
>
>Can anyone please tell me why this error message is occurring?
>
> File 'c:\genesis\wilco1\histview.dbf' does not exist.
>
>I have the following code to open the view named [Histview] in the click event of a button on a form. When I click the button the code is failing on the "Use History" line. I agree it should be simple bit I'm missing something.
>
> If Used("histview")
> select histview
> Browse
> else
> Use histview
> select histview
> Browse
> Endif
> Use
It doesn't know it's a view, untill you tell it. You either have to Open Database {dbc name here}, or Use dbcname!histview - otherwise it will be looking for histview.dbf. Also, make sure the dbc can be found along the VFP path.