P
Phil
Dim db As DAO.Database
Dim List50 As DAO.Recordset
Dim NextNoteID As Long
Dim SQLSTR As String
Dim The_Item_ID As Long
Set db = CurrentDb()
Set List50 = db.OpenRecordset("Retire lowercased Items List",
dbOpenSnapshot)
Do While Not List50.EOF
The_Item_ID = ??????????????
OK, the query (Retire lowercase Items List) contains a field called
item_ID. I want to assign the value of item_ID from the current record
to The_Item_ID. I am missing something, not sure what.
Thanx
Dim List50 As DAO.Recordset
Dim NextNoteID As Long
Dim SQLSTR As String
Dim The_Item_ID As Long
Set db = CurrentDb()
Set List50 = db.OpenRecordset("Retire lowercased Items List",
dbOpenSnapshot)
Do While Not List50.EOF
The_Item_ID = ??????????????
OK, the query (Retire lowercase Items List) contains a field called
item_ID. I want to assign the value of item_ID from the current record
to The_Item_ID. I am missing something, not sure what.
Thanx