Access 97 and VBA (reply)
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