Determining where Queries are used 1

[FoxProProgrammer]

Hi,

Is there a way to list the Form(s) that Queries are used on?

Thanks!

dz

 

[Remou]

You can loop through the forms collection and check the RecordSource. You may need to check comboboxes and listboxes, too.

 

[FoxProProgrammer]

Thanks, Remou. That's a good idea. I was hoping that Access had something built in, but it's easy enough to write a program to check the RecordSource of the Form and controls.

dz

 

[MichaelRed]

take a careful look at the MSysQueries and MSysObjects (System) Tables.




MichaelRed