New Tips Added Weekly!
Click here to get on our Mailing List

Web Browser Control

How to navigate to a different URL based on a subform value

In this tutorial I will explain how to navigate to a URL based on a Subform value.

There was a question on the Forum asking how to update a Web Browser Control with values from a SubForm.

I've created a simple Table with some dummy data, made a continuous Form from that then added it as a Subform to another Form.

This Main Form has a Web Browser Control (WebBrowser1) and an unbound Textbox (URL)

There's a Tip talking about referencing controls.

=Forms!CustomerF!CustomerID
=Forms!CustomerF!OrderSubForm.Form!OrderTotal
=Forms!FormName!FieldName
=Forms!ParentForm!SubForm.Form!FieldName

In this case we are on the Subform and want to update on the Parent so we can use the Parent keyword.

Form_Current()

	Private Sub Form_Current()
		MsgBox ID
		Dim strURL
		strURL = "https://www.google.co.uk/?q=" & ID
		Me.Parent.URL = strURL
		Me.Parent.WebBrowser1.Object.Navigate strURL
	End Sub
	

Let me know if you'd like any additions.

Sample Files
WebBrowser.accdb (Access 2010 .accdb)

By: Alex Hedley

Click here to sign up for more FREE tips