Open web page when form loads

[dzirkelb]

I have a form that displays data based on a simple query. The query asks for a PO number (from the query) and then displays the data. I wish to open a web page after the PO number is put in. What is the vb code to do so and is it on the onLoad or onOpen portion of the form?

Also, the web address needs that PO number. So, the web address would be: http://www.mydomain.com?PO=PONumber where PONumber is what was entered into the text box that was prompted by the query. Any ideas on where to start on this one? Thanks!

 

[dzirkelb]

I have it so the form loads a web page upon opening; however, I need to send it information..here is what I have:

Dim stAppName As String

stAppName = "C:\Program Files\Internet Explorer\IEXPLORE.EXE http://www.mydomain.com?PO="
Call Shell(stAppName, 1)


I need to add at the end of mydomain.com?PO=

the string I need to add there is in the query which displays the page. Anyone have any ideas?

 

[KeithG]

Is the PO entered onto a form or is it already in a table in the database. Also the is am ActiveX web browser that you can inbed into your form so you can actually have the webpage open up in your form.

 

[dzirkelb]

I got it figured out witht the following code:

    Dim stAppName As String
    Dim strPO As String
    
    stAppName = "C:\Program Files\Internet Explorer\IEXPLORE.EXE http://mydomain.com?PO="
    strPO = PONumber.Value
    stAppName = stAppName & strPO
    Call Shell(stAppName, 1)

 

[ghudson]

Nice job dzirkelb!