I doubt you need to be concerned with the form's Current Record property.And I don't see why you should need a command button for "Has been Completed" and another for "Has not been Completed".There is of course an ID for the job (Just not shown, no need to be visible), but how would I access this to perform an operation on it?SQL I can do, integrating with Access/VBA I am new at As I understand your situation, your form is data-bound bound (you can get record index), so - your form already located on this record.This article does not explain how to create a form or a report.For help creating forms and reports, see the articles Roadmap to creating a form and Create a simple report.If you need to update some field of underlying dataset, you can write something like If your form has control bound to "Some Field", then the form will be updated automatically.If this will not help, you can look to a couple of another directions: 1) Update records using SQL code.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
Is there a way to have that code look at whether or not that checkbox has a check in it and if it does to run that code in the query?
If the checkbox is not checked that code would not be run and no limits would be placed on that field. This query will not update anything in the data itself and the form is connected to a database of our data.
I have a job-tracking system, and there is a query that returns results of all jobs that are overdue. Execute str SQL2, db Fail On Error End Sub is completely incorrect, I believe this is what I need to figure out?
I have a form that displays each of these jobs one-by-one, and has two buttons (Job has been completed, and Job not completed). I cannot find a way to get access to the current record to update it's contents if the "Has been Completed" button is pressed, the closest I can get is the long number which represents the records position in the form. This is called on button-press I am posting an image which shows the form (non-continuous).