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