Search results

By this information FORM![TrainingDash21]![txtTraineeID] I understand that you are trying to retrieve the value from a text box to use this in your criteria, try to save the value in an actual field from a table instead and then use the field in your criteria. Also use a Macro with saveRecord...

You need to create an update query using the date selected as criteria, and selecting just the fields you need to update. That way only the records that match the criteria will be updated

Hello my name is Javier, I am from Bogotá, Colombia. I have been using Access for about 20 years, developing applications for many businesses. I have also good knowledge of VBA but prefer to do everything with Access tools and only use VBA when there is no other option available to do a process.