Agnes,
Why is it a silly idea? The fact is he is multiple tables to pull data into a single form using lots of relationships... I think I have experience similar steps because cursor set in Foxpro is tricky, doing stuff like that, i prefer to create my own cursor then echo the stuff into the elements. Also what do you mean by preloaded? you mean in the designer view, the control source for element is set to something or the formA which calls form B already cue the SQL into the fields? I look everywhere, there is nothing... :( poor me~~~ hahhaa
Thanx
Tom