Populate Hyperlink

Let me explain my problem and say that I've found a partial fix to my problem, but I need help figuring the rest out.

I need to open a hyperlink on the internet and populate it with data based on a form record in my database. More clearly, I need to do a search on an address on a website called zillow.com, based on that address in my form in the db. For example, if the property address in my db is 123 Anywhere St., Topeka, KS 99999, I need to click a button that will open zillow.com, and populate the address and city/state/zip fields with the corresponding info from the record in the db. Here's what I've got so far:

VB Code: Original - VB Code Application.FollowHyperlink "http://www.zillow.com", , True, False Application.FollowHyperlink "http://www.zillow.com", , True, False

Here's the deal. When you do the internet search on zillow, it puts in %20 for every space and I can't figure out how to parse the record to automatically put these characters in.

I'm wondering if there's a way to tell the db in code to do this:

Application.FollowHyperlink "http://www.zillow.com/search/Search.htm?addrstrthood=2200%20Corley%20Drive&citystatezip=Las%20Cruces%2C%20NM%2088001", , True, False

I hope someone knows what I'm talking about. Thanks!

KellyJo