Showing Query Results on a Form

[caringsharingbristolbilly]

Hello chaps and chicks.

I'm a bit of a relative newbie to Access still, so please speak to me like a baby if you have any answers.

My problem is this:

Scenario - I have a number of tables for client data errors created on 4 different systems by a number of different departments. Upon opening the database, users are greeted by a form to select their department.

Having selected their department, the MAIN MENU opens up with 4 buttons which open up each system's set of data errors they've created. A form filters only the errors created by the department the user has selected at this point.

What I want to do - I want, on MAIN MENU form, to show how many errors that department has on that system next to the relevant button, so users can see which ones apply to their department. I have set up a query to count this, and if I create a form wizard form off that, it works fine. The minute I try and copy it onto the MAIN MENU form, I get the "#Name?" error show in the box.

Any help would be hysterically appreciated, because the silly microsoft paper cat is being no help, and I'm about to combust.

Caring Sharing Bristol Billy Bob

PS. I should point out Visual Basic is still a complete mystery to me!

 

[caringsharingbristolbilly]

Rats. Wouldn't let me edit my post any more.

Would this have anything to do with my query? The text box I've created to display the results of the query should be showing a COUNT function in the query.

http://support.microsoft.com/default.aspx?scid=kb;en-us;95442&Product=acc97

 

[SydneyGeek]

OK, let's say you have MyQuery with SomeResult. You want SomeResult to show on the Menu form -- and SomeResult is the only item in the query (a typical, single-item Totals query).

Try this...

In the Menu, place an unbound Textbox. The ControlSource should be
=[MyQuery]![SomeResult]

If instead the resuslt is on a form, that will be...
=[Forms]![MyForm]![SomeResult]

If it's in a report it becomes...
=[Reports]![MyReport]![SomeResult]

HTH
Denis

 

[caringsharingbristolbilly]

Thanks for your help! That worked, in conjunction with running the query forms in the background. I think my assumption that the ControlSource would automatically run the query was the problem.

Never assume anything, it makes an *** out of u and me, right?

Live and learn, eh? Thanks for your help!