Micheal,

To retrieve the value of a form field simply use the Me!fieldName syntax in the form module. eg. varMyVariable = Me!txtSomeField

You can also use the DoCmd.TransferText method to export data directly from a table to a variety of text formats. See 'TransferText' method in online help for more details.

Hope this helps,

Phill Kenny


On 1/22/99 2:50:33 AM, Michael Stolz wrote:
> I don't know how I can get the value of a filed from a table of the
> currently open Access-database.

I fact I want to get this value in a
> procedure (runs behind a form) for writing it to a external
> ASCI-file.

Can anybody help me?
Thanks

Kind Regards,
Michael Stolz