I have a problem in an updatable form I have created. I hope I can explain the issue clearly.
The detail section of the form is populated by a view I have created containing the following fields:
Selected <--a checkbox set to all 0s
Car# <--the name of the vehicle(ex: #319, #256, #4)
PO# <--purchase order number
NoticeID <--# of PO line item
ShipDate <--date the vehicle left the warehouse
Material <--material being shipped
Complete? <--a Boolean field; hidden from form; filter is set up so only incomplete records are visible
When the user opens the form, all incomplete notices are listed. Based on the process, PO and Notice IDs come in several weeks before a shipment and are imported into the database right away. The day after a vehicle is shipped, an email is sent to the plant listing the ShipDate.
I want users to be able to enter the ShipDate in a text field at the top, select the Selected checkbox for multiple cars and hit an Update button which will run an update query setting the entered ShipDate. It’s working fine except for one thing. When I go through and select the records I want to update, each time I select a new checkbox I initially see an icon of a pencil next to the checkbox. If I use the mouse to click the pencil, the icon changes to a pointing arrowhead to indicate the entire record has been selected.
But here’s the thing..if I leave the pencil icon on the last selected record and do not manually change the icon to the arrowhead or move the cursor to another idle record, all records update except for the one I last updated that still shows the pencil icon. Is there a line of code I can enter to lock down the last change I made?
The detail section of the form is populated by a view I have created containing the following fields:
Selected <--a checkbox set to all 0s
Car# <--the name of the vehicle(ex: #319, #256, #4)
PO# <--purchase order number
NoticeID <--# of PO line item
ShipDate <--date the vehicle left the warehouse
Material <--material being shipped
Complete? <--a Boolean field; hidden from form; filter is set up so only incomplete records are visible
When the user opens the form, all incomplete notices are listed. Based on the process, PO and Notice IDs come in several weeks before a shipment and are imported into the database right away. The day after a vehicle is shipped, an email is sent to the plant listing the ShipDate.
I want users to be able to enter the ShipDate in a text field at the top, select the Selected checkbox for multiple cars and hit an Update button which will run an update query setting the entered ShipDate. It’s working fine except for one thing. When I go through and select the records I want to update, each time I select a new checkbox I initially see an icon of a pencil next to the checkbox. If I use the mouse to click the pencil, the icon changes to a pointing arrowhead to indicate the entire record has been selected.
But here’s the thing..if I leave the pencil icon on the last selected record and do not manually change the icon to the arrowhead or move the cursor to another idle record, all records update except for the one I last updated that still shows the pencil icon. Is there a line of code I can enter to lock down the last change I made?
