How shall i go about this??? 1

[din2005]

Hi all i have continuous form. It has an order number e.g
0012312345. This order number has files in certain location "Z:\StockSystem\CopyOrders" which are saved in the format 0012312345.msg

is there anyway in the continuous form have a checkbox to show whether each order number has a file associated to it. Whats the best practice to this?

 

[Remou]

I think I would use a query and a function to create the File Exists column. Perhaps something like:

Function FileExists(FName)
strPath = "Z:\StockSystem\CopyOrders"
strFile = Dir(strPath & FName & ".msg")
If strFile <> "" Then
    FileExists = True
Else
    FileExists = False
End If
End Function

The query would have a column showing, say:
[tt]File Exists: FileExists([OrderNumber])[/tt]