Pass query parameters from Form to crosstab

[rodmc]

thats just weird!

not your comment, but I had it in form view and was giving it dates and it just kept saying blah blah not recognised, and as soon as you posted it works for you, hey presto it works.

I think I need t go away and lie down

 

[boblarson]

It works for me. I don't think you had the form open. When I say open, I mean the form must be in Form view, not design view with the Start and End Dates entered.

The query that frmParaForm1 was opening wasn't referring to the right form, it was still referring to frmParaForm and not frmParaForm1.

 

[boblarson]

Check it out now (open frmParaForm1).

 

[rodmc]

You know bob, I have a vague recollection of messing with that not so long ago

 

[rodmc]

thanks guys, saved from insanity again

 

[vbaInet]

The query that frmParaForm1 was opening wasn't referring to the right form, it was still referring to frmParaForm and not frmParaForm1.

I went straight to the query and opened up the form that was mentioned in the query which was frmParaForm, so I was certainly using the right form. I didn't even try opening the query via the form nor did I notice there was a frmParaForm1

 

[boblarson]

I went straight to the query and opened up the form that was mentioned in the query which was frmParaForm, so I was certainly using the right form.

However, the code for the button would open a DIFFERENT query on frmParaForm which was ListActivity1. So, opening the query by itself was one thing but doing it from the button was completely something else. Then I saw that Discharged1 was being called by frmParaForm1 and that query was still referring to frmParaForm.

So, that is what was going on.

rodmc:

(By the way, I think it best if you have ONE parameters form and use the appropriate controls for each item (you can hide some if necessary) and then refer to the appropriate controls in whichever query so you don't get all messed up in which form is being used for what.

 

[rodmc]

A bad habit of mine, if i get it working in one way shape or form (excuse the pun) rather than continue modifying that form I create a new form similarly named and make the new changes to that. Like a paper trail, albeit in my case a very messy one!

I'll need to cut that out in future.