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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SUB Form not loading

Status
Not open for further replies.

oscarse

Programmer
Apr 9, 2006
99
CA
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
 
Arggg

Note to SELF

CHECK THE SUBFORM's LINKFIELD's especially when using custom Queries

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top