Novice
Windows 10 
Access 2016
I'm trying to add a textbox to a form that I can edit on each record. I'd like to add descriptive notes about each individual beer, but I don't have a field in my table for these notes. Is this possible?
As of now if I edit anything in one record it's the same message in all records. Thanks!
Who is John Galt?
Windows XP Access 2007
As you've found, if it isn't bound to a field in the table, the data isn't saved with each record. You need a field in the table to save the notes for each record.
Novice
Windows 10 Access 2016
Frustrating but understood. Thanks for the help!
Who is John Galt?
Windows XP Access 2007
No problem. If you think about it, the only way Access can save the data when you close the program is to save it to a table. Information on the form in an unbound textbox can't be related to a particular record, and is lost when the form closes.
Welcome to the site by the way!
How do you move the data in one textbox to another textbox in a different form?
Form Textbox fed values from another textbox but not added to table as a recordset?
Posting Permissions
Reply With Quote