Search results

I total novice at VBA I am trying to code a button to modify (the last) record in a subform list and then add a new record based on values in unrelated or unbound fields on the button form. The following code is based on the first of two YouTube tutorials (this bit on the edit) and looks like...

The actual format of code the did the job was: DateSerial(DatePart("yyyy",Date()),9,1) Excellent

I am trying to set a criteria field to look for >#01/09/[current year]# but every combination of Date() returns invalid value. Any clues?