SERIAL PROBLEM

• • Reply

  15 years ago

  by funfair

  funfair

  , United States

  Joined 15 years ago

  I HAVE TWO TABLE ONE FOR EQUIPMENT AND OTHER FOR EQUIPMENTDETAIL
  EQUIPMENT
  EQUIPMENTID        EQUIPMENTNAME
  100001                      PIN
  100002                      RADIO
  100003                      PEN
  EQUIPMENTDETAIL
  EQUIPMENTID        TYPEID
  100001                      1
  100001                      2
  100001                      3
  100002                      1
  100002                      2
  100003                      1
  

  
  HOW CAN I DO IT BY PROGRAMMING I DOI TIN THIS WAY
  I PIT IT ON THE TYPEID IN THE EQUIPMENTDETAIL FORM
  TYPE_ID DEFAULT VALUE= nextEQUTYPE()
  

  
  Public Function nextEQUTYPE()
  

  
  nextEQUTYPE = DLookup("TYPEID", "EQUIPMENTDETAIL", "EQUIPMENTID=" & "[EQUIPMENTID]")
  If IsNull(nextEQUTYPE) Then
  nextEQUTYPE = "0001"
  Else
  nextEQUTYPE = DLookup("TYPEID", "EQUIPMENTDETAIL", "EQUIPMENTID=" & "[EQUIPMENTID]")
  End If
  End Function
  BUT IT ALWAY START WITH 1
  SO WHAT IS THE PROBLEM
  THANKS FOR HELPING

  Report abuse