I have a data entry form for a job. there is also a sub form (continious) of all the work on that job as individual entries. once they enter a transaction i need to call another form that displays the customer and the selected transaction. The button wizard only gives you a single field from calling form to called form for a match.
I need a transaction key match also from calling subform to the called form. the called form is actually a formatted Job ticket with one transaction from the calling subform that they print. how do I add a second set of key fields to compare so I get the right transaction on the called form.
stDocName = "CHGTICKET"
stLinkCriteria = "[jid]=" & "'" & Me![jid] & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria
I need a second set of tests for the actual detail transaction on selected on the subform. [jid] is the main job key.
its obvious i do not know VB
thanks
david
I need a transaction key match also from calling subform to the called form. the called form is actually a formatted Job ticket with one transaction from the calling subform that they print. how do I add a second set of key fields to compare so I get the right transaction on the called form.
stDocName = "CHGTICKET"
stLinkCriteria = "[jid]=" & "'" & Me![jid] & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria
I need a second set of tests for the actual detail transaction on selected on the subform. [jid] is the main job key.
its obvious i do not know VB
thanks
david