We have a table (tblLabels) open in datasheet view.
One of the columns in the table is LABID.
We are trying to store the value of LABID in the first rec of the table in the variable strID.
Code:DoCmd.OpenTable "tblLabels" DoCmd.GoToRecord acTable, "tblLabels", acFirst strID = LABID
The value of LABID is empty in the VBA code.
How can we store the value of a field in a table in a variable in VBA code?