Hi, I'm a french student so pardon my english!
In a report VBA sheet I used flag like that :
'set flag textbox as value of table and catch null value by Nz
flagconp = Nz(DLookup("[CONP]", "Temp_Bom", "[Temp2ID]=" & Report_Main_Report.idn), 0)
flagblup = Nz(DLookup("[BLUP]", "Temp_Bom", "[Temp2ID]=" & Report_Main_Report.idn), 0)
In the design view of this previous report I needed to put one text box for one requirement (flagconp issthe flag for the control plan's requirement, etc)
to retrieve the definitions of the flags.
It's work but it's strange.
Someone told me to create a query but I don't know how program it because I'm a begginner. Could you help to program the query??
Thanks a lot.
In a report VBA sheet I used flag like that :
'set flag textbox as value of table and catch null value by Nz
flagconp = Nz(DLookup("[CONP]", "Temp_Bom", "[Temp2ID]=" & Report_Main_Report.idn), 0)
flagblup = Nz(DLookup("[BLUP]", "Temp_Bom", "[Temp2ID]=" & Report_Main_Report.idn), 0)
In the design view of this previous report I needed to put one text box for one requirement (flagconp issthe flag for the control plan's requirement, etc)
to retrieve the definitions of the flags.
It's work but it's strange.
Someone told me to create a query but I don't know how program it because I'm a begginner. Could you help to program the query??
Thanks a lot.
