locked
trying to use Dlookup to get last record value RRS feed

  • Question

  • i am trying to assign the value from a combo box in a form as a variable using dlookup..... it works fine for the first record but am unable to get it to look at the last. i have tried to use a query but then get the null field at the end of the table


    Thanks in advance
    Greg
    Thursday, November 19, 2009 12:13 AM

Answers

  • Thanks for reply I have found the answer
    • Marked as answer by Greg Levet Sunday, November 22, 2009 10:02 PM
    Sunday, November 22, 2009 10:02 PM

All replies

  • i am trying to assign the value from a combo box in a form as a variable using dlookup..... it works fine for the first record but am unable to get it to look at the last. i have tried to use a query but then get the null field at the end of the table


    Thanks in advance
    Greg

    can you post your code here please?
    Don't judge me, just Upgrade me. Thanks!
    Sunday, November 22, 2009 9:41 PM
  • Thanks for reply I have found the answer
    • Marked as answer by Greg Levet Sunday, November 22, 2009 10:02 PM
    Sunday, November 22, 2009 10:02 PM