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

Keep form from adding new record in table

P: 3
I have a simple DB that calculates number of hours to use as a lookup for license requirements. It consists of an EmployeeInfo table and a calculation query to generate the hours based on workload proportions. I have a form to enter an employeeID and it runs the calculations fine. However, if you enter an employeeID that doesn't exist on that form, it creates a new entry in the EmployeeInfo table. I have tried adjusting the form properties to not allow for editing the table, but I haven't found the right place to dis-allow edits from the form or query.
3 Weeks Ago #1

✓ answered by ADezii

It adds the New Record because the Record Source for the Form is HrCalcQry and the Control Source for the Text Box Employee_TBD is the [EmployeeID] Field in HrCalcQry. Since this Form is only used for Calculation purposes, it need not be Bound and neither does the Text Box. See the Upload for reference.

Share this Question
Share on Google+
3 Replies


P: 3
I have attached a copy of the DB for reference
Attached Files
File Type: zip LicenseCalculator.zip (162.9 KB, 4 views)
3 Weeks Ago #2

ADezii
Expert 5K+
P: 8,627
It adds the New Record because the Record Source for the Form is HrCalcQry and the Control Source for the Text Box Employee_TBD is the [EmployeeID] Field in HrCalcQry. Since this Form is only used for Calculation purposes, it need not be Bound and neither does the Text Box. See the Upload for reference.
Attached Files
File Type: zip LicenseCalculator_Revised.zip (147.5 KB, 3 views)
3 Weeks Ago #3

P: 3
Thank you for your assistance. I figured it had to be something along those lines. I was too far in the weeds!
3 Weeks Ago #4

Post your reply

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