When a user accesses the form where the data is displayed, how can i auto
submit a search value once the user views the form?

Best option is to create submit button, and let the user click it.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

"Jehuty" <(E-Mail Removed)> wrote in message
news:09E8167B-0525-4B6A-BD7D-(E-Mail Removed)...
> When a user accesses the form where the data is displayed, how can i auto
> submit a search value once the user views the form?

The reason i need the page to do an autosubmit is because the field database
criteria is set to equal the identity number. Thats why i would like the code
for it.

"Thomas A. Rowe" wrote:

> Best option is to create submit button, and let the user click it.
>
> --
> ==============================================
> Thomas A. Rowe (Microsoft MVP - FrontPage)
> WEBMASTER Resources(tm)
> http://www.ycoln-resources.com
> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
> ==============================================
> To assist you in getting the best answers for FrontPage support see:
> http://www.net-sites.com/sitebuilder/newsgroups.asp
>
> "Jehuty" <(E-Mail Removed)> wrote in message
> news:09E8167B-0525-4B6A-BD7D-(E-Mail Removed)...
> > When a user accesses the form where the data is displayed, how can i auto
> > submit a search value once the user views the form?
>
>
>

I am not sure that I am following what it is you are trying to accomplish.

If you auto submit from the page the user is viewing, then user will not see the page as the page
would submit as soon as the user clicks on it.

You can pass a lookup value to a page that will automatically query the database, via either a form
field or a querystring, is this what you want to accomplish?

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

"Jehuty" <(E-Mail Removed)> wrote in message
news:09F5440D-0D40-40BD-BA73-(E-Mail Removed)...
> The reason i need the page to do an autosubmit is because the field database
> criteria is set to equal the identity number. Thats why i would like the code
> for it.
>
> "Thomas A. Rowe" wrote:
>
>> Best option is to create submit button, and let the user click it.
>>
>> --
>> ==============================================
>> Thomas A. Rowe (Microsoft MVP - FrontPage)
>> WEBMASTER Resources(tm)
>> http://www.ycoln-resources.com
>> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
>> ==============================================
>> To assist you in getting the best answers for FrontPage support see:
>> http://www.net-sites.com/sitebuilder/newsgroups.asp
>>
>> "Jehuty" <(E-Mail Removed)> wrote in message
>> news:09E8167B-0525-4B6A-BD7D-(E-Mail Removed)...
>> > When a user accesses the form where the data is displayed, how can i auto
>> > submit a search value once the user views the form?
>>
>>
>>

Yes thats exactly what im trying to accomplish. How do i do so?

"Thomas A. Rowe" wrote:

> I am not sure that I am following what it is you are trying to accomplish.
>
> If you auto submit from the page the user is viewing, then user will not see the page as the page
> would submit as soon as the user clicks on it.
>
> You can pass a lookup value to a page that will automatically query the database, via either a form
> field or a querystring, is this what you want to accomplish?
>
> --
> ==============================================
> Thomas A. Rowe (Microsoft MVP - FrontPage)
> WEBMASTER Resources(tm)
> http://www.ycoln-resources.com
> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
> ==============================================
> To assist you in getting the best answers for FrontPage support see:
> http://www.net-sites.com/sitebuilder/newsgroups.asp
>
> "Jehuty" <(E-Mail Removed)> wrote in message
> news:09F5440D-0D40-40BD-BA73-(E-Mail Removed)...
> > The reason i need the page to do an autosubmit is because the field database
> > criteria is set to equal the identity number. Thats why i would like the code
> > for it.
> >
> > "Thomas A. Rowe" wrote:
> >
> >> Best option is to create submit button, and let the user click it.
> >>
> >> --
> >> ==============================================
> >> Thomas A. Rowe (Microsoft MVP - FrontPage)
> >> WEBMASTER Resources(tm)
> >> http://www.ycoln-resources.com
> >> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
> >> ==============================================
> >> To assist you in getting the best answers for FrontPage support see:
> >> http://www.net-sites.com/sitebuilder/newsgroups.asp
> >>
> >> "Jehuty" <(E-Mail Removed)> wrote in message
> >> news:09E8167B-0525-4B6A-BD7D-(E-Mail Removed)...
> >> > When a user accesses the form where the data is displayed, how can i auto
> >> > submit a search value once the user views the form?
> >>
> >>
> >>
>
>
>

Ok, give me the steps and methods up to where you want to query the database.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

"Jehuty" <(E-Mail Removed)> wrote in message
news:8E4C41B8-6FFB-4994-BC0B-(E-Mail Removed)...
> Yes thats exactly what im trying to accomplish. How do i do so?
>
> "Thomas A. Rowe" wrote:
>
>> I am not sure that I am following what it is you are trying to accomplish.
>>
>> If you auto submit from the page the user is viewing, then user will not see the page as the page
>> would submit as soon as the user clicks on it.
>>
>> You can pass a lookup value to a page that will automatically query the database, via either a
>> form
>> field or a querystring, is this what you want to accomplish?
>>
>> --
>> ==============================================
>> Thomas A. Rowe (Microsoft MVP - FrontPage)
>> WEBMASTER Resources(tm)
>> http://www.ycoln-resources.com
>> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
>> ==============================================
>> To assist you in getting the best answers for FrontPage support see:
>> http://www.net-sites.com/sitebuilder/newsgroups.asp
>>
>> "Jehuty" <(E-Mail Removed)> wrote in message
>> news:09F5440D-0D40-40BD-BA73-(E-Mail Removed)...
>> > The reason i need the page to do an autosubmit is because the field database
>> > criteria is set to equal the identity number. Thats why i would like the code
>> > for it.
>> >
>> > "Thomas A. Rowe" wrote:
>> >
>> >> Best option is to create submit button, and let the user click it.
>> >>
>> >> --
>> >> ==============================================
>> >> Thomas A. Rowe (Microsoft MVP - FrontPage)
>> >> WEBMASTER Resources(tm)
>> >> http://www.ycoln-resources.com
>> >> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
>> >> ==============================================
>> >> To assist you in getting the best answers for FrontPage support see:
>> >> http://www.net-sites.com/sitebuilder/newsgroups.asp
>> >>
>> >> "Jehuty" <(E-Mail Removed)> wrote in message
>> >> news:09E8167B-0525-4B6A-BD7D-(E-Mail Removed)...
>> >> > When a user accesses the form where the data is displayed, how can i auto
>> >> > submit a search value once the user views the form?
>> >>
>> >>
>> >>
>>
>>
>>

basically, when a user clicks on the link, it creates an ID

submission_form.asp?identity=<%=FP_FieldURL(fp_rs,"Key")%>

Then once its in the submission form, the ID is automatcially inserted into
the MapID textbox i have. (MapID is the name of the DBField as well) What im
trying to figure out is how to automatically send the value of the MapID to
bring up the results.




"Thomas A. Rowe" wrote:

> Ok, give me the steps and methods up to where you want to query the database.
>
> --
> ==============================================
> Thomas A. Rowe (Microsoft MVP - FrontPage)
> WEBMASTER Resources(tm)
> http://www.ycoln-resources.com
> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
> ==============================================
> To assist you in getting the best answers for FrontPage support see:
> http://www.net-sites.com/sitebuilder/newsgroups.asp
>
> "Jehuty" <(E-Mail Removed)> wrote in message
> news:8E4C41B8-6FFB-4994-BC0B-(E-Mail Removed)...
> > Yes thats exactly what im trying to accomplish. How do i do so?
> >
> > "Thomas A. Rowe" wrote:
> >
> >> I am not sure that I am following what it is you are trying to accomplish.
> >>
> >> If you auto submit from the page the user is viewing, then user will not see the page as the page
> >> would submit as soon as the user clicks on it.
> >>
> >> You can pass a lookup value to a page that will automatically query the database, via either a
> >> form
> >> field or a querystring, is this what you want to accomplish?
> >>
> >> --
> >> ==============================================
> >> Thomas A. Rowe (Microsoft MVP - FrontPage)
> >> WEBMASTER Resources(tm)
> >> http://www.ycoln-resources.com
> >> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
> >> ==============================================
> >> To assist you in getting the best answers for FrontPage support see:
> >> http://www.net-sites.com/sitebuilder/newsgroups.asp
> >>
> >> "Jehuty" <(E-Mail Removed)> wrote in message
> >> news:09F5440D-0D40-40BD-BA73-(E-Mail Removed)...
> >> > The reason i need the page to do an autosubmit is because the field database
> >> > criteria is set to equal the identity number. Thats why i would like the code
> >> > for it.
> >> >
> >> > "Thomas A. Rowe" wrote:
> >> >
> >> >> Best option is to create submit button, and let the user click it.
> >> >>
> >> >> --
> >> >> ==============================================
> >> >> Thomas A. Rowe (Microsoft MVP - FrontPage)
> >> >> WEBMASTER Resources(tm)
> >> >> http://www.ycoln-resources.com
> >> >> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
> >> >> ==============================================
> >> >> To assist you in getting the best answers for FrontPage support see:
> >> >> http://www.net-sites.com/sitebuilder/newsgroups.asp
> >> >>
> >> >> "Jehuty" <(E-Mail Removed)> wrote in message
> >> >> news:09E8167B-0525-4B6A-BD7D-(E-Mail Removed)...
> >> >> > When a user accesses the form where the data is displayed, how can i auto
> >> >> > submit a search value once the user views the form?
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>

Where do you want to display the results, on the Submission Page or a page after that?

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

"Jehuty" <(E-Mail Removed)> wrote in message
news:28CA78E0-34C2-40E5-9D2C-(E-Mail Removed)...
> basically, when a user clicks on the link, it creates an ID
>
> submission_form.asp?identity=<%=FP_FieldURL(fp_rs,"Key")%>
>
> Then once its in the submission form, the ID is automatcially inserted into
> the MapID textbox i have. (MapID is the name of the DBField as well) What im
> trying to figure out is how to automatically send the value of the MapID to
> bring up the results.
>
>
>
>
> "Thomas A. Rowe" wrote:
>
>> Ok, give me the steps and methods up to where you want to query the database.
>>
>> --
>> ==============================================
>> Thomas A. Rowe (Microsoft MVP - FrontPage)
>> WEBMASTER Resources(tm)
>> http://www.ycoln-resources.com
>> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
>> ==============================================
>> To assist you in getting the best answers for FrontPage support see:
>> http://www.net-sites.com/sitebuilder/newsgroups.asp
>>
>> "Jehuty" <(E-Mail Removed)> wrote in message
>> news:8E4C41B8-6FFB-4994-BC0B-(E-Mail Removed)...
>> > Yes thats exactly what im trying to accomplish. How do i do so?
>> >
>> > "Thomas A. Rowe" wrote:
>> >
>> >> I am not sure that I am following what it is you are trying to accomplish.
>> >>
>> >> If you auto submit from the page the user is viewing, then user will not see the page as the
>> >> page
>> >> would submit as soon as the user clicks on it.
>> >>
>> >> You can pass a lookup value to a page that will automatically query the database, via either a
>> >> form
>> >> field or a querystring, is this what you want to accomplish?
>> >>
>> >> --
>> >> ==============================================
>> >> Thomas A. Rowe (Microsoft MVP - FrontPage)
>> >> WEBMASTER Resources(tm)
>> >> http://www.ycoln-resources.com
>> >> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
>> >> ==============================================
>> >> To assist you in getting the best answers for FrontPage support see:
>> >> http://www.net-sites.com/sitebuilder/newsgroups.asp
>> >>
>> >> "Jehuty" <(E-Mail Removed)> wrote in message
>> >> news:09F5440D-0D40-40BD-BA73-(E-Mail Removed)...
>> >> > The reason i need the page to do an autosubmit is because the field database
>> >> > criteria is set to equal the identity number. Thats why i would like the code
>> >> > for it.
>> >> >
>> >> > "Thomas A. Rowe" wrote:
>> >> >
>> >> >> Best option is to create submit button, and let the user click it.
>> >> >>
>> >> >> --
>> >> >> ==============================================
>> >> >> Thomas A. Rowe (Microsoft MVP - FrontPage)
>> >> >> WEBMASTER Resources(tm)
>> >> >> http://www.ycoln-resources.com
>> >> >> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
>> >> >> ==============================================
>> >> >> To assist you in getting the best answers for FrontPage support see:
>> >> >> http://www.net-sites.com/sitebuilder/newsgroups.asp
>> >> >>
>> >> >> "Jehuty" <(E-Mail Removed)> wrote in message
>> >> >> news:09E8167B-0525-4B6A-BD7D-(E-Mail Removed)...
>> >> >> > When a user accesses the form where the data is displayed, how can i auto
>> >> >> > submit a search value once the user views the form?
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>
>>
>>

im sorry, i meant to say the Results page not the submission page
so it would be

results_page.asp?identity=<%=FP_FieldURL(fp_rs,"Key")%>


"Thomas A. Rowe" wrote:

> Where do you want to display the results, on the Submission Page or a page after that?
>
> --
> ==============================================
> Thomas A. Rowe (Microsoft MVP - FrontPage)
> WEBMASTER Resources(tm)
> http://www.ycoln-resources.com
> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
> ==============================================
> To assist you in getting the best answers for FrontPage support see:
> http://www.net-sites.com/sitebuilder/newsgroups.asp
>
> "Jehuty" <(E-Mail Removed)> wrote in message
> news:28CA78E0-34C2-40E5-9D2C-(E-Mail Removed)...
> > basically, when a user clicks on the link, it creates an ID
> >
> > submission_form.asp?identity=<%=FP_FieldURL(fp_rs,"Key")%>
> >
> > Then once its in the submission form, the ID is automatcially inserted into
> > the MapID textbox i have. (MapID is the name of the DBField as well) What im
> > trying to figure out is how to automatically send the value of the MapID to
> > bring up the results.
> >
> >
> >
> >
> > "Thomas A. Rowe" wrote:
> >
> >> Ok, give me the steps and methods up to where you want to query the database.
> >>
> >> --
> >> ==============================================
> >> Thomas A. Rowe (Microsoft MVP - FrontPage)
> >> WEBMASTER Resources(tm)
> >> http://www.ycoln-resources.com
> >> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
> >> ==============================================
> >> To assist you in getting the best answers for FrontPage support see:
> >> http://www.net-sites.com/sitebuilder/newsgroups.asp
> >>
> >> "Jehuty" <(E-Mail Removed)> wrote in message
> >> news:8E4C41B8-6FFB-4994-BC0B-(E-Mail Removed)...
> >> > Yes thats exactly what im trying to accomplish. How do i do so?
> >> >
> >> > "Thomas A. Rowe" wrote:
> >> >
> >> >> I am not sure that I am following what it is you are trying to accomplish.
> >> >>
> >> >> If you auto submit from the page the user is viewing, then user will not see the page as the
> >> >> page
> >> >> would submit as soon as the user clicks on it.
> >> >>
> >> >> You can pass a lookup value to a page that will automatically query the database, via either a
> >> >> form
> >> >> field or a querystring, is this what you want to accomplish?
> >> >>
> >> >> --
> >> >> ==============================================
> >> >> Thomas A. Rowe (Microsoft MVP - FrontPage)
> >> >> WEBMASTER Resources(tm)
> >> >> http://www.ycoln-resources.com
> >> >> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
> >> >> ==============================================
> >> >> To assist you in getting the best answers for FrontPage support see:
> >> >> http://www.net-sites.com/sitebuilder/newsgroups.asp
> >> >>
> >> >> "Jehuty" <(E-Mail Removed)> wrote in message
> >> >> news:09F5440D-0D40-40BD-BA73-(E-Mail Removed)...
> >> >> > The reason i need the page to do an autosubmit is because the field database
> >> >> > criteria is set to equal the identity number. Thats why i would like the code
> >> >> > for it.
> >> >> >
> >> >> > "Thomas A. Rowe" wrote:
> >> >> >
> >> >> >> Best option is to create submit button, and let the user click it.
> >> >> >>
> >> >> >> --
> >> >> >> ==============================================
> >> >> >> Thomas A. Rowe (Microsoft MVP - FrontPage)
> >> >> >> WEBMASTER Resources(tm)
> >> >> >> http://www.ycoln-resources.com
> >> >> >> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
> >> >> >> ==============================================
> >> >> >> To assist you in getting the best answers for FrontPage support see:
> >> >> >> http://www.net-sites.com/sitebuilder/newsgroups.asp
> >> >> >>
> >> >> >> "Jehuty" <(E-Mail Removed)> wrote in message
> >> >> >> news:09E8167B-0525-4B6A-BD7D-(E-Mail Removed)...
> >> >> >> > When a user accesses the form where the data is displayed, how can i auto
> >> >> >> > submit a search value once the user views the form?
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>

Ok, then do this on results_page.asp

<%
Dim MapID
MapID = Request.Form("MapID")

' In your query do this if the MapID is a text field in the database

"SELECT * FROM tablename WHERE MapID = '" & MapID & "' "

' If the MapID is a number field, then do this instead

"SELECT * FROM tablename WHERE MapID = " & MapID

You will need to write the other parts of the complete query function
%>
--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

"Jehuty" <(E-Mail Removed)> wrote in message
news:96067A21-B2F4-46D0-B848-(E-Mail Removed)...
> im sorry, i meant to say the Results page not the submission page
> so it would be
>
> results_page.asp?identity=<%=FP_FieldURL(fp_rs,"Key")%>
>
>
> "Thomas A. Rowe" wrote:
>
>> Where do you want to display the results, on the Submission Page or a page after that?
>>
>> --
>> ==============================================
>> Thomas A. Rowe (Microsoft MVP - FrontPage)
>> WEBMASTER Resources(tm)
>> http://www.ycoln-resources.com
>> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
>> ==============================================
>> To assist you in getting the best answers for FrontPage support see:
>> http://www.net-sites.com/sitebuilder/newsgroups.asp
>>
>> "Jehuty" <(E-Mail Removed)> wrote in message
>> news:28CA78E0-34C2-40E5-9D2C-(E-Mail Removed)...
>> > basically, when a user clicks on the link, it creates an ID
>> >
>> > submission_form.asp?identity=<%=FP_FieldURL(fp_rs,"Key")%>
>> >
>> > Then once its in the submission form, the ID is automatcially inserted into
>> > the MapID textbox i have. (MapID is the name of the DBField as well) What im
>> > trying to figure out is how to automatically send the value of the MapID to
>> > bring up the results.
>> >
>> >
>> >
>> >
>> > "Thomas A. Rowe" wrote:
>> >
>> >> Ok, give me the steps and methods up to where you want to query the database.
>> >>
>> >> --
>> >> ==============================================
>> >> Thomas A. Rowe (Microsoft MVP - FrontPage)
>> >> WEBMASTER Resources(tm)
>> >> http://www.ycoln-resources.com
>> >> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
>> >> ==============================================
>> >> To assist you in getting the best answers for FrontPage support see:
>> >> http://www.net-sites.com/sitebuilder/newsgroups.asp
>> >>
>> >> "Jehuty" <(E-Mail Removed)> wrote in message
>> >> news:8E4C41B8-6FFB-4994-BC0B-(E-Mail Removed)...
>> >> > Yes thats exactly what im trying to accomplish. How do i do so?
>> >> >
>> >> > "Thomas A. Rowe" wrote:
>> >> >
>> >> >> I am not sure that I am following what it is you are trying to accomplish.
>> >> >>
>> >> >> If you auto submit from the page the user is viewing, then user will not see the page as
>> >> >> the
>> >> >> page
>> >> >> would submit as soon as the user clicks on it.
>> >> >>
>> >> >> You can pass a lookup value to a page that will automatically query the database, via
>> >> >> either a
>> >> >> form
>> >> >> field or a querystring, is this what you want to accomplish?
>> >> >>
>> >> >> --
>> >> >> ==============================================
>> >> >> Thomas A. Rowe (Microsoft MVP - FrontPage)
>> >> >> WEBMASTER Resources(tm)
>> >> >> http://www.ycoln-resources.com
>> >> >> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
>> >> >> ==============================================
>> >> >> To assist you in getting the best answers for FrontPage support see:
>> >> >> http://www.net-sites.com/sitebuilder/newsgroups.asp
>> >> >>
>> >> >> "Jehuty" <(E-Mail Removed)> wrote in message
>> >> >> news:09F5440D-0D40-40BD-BA73-(E-Mail Removed)...
>> >> >> > The reason i need the page to do an autosubmit is because the field database
>> >> >> > criteria is set to equal the identity number. Thats why i would like the code
>> >> >> > for it.
>> >> >> >
>> >> >> > "Thomas A. Rowe" wrote:
>> >> >> >
>> >> >> >> Best option is to create submit button, and let the user click it.
>> >> >> >>
>> >> >> >> --
>> >> >> >> ==============================================
>> >> >> >> Thomas A. Rowe (Microsoft MVP - FrontPage)
>> >> >> >> WEBMASTER Resources(tm)
>> >> >> >> http://www.ycoln-resources.com
>> >> >> >> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
>> >> >> >> ==============================================
>> >> >> >> To assist you in getting the best answers for FrontPage support see:
>> >> >> >> http://www.net-sites.com/sitebuilder/newsgroups.asp
>> >> >> >>
>> >> >> >> "Jehuty" <(E-Mail Removed)> wrote in message
>> >> >> >> news:09E8167B-0525-4B6A-BD7D-(E-Mail Removed)...
>> >> >> >> > When a user accesses the form where the data is displayed, how can i auto
>> >> >> >> > submit a search value once the user views the form?
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>
>>
>>