Michael Paravicini
asked on
How to access a cell in Datasheet in VBA Access
ASKER
Thank you but the problem is that I'm using a filter and hence ME.Dates gets me only the first record in the table but not the first record displayed in the mask after applying the filter.....
You should select this record (you can do it with code also) and then Me.Dates will give you value from selected record
ASKER
Sorry not sure how to select the first record of the active datasheet (without having going thru the trouble to use RecordSet etc).?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you so much - this has been unbelievable helpful! Cheers Michael
In code of your button you can use Me.DATES to get value from selected (in picture it is first) record