|
||||||
|
Multi-Table Forms By Richard Rost ![]() ![]() Editing Records in Multi-Table Forms in Access In this video, we're going to discuss the best way to edit data in a form that is based on fields from multiple tables. Lina from St. Petersburg, Florida (a Platinum Member) asks: I've got a form based on a query with 4 different tables in it. It seems like whenever I make changes to one of the fields, strange things happen. Sometimes I can't add a new record. Sometimes I get an error message. Sometimes I think I'm editing one field and I end up changing 3 other things. What am I doing wrong? MembersMembers will see how to safely allow the user to edit fields in a form based on multiple tables by warning the user and asking if they're sure. We'll also see how to quickly open up another form to edit related data.
Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!
|
Learn MoreFREE Access Beginner Level 1 Free TemplatesTechHelp Free Templates |
ResourcesDiamond Sponsors - Information on our Sponsors Questions?Please feel free to post your questions or comments below or post them in the Forums. |
access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, microsoft access form based on multiple tables, Multiple Table Forms in Microsoft Access, How do you Create a form based on multiple tables in Access, subform, locked, Forms Involving Multiple Tables
| |||
Keywords: TechHelp Access microsoft access form based on multiple tables, Multiple Table Forms in Microsoft Access, How do you Create a form based on multiple tables in Access, subform, locked, Forms Involving Multiple Tables PermaLink Multi-Table Forms in Microsoft Access |