Anyone know how to store a specific row of a specific field in a VBA var?
I can point to an entire field but not just the one row with this i believe.
But how do I specify the row as well? Does this just make an array with each row?
Why not do it the hard way?
Dim rst As Recordset
Set rst=CurrentDb.OpenRecordset("SELECT YourTableField FROM YourTableName WHERE (you fill in the criteria here)", dbOpenDynaset)
(check first for presence of data to avoid a possible error message)
YourVBAVariableName = !YourTableField
You can put this code in the form's OnCurrent section.