I have a sub form that uses a getval("PTR") function as a parameter ... my test data has 3 records id'd as 1, 2 and 3 ... the getval returns 1 2 or 3 to the sub form.
Select TTID, TTData from test where TTID = getval("PRT");
When I set ginPTR (LONG) to 1, 2 or 3 from the immediate window and run the Query it works for each value ... when I run the Form with the subquery and put a breakpoint in the subform load event (set one line in event as debug.print) only the value 1 returns any records and or trips the on load event 2 and 3 don't even trip the load event almost like the Form thinks nothing needs to be loaded???
Can anyone possibly explain what is happening here ... Access 2003 ... been pulling my hair out on this all afternoon
Select TTID, TTData from test where TTID = getval("PRT");
When I set ginPTR (LONG) to 1, 2 or 3 from the immediate window and run the Query it works for each value ... when I run the Form with the subquery and put a breakpoint in the subform load event (set one line in event as debug.print) only the value 1 returns any records and or trips the on load event 2 and 3 don't even trip the load event almost like the Form thinks nothing needs to be loaded???
Can anyone possibly explain what is happening here ... Access 2003 ... been pulling my hair out on this all afternoon