Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Simple Forms Question

Status
Not open for further replies.

hapajapa0218

Technical User
Jul 5, 2003
3
US
I would like to have a form that displays a single record at a time, and when the user modifies any field then clicks the save button, record the modification to a file on disk.. I currently am using this:

Private Sub txt_homephone_BeforeUpdate(Cancel As Integer)

DoCmd.OutputTo acOutputForm, Main_Form, acFormatTXT, "a:Output.txt", True

End Sub

But each time it prints all records to the file.. all I want is the record (or even field) that was modified.

Thanks.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top