Z
zack
I know you can input a URL into the property sheet of a command button,
so that when clicked it opens that webpage.
However what I need to be able to do is for the command button to open
a URL dependant on the record displayed on the form at that particular
time.
So for instance if the current record showing on the form relates to
course leaflet 1010.
the URL it would need to go to is:
http://10.1.2.30:2/adult/course_details.asp?cat=oracle&leaflet=1010
or if it was Course leaflet 103, then:
http://10.1.2.30:2/adult/course_details.asp?cat=oracle&leaflet=103
and so on.
Basically only the data in the URL after the '=' sign ever changes.
I dont whether this can be done through the property sheet or whether
it requires some VBA code (which I very little experience).
Any pointers in how I can do this would be extremely grateful.
Thanks
Carl
so that when clicked it opens that webpage.
However what I need to be able to do is for the command button to open
a URL dependant on the record displayed on the form at that particular
time.
So for instance if the current record showing on the form relates to
course leaflet 1010.
the URL it would need to go to is:
http://10.1.2.30:2/adult/course_details.asp?cat=oracle&leaflet=1010
or if it was Course leaflet 103, then:
http://10.1.2.30:2/adult/course_details.asp?cat=oracle&leaflet=103
and so on.
Basically only the data in the URL after the '=' sign ever changes.
I dont whether this can be done through the property sheet or whether
it requires some VBA code (which I very little experience).
Any pointers in how I can do this would be extremely grateful.
Thanks
Carl