I have two forms.
1. Query form- has two fields, address and street.
2. Primary form- has many fields, including an address and street field.

I currently use the Query form to query the Primary form. If there is a
match it opens to that record. If there is no match, it gives the user a
message, "there is not match, would you like to add a new record?" with yes
and no buttons.

What I would like it to do is -if there is no match- copy the text/value
entered in the Query form and paste it in the corresponding fields in the
Primary form after the person clicks yes on the message box.

Your assistance is greatly appreciated.

Are these 2 forms on the same page? If not, you will need to pass the values
via a URL, using Javascript document.location = url, or via server-side
scripting.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Everybody picks their nose,
But some people are better at hiding it.

"hsdaguilar" <(E-Mail Removed)> wrote in message
news:9BE3E6AF-0859-43C3-AE8D-(E-Mail Removed)...
>I have two forms.
> 1. Query form- has two fields, address and street.
> 2. Primary form- has many fields, including an address and street field.
>
> I currently use the Query form to query the Primary form. If there is a
> match it opens to that record. If there is no match, it gives the user a
> message, "there is not match, would you like to add a new record?" with
> yes
> and no buttons.
>
> What I would like it to do is -if there is no match- copy the text/value
> entered in the Query form and paste it in the corresponding fields in the
> Primary form after the person clicks yes on the message box.
>
> Your assistance is greatly appreciated.
>

It is not for a page, it is for a regular form, used for data entry.

"Kevin Spencer" wrote:

> Are these 2 forms on the same page? If not, you will need to pass the values
> via a URL, using Javascript document.location = url, or via server-side
> scripting.
>
> --
> HTH,
>
> Kevin Spencer
> Microsoft MVP
> ..Net Developer
> Everybody picks their nose,
> But some people are better at hiding it.
>
> "hsdaguilar" <(E-Mail Removed)> wrote in message
> news:9BE3E6AF-0859-43C3-AE8D-(E-Mail Removed)...
> >I have two forms.
> > 1. Query form- has two fields, address and street.
> > 2. Primary form- has many fields, including an address and street field.
> >
> > I currently use the Query form to query the Primary form. If there is a
> > match it opens to that record. If there is no match, it gives the user a
> > message, "there is not match, would you like to add a new record?" with
> > yes
> > and no buttons.
> >
> > What I would like it to do is -if there is no match- copy the text/value
> > entered in the Query form and paste it in the corresponding fields in the
> > Primary form after the person clicks yes on the message box.
> >
> > Your assistance is greatly appreciated.
> >
>
>
>

Are you sure you want to be in the FrontPage NG, as opposed
to an Access NG

"hsdaguilar" <(E-Mail Removed)> wrote in
message
news:E94198BF-32F2-4350-988B-(E-Mail Removed)...
: It is not for a page, it is for a regular form, used for
data entry.
:
: "Kevin Spencer" wrote:
:
: > Are these 2 forms on the same page? If not, you will
need to pass the values
: > via a URL, using Javascript document.location = url, or
via server-side
: > scripting.
: >
: > --
: > HTH,
: >
: > Kevin Spencer
: > Microsoft MVP
: > ..Net Developer
: > Everybody picks their nose,
: > But some people are better at hiding it.
: >
: > "hsdaguilar" <(E-Mail Removed)>
wrote in message
: >
news:9BE3E6AF-0859-43C3-AE8D-(E-Mail Removed)...
: > >I have two forms.
: > > 1. Query form- has two fields, address and street.
: > > 2. Primary form- has many fields, including an address
and street field.
: > >
: > > I currently use the Query form to query the Primary
form. If there is a
: > > match it opens to that record. If there is no match,
it gives the user a
: > > message, "there is not match, would you like to add a
new record?" with
: > > yes
: > > and no buttons.
: > >
: > > What I would like it to do is -if there is no match-
copy the text/value
: > > entered in the Query form and paste it in the
corresponding fields in the
: > > Primary form after the person clicks yes on the
message box.
: > >
: > > Your assistance is greatly appreciated.
: > >
: >
: >
: >

I'm sorry. Posted on the wron NG. Thx.

"Mike Mueller" wrote:

> Are you sure you want to be in the FrontPage NG, as opposed
> to an Access NG
>
> "hsdaguilar" <(E-Mail Removed)> wrote in
> message
> news:E94198BF-32F2-4350-988B-(E-Mail Removed)...
> : It is not for a page, it is for a regular form, used for
> data entry.
> :
> : "Kevin Spencer" wrote:
> :
> : > Are these 2 forms on the same page? If not, you will
> need to pass the values
> : > via a URL, using Javascript document.location = url, or
> via server-side
> : > scripting.
> : >
> : > --
> : > HTH,
> : >
> : > Kevin Spencer
> : > Microsoft MVP
> : > ..Net Developer
> : > Everybody picks their nose,
> : > But some people are better at hiding it.
> : >
> : > "hsdaguilar" <(E-Mail Removed)>
> wrote in message
> : >
> news:9BE3E6AF-0859-43C3-AE8D-(E-Mail Removed)...
> : > >I have two forms.
> : > > 1. Query form- has two fields, address and street.
> : > > 2. Primary form- has many fields, including an address
> and street field.
> : > >
> : > > I currently use the Query form to query the Primary
> form. If there is a
> : > > match it opens to that record. If there is no match,
> it gives the user a
> : > > message, "there is not match, would you like to add a
> new record?" with
> : > > yes
> : > > and no buttons.
> : > >
> : > > What I would like it to do is -if there is no match-
> copy the text/value
> : > > entered in the Query form and paste it in the
> corresponding fields in the
> : > > Primary form after the person clicks yes on the
> message box.
> : > >
> : > > Your assistance is greatly appreciated.
> : > >
> : >
> : >
> : >
>
>
>