VBA, Set Variable = Field Value

Set Variable = Field Value

Author	Message
Douglas M. Bake #1 / 2	Set Variable = Field Value I want to set a variable to be equal to a record ID number so that I can retrieve it in a different form. This is a piece of my code, when I debug, I can see the correct value of the RecordID, but it's value does not get assigned to my lngRecEdit variable. Do you know what I am doing wrong? Thanks! Static lngRecEdit as Variant Set db = CurrentDb() Set rec = db.OpenRecordset(strSQL) lngRecEdit = rec![RecordID].Value
Wed, 11 Sep 2002 03:00:00 GMT

Edwin Kell #2 / 2	Set Variable = Field Value Take the .Value off Assuming the name of the text box is RecordID, you do not need the .Value parameter to store the value in a variable. Quote: > I want to set a variable to be equal to a record ID number so that I can > retrieve it in a different form. This is a piece of my code, when I debug, > I can see the correct value of the RecordID, but it's value does not get > assigned to my lngRecEdit variable. Do you know what I am doing wrong? > Thanks! > Static lngRecEdit as Variant > Set db = CurrentDb() > Set rec = db.OpenRecordset(strSQL) > lngRecEdit = rec![RecordID].Value
Wed, 11 Sep 2002 03:00:00 GMT

Page 1 of 1

[ 2 post ]