How do I select a value from a field in an ACCESS unbound datasheet? My unbound datasheet displays the following fields: JobID, JobStartDate, JobEndDate, JobAddress. When a row/record is selected in the datasheet, I want to put the value of the JobID field in a variable.
I found the following code below, but it only provides the current records position/location in the datasheet (i.e. 1, 2, 3, etc..)
Dim i As Integer
i = Me.dataDisplaySubform.Form.CurrentRecord
Is it possible to do what I need? How? Please provide examples.
Thank you all very much in advance,