Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

multiple key matches on forms call

Status
Not open for further replies.

etcrier

Programmer
Sep 20, 2006
60
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top