Access VBA: How do I display a field value?

Set rst = CurrentDb.OpenRecordset(“Parms”)
EOW = rst.EOWDate
Me.CurrentStatus = “EOW Date set to ” & EOW & vbcrlf

rst is simply a name to hold your recordset where you are opening the table Parms
EOW is simply a name to hold the field you are querying

By | 2017-12-01T23:47:51+00:00 April 12th, 2011|Access, Computers, Documentation, Microsoft, VBA|0 Comments