Hey,

I have a table printers and a table pc's. I have a many to many
relationship, so I made an extra table printerpc.

I now have a form that gives info about a printer. I want to open a new
window that show all the pc's this printer is installed on.

How do I do this? When I make a query, I can type a hard coded value. For
instance show all pc's where printerid equals pr1. But I want the printerid
in the query to be the id of the printer currently showed in the loaded
form.

Hope this makes any sense...

Any help is welcome,
Oswald

Oswald:
Easy.
Assume your form is named printerform.
Assume the field on the form is named printerid.

In the query, in the criteria box for the printer put:

forms!printerform!printerid.

That will do it.

Note:

The form must open when you run the query!!!!!
If your form or field has spaces in the name then:
forms![printer form]![printer id]

Some people always use the [] even if they don't need it.

Good Luck
Ira Solomon

On Sat, 7 Feb 2004 22:34:23 +0100, "Oswald" <fluffster71 (AT) hotmail (DOT) com>
wrote:

Hello,

thank you very much, it works now!

Oswald

"Ira Solomon" <isolomon (AT) solomonltd (DOT) com> wrote