<div>
There are no &quot;cells&quot; in Access, there are records. You can get value from selected record by name of field (column)<br />
In code of your button you can use Me.DATES to get value from selected (in picture it is first) record
</div>


<div>
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.....
</div>


<div>
You should select this record (you can do it with code also) and then Me.Dates will give you value from selected record
</div>


<div>
Sorry not sure how to select the first record of the active datasheet (without having going thru the trouble to use RecordSet etc).?
</div>


Q28929353.accdb

<div>
Thank you so much - this has been unbelievable helpful! &nbsp; &nbsp;Cheers Michael
</div>


<div>
<div class="content wysiwyg-content">
I have a form with a subform which displays a datasheet. This datasheet has a DATES column and I need to pass the first row data (in this case 28 of Feb 2016 &nbsp;as a parameter in the button SEGURO HOY. No clue on how to address this cell and to pass it on in the click event. <br />
Thank you for any help... <a href="https://filedb.experts-exchange.com/incoming/2016/02_w09/1083719/Screen.jpeg" target="_blank" title="Screen.jpeg (193 KB)"><img alt="Screen.jpeg" class="file-block lazyload" style="max-width: 742px;" data-src="https://filedb.experts-exchange.com/incoming/2016/02_w09/1083719/Screen.jpeg" /></a>
</div>
</div>


Screen.jpeg

I have a form with a subform which displays a datasheet. This datasheet has a DATES column and I need to pass the first row data (in this case 28 of Feb 2016  as a parameter in the button SEGURO HOY. No clue on how to address this cell and to pass it on in the click event. 
Thank you for any help... 

How to access a cell in Datasheet in VBA Access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.