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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Update Query in Vba format
MajP, Thank you for the response, however I'm a bit new at this (I mistakenly select 'Programmer' when should have selected 'TechnicalUser'), and don't know exactly how to resolve the issue. I simply need to update values within a subform, and limit the update to the subform alone. If there's...- JMan2Be
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Update Query in Vba format
Can someone please, please help! I'm trying to update records that are marked 'new' with an SQL update query on the subform (ONLY!); however I don't know how to limit the query to the subform only. It update everything. Here's what I've got so far. DoCmd.RunSQL "UPDATE tPEPFARAllotments " &...- JMan2Be
- Thread
- Replies: 3
- Forum: Microsoft: Access Modules (VBA Coding)
