Open Form with data source as custom query via VBA

[ghadley_00]

Hi,

I have an MS access database form that during creation of a new entry
checks to see if that entry already exists in a table (using code
triggered as part of the afterupdate event).

At present a message box is triggered, however, I would like to have a
second form open with it's data source being a query for all the
records that have the matching field (e.g. Name).

Is there a way to open an existing form and define its data source via
VBA?

Thanks,

George Hadley
gh********@yahoo.com

[Wayne Gillespie]

On 19 Mar 2006 05:45:15 -0800, gh********@yahoo.com wrote:

Hi,

I have an MS access database form that during creation of a new entry
checks to see if that entry already exists in a table (using code
triggered as part of the afterupdate event).

At present a message box is triggered, however, I would like to have a
second form open with it's data source being a query for all the
records that have the matching field (e.g. Name).

Is there a way to open an existing form and define its data source via
VBA?

Thanks,

George Hadley
gh********@yahoo.com

DoCmd.OpenForm "frmMyForm"
Forms!frmMyForm.RecordSource = "qryMyQuery"
Wayne Gillespie
Gosford NSW Australia

[Tom van Stiphout]

On 19 Mar 2006 05:45:15 -0800, gh********@yahoo.com wrote:

Yes. Study "DoCmd.OpenForm" in the help file. You'll find a
WhereClause argument that you can set to your criteria, e.g.
"PersonID=" & Me.PersonID

-Tom.

Hi,

I have an MS access database form that during creation of a new entry
checks to see if that entry already exists in a table (using code
triggered as part of the afterupdate event).

At present a message box is triggered, however, I would like to have a
second form open with it's data source being a query for all the
records that have the matching field (e.g. Name).

Is there a way to open an existing form and define its data source via
VBA?

Thanks,

George Hadley
gh********@yahoo.com