By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,730 Members | 1,659 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,730 IT Pros & Developers. It's quick & easy.

Can I update multiple fields in a record on a table using a form?

P: 2
Hello! Help please! I am trying to create a user friendly database for use with our construction company. I am trying to create a form (which seems to be the most user friendly) that pulls existing records and updates fields on the table based on the record found. See below...

ID - (Auto numbered - identifies the existing record)
Field 1 - Step 1 - Search existing records using this field.
Field 2 - Step 2 - Auto populates based on the existing record. If duplicate Field 1's are found, there will be a drop down to select the correct record by the text in Field 2.
Field 3 to Field 8 - Step 3 - All these fields auto populate based on selected record from Steps 1 & 2 in order to update the record. If no data exists, use the form to add data and update existing record.
2 Weeks Ago #1
Share this Question
Share on Google+
2 Replies

P: 2
Maybe this will help?

Attached Images
File Type: jpg FORM.jpg (100.6 KB, 18 views)
2 Weeks Ago #2

Expert Mod 15k+
P: 31,606
Hi ConstructionGirl.

This seems very much like you're jumping into something with the idea it should be easy. Easy is relative. You need a fair degree of grounding in the subject before you can start making it move beyond the basics.

Cascaded Form Filtering will help. You will need this understanding so I hope you are ready for it.

Once you've identified the record, or the specification of the record if it doesn't exist yet, then a fairly basic bound form should handle the rest for you. You may decide you want to make changes beyond the very basic defaults but I strongly urge you to get the basics working first before attempting to move beyond that.

Good luck with your project.
2 Weeks Ago #3

Post your reply

Sign in to post your reply or Sign up for a free account.