Hi Rich

Once again thanks for your efforts with this.

I worked through you logical steps and still surprisingly drew a blank.  Then I discovered the actual problem - the code didn't...

Hi again Rich

Thanks so much for your help here.  I'm reading reams of stuff - but am getting more and more bogged down - really surprising!

I went through all scenarios...

Hi Rich

I tried all types: nchar, nvarchar datetime etc.  No go, I'm afraid.  I also tried in the Inputparameters:

 ? char = '4/05'

and

? char = '04/05'

It put up a standard...

Hi Rich

Thanks again for your reply. 

I have managed to get the subform working and synchronised using you undocumented trick.  I added another parameter to the sp and passed the...

I forgot to mention that if I make the Recordsource:

select * from tblstuext where academicyear='04/05'

it works fine......

Paul

Hi Rich

Thanks for a great answer.  Your completeness really helps.

I have worked through the field types and variables to ensure there is no problem here (all now Char(5)), but I...

Thanks, Rich

This flies in the face of everything I have been reading - but thankfully it works!  And I was beginning to thing it never would...

Can I ask a further...

Thanks Noel

In the InputParameters property I tried:

@cy varchar=[Forms]![frmAcYear]![AcYear]

and it gives the error message:

'procedure sp_students_team expects parameter CY, which was not supplied'

I tried a different form and field for...

Thanks, Erik

I much appreciate your concurrence with the comments of Remi and Rich.  It makes me quite certain that I'm doing the right thing.

Paul

OK.  I think that these comments have fully clarified the issue.  I will make the big effort to move directly to adp.

I really appreciate your help and apologise for what...

Thanks again for coming back - and I am conscious that this should all be in a new thread but.....

After reading all of your comments, I have decided to take...

Okay, I see - I'm sure it will all make sense eventually...

Many thanks for all your help in this.

Best wishes

Paul

If I hold fire on re-usability for a while and just ask when I should close a recordset (or close the connection) to prevent wasting server resources - it is...

Thanks, Remi

I think you will see a lot more posts under my name before I get it properly sorted out.

Just a couple of points - though maybe I should put this...

Hi Remi

I'm struggling to make much sense of this.  So, we have bought some software to test the bandwidth of the server under different conditions.  I hope this will help.

However,...