Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Write a macro to update a field on a form
Thanks, Lameid. I have done as you suggested BUT the query updates more than the one record. Do I need to set criteria in the update query to restrict the update to the item being hired, and what code do I write for this? Do I put the code in the criteria of the query or in the macro to run the...- jodiehbk
- Post #3
- Forum: Microsoft: Access Other topics
-
Write a macro to update a field on a form
I have a form on a table listing items available for hire. One field holds the number of each item available. I have a linked and synchronized form to manage the loans and another to manage the returns. I would like to write a macro attached to a command button on the loans form to decrease the...- jodiehbk
- Thread
- Replies: 3
- Forum: Microsoft: Access Other topics
