Thank You so much With your help I'm slowly begining to get to grips with this have now got all subforms showing when they are ment to.

One other thing I can't seem to get working atm on one of the forms I use a Insert statement, but I can't get it to insert into the row of the form I am editing.

i.e it inserts into the next row. I know it needs a Insert into where in php I would use this INSERT INTO CLIENT WHERE id =$id clientclass values(1);

but not sure how to reference variables in vb here is what I have...
JD