SubForm on Click event

[raffi]

hello, i have a SubReport where it has technician name Field and Item name Field and a Quantity Field



basically it represents which Technicians has taken what items and how much, its 3 fields 1 record

i have a formula on the technician ID Field on click event where if i click on ID of technician, it would open up detailed info at which dates this particular technician has received or given all items.

heres the formula.

if Not IsNull([TechniciansID])
 openReport
       ReportName: "the other detailed report here" <-- which has both the Technician ID and Item ID in it
              View: Report
     Filter Name: 
Where Condition: ="[TechniciansID]=" & [TechniciansID]
   Window Mode:Dialog

ok now what im looking for is a way to look at a particular Technician with a particular item

like, once clicked upon Technician ID i would see, This technician, and This Item in my other detailed report

the purpose of this is so i could measure each technicians activity with 1 item only.

[pbaldy]

Along the lines of

"[TechniciansID]=" & [TechniciansID] & " And ItemID = " & [ItemID]

[raffi]

when i click on the ID field it prompts "Type missmatch" =l hmmm,

[pbaldy]

If a field is text it requires delimiters:

http://www.baldyweb.com/wherecondition.htm

[raffi]

umm im extreamly sorry it is a text field cuz im still working on the tables of the items since every Machine has its own List of items and their so many so sorry yes its a text field manually set atm but thx very much for the site

[raffi]

nvm but thx for the help i'd rather create a table and write items names there and go back to the combo-box and re-write it

[pbaldy]

I wasn't suggesting you change the data, but the code.

[raffi]

its ok i created a table and i set in the "[TechniciansID]=" & [TechniciansID] & " And ItemID = " & [ItemID] and it works

now i have item table and technicians table the only downside is for every new item i have to go and create it in the item form and really its not taking much time doing that plus the bright side im actually creating my items table slowly, over time it will be complete while im actually doing transactions and providing technicians with items. thx for the help its all good

[pbaldy]

Glad you got it sorted out.