Pass Account Number from a user form

E

Eric

This query works fine but i want to pass the AccountNum from a
parameterize userform where user enters AccountNum and then pass it
into query. How to i do that needs help

Form Name:Frm_AccountNum

Enter AccountNum:


SELECT ti.CORP, tbl_ValidDisputes.LstVldTech, ti.TECH, ti.TECHCONT,
tpr1.AccountNum, tbl_Events.txt
FROM tbl_ValidDisputes INNER JOIN (([select tpr.*,
Mid(tpr.AccountNum,1,5) as tprCORP from tbl_PPVResearch as tpr]. AS
tpr1

INNER JOIN tech_id AS ti ON tpr1.tprCORP = ti.CORP) INNER JOIN
tbl_Events ON tpr1.TicketNum = tbl_Events.TicketNum) ON

tbl_ValidDisputes.LstVldTech = ti.TECH
WHERE
(((nz([tpr1].[FS_TechID3],nz([tpr1].[FS_TechID2],[tpr1].[FS_TechID1])))=[ti].[TECH]));

Thanks,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top