ACCESS newb needs help with Refrencing a prevous record.

[kaim]

Hello all,



I am new to the forum and new to access with a question. I am working with access 2010 and am having an issue citing a previous record. heres the rundown.

These records will be used to keep up with maintnance on our shop floor.

If i have an open issue and i want to continue between multiple shifs i would like to be able to have each shift manager creat a new record and for report purposes i would like to be able to track between the different shifts.

I have a unique number for each entry and i would like to be able to put something in the form if its a continuation of the prevous shift to mark that unique number...

Any help would be appricated,

Kai M.

[ranman256]

previous record is relative, depending on your sort. if sorted by AUTONUM then yes, you can. [id] and [id]-1, but if your sort is anything else, no.

since any given record cannot see what is next to it, then you can only do it with code.

dim vName, vName2
dim rst

set rst = currentdb.openrecordset("qsMyQuery")
with rst
  while not .eof
      vName = .fields("Name").value
   
     .movenext    'get next record in list


         'NOW YOU CAN SEE THE NEXT RECORD
      vName2 = .fields("Name").value 
   wend
end with
set rst = nothing

[kaim]

previous record is relative, depending on your sort. if sorted by AUTONUM then yes, you can. [id] and [id]-1, but if your sort is anything else, no.

since any given record cannot see what is next to it, then you can only do it with code.

dim vName, vName2
dim rst

set rst = currentdb.openrecordset("qsMyQuery")
with rst
  while not .eof
      vName = .fields("Name").value
   
     .movenext    'get next record in list


         'NOW YOU CAN SEE THE NEXT RECORD
      vName2 = .fields("Name").value 
   wend
end with
set rst = nothing

The only issue i have with this is it may not be the last record its going to be some record in prevous... It will have approx 12 people adding to this form at at any given time. so it may be the very last in the database or it may be 3-5 entrys up... Any way to do this?

[June7]

Review http://allenbrowne.com/subquery-01.html#AnotherRecord