Naming files in VB produced through Access Queries

[Kevin Sprinkel]

You must refer explicitly to the Forms collection, either
by:

fname = "C:\" & Forms![options]!txtname & ".csv"

or, more compactly, by using Access defaults,

fname = "C:\" & Me!txtname & ".csv"

HTH

Best regards,

Kevin Sprinkel
Becker & Frondorf

-----Original Message-----
On the database I am creating, I have a report that will
be produced and then saved as a csv file.

I daclared the file name as such:

Dim fname As Stringfname = "C:\" & [options]!txtname & ".csv"
.