M
MIchaeldane
I'm using Access2003.
I have a form that displays a picture of a property and some general
information along with the autonumber of that record set (Building ID). On
the form is also a command button that ties to a query that asks for the
building ID, once the building ID number is entered you are taken to another
form that displays all the information for that building ID. What I would
like to do is just click on the building ID and have access display that same
page with the full details instead of filling in the ID number and going to
the form that displays all the information.
I have tried a macro attached to ID with openform and gotorecord but that
isn't working. I can for forward to next record, back etc. but can't get it
to go to say record 81 that was displayed as the building ID.
I have a form that displays a picture of a property and some general
information along with the autonumber of that record set (Building ID). On
the form is also a command button that ties to a query that asks for the
building ID, once the building ID number is entered you are taken to another
form that displays all the information for that building ID. What I would
like to do is just click on the building ID and have access display that same
page with the full details instead of filling in the ID number and going to
the form that displays all the information.
I have tried a macro attached to ID with openform and gotorecord but that
isn't working. I can for forward to next record, back etc. but can't get it
to go to say record 81 that was displayed as the building ID.