Results 1 to 1 of 1
  1. #1
    Join Date
    Mar 2012

    Unanswered: dlookup in a subform based on a value in main form??

    Just cant quite get this to work. Attached is a pic of the form w/ subform.
    When a job number is entered an automatic ticket number is created. That information then populates the sub form. "jid" on the sub form has a default value of
    I need the Tax Status to lookup the taxstatus from another table. I placed an after update in the jid field, but since the jid is not being updated and only being set as a default the code is not running. Ive also tried setting the default value of Tax Status to
    =dlookup([taxstatus], "jobs", "[jid]=" & me.jobnumber)
    Could someone give me an idea of what im doing wrong or offer some suggestions?

    Attached Thumbnails Attached Thumbnails job ticket.bmp  

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts