Hi,
A webpage with a form would pass its information through to either itself for processing, or another page designed specifically for precessing the data passed.
The page receiving the data would get the values from either the querystring or from POST (depending on the form's setup).
In the first scenario, say we have a simple page called form.php with one field that asks for your name, the field on that page could be called txtname. When you press the submit button, the page would send its data to another page called processing.php. The form would redirect the browser to this URL:
- http://www.somesite.com/processing.php?txtname=Gaz
What you can do in Access is simply avoid the first page altogether and call the processing page directly:
-
Dim IE
-
Dim URL As String
-
-
Set IE = CreateObject("InternetExplorer.Application")
-
-
URL = "http://somesite.com/processing.php?txtname=" & Me.txtname ' Where Me.txtname is a field on the Access form calling this code.
-
-
IE.Navigate (URL)
-
IE.Visible = True
-
If the form is sending its data using POST, then we would have to populate the form data like you want, but you would have to make changes to that page, namely some Java Script to receive values from the querystring, fill in the form data and then (maybe) submit the page too.
Obviously, that is beyond the scope of the Access forum. Once you have that page working correctly, the Access principle remains the same.
Gaz