Unknown syntax error. Any spare eyes out there?

[redbull]

Alright, so I'm helping a buddy of mine. He is constantly navigating around in KBB and a couple other sites.

I am trying to make a form with some text boxes, he can pop in make model year and mileage and run the search thru KBB...

So seeing the search address below, we can see where we need to change the make, model, year, and mileage.

So I can pop up the kbb site without issues.. but I am trying to append the rest of the information to the site....

Example of Search results on KBB :


http://www.kbb.com/lexus/is/2004-lex...00&crversion=b

Set Tv = Login("http://www.kbb.com/& Forms("frmMainnew").txtMake &/", True)

I am getting an syntax error with the code above...

Ultimately I am trying to so something like this...This would replace everything in the search bar with elements of the form....

Set Tv = Login("http://www.kbb.com/& Forms("frmMainnew").txtMake & / & Forms("frmMainnew").txtmodel & /Forms("frmMainnew").txtyear &-& Forms("frmMainnew").txtmake &-& Forms("frmMainnew").txtmodel & /categories/?intent=trade-in-sell&mileage=& Forms("frmMainnew").txtmilage & &crversion=b", True)

[GeekInOhio]

Two things:

1. Try using the format Forms!frmMainnew.txtMake rather than what you're doing. More details / examples here: http://access.mvps.org/access/forms/frm0031.htm

2. You are missing quotation marks in your concatenation. You have:

Set Tv = Login("http://www.kbb.com/& Forms("frmMainnew").txtMake &/", True)

It should be this:

Set Tv = Login("http://www.kbb.com/" & Forms("frmMainnew").txtMake & "/", True)

Or incorporating my suggestion from #1:

Set Tv = Login("http://www.kbb.com/" & Forms!frmMainnew.txtMake & "/", True)

I hope that helps.

[redbull]

That did it, thank you!

[GeekInOhio]

Glad to be of help.