M
Mikey C
Hi all
I have a main form which displays contact details for a particular
person, and then a subform which currently displays the name and
position of all other contacts for the same organisation.
What I am trying to do is use the GoToRecord command in the OnClick
event (in the alternative contacts form, contact name field), so that
when I click a name in the subform all their details will be
displayed
in the main form. I'm not very experienced with VBA so am in above my
head here!
I have managed to use the GoToRecord event to take me to a specified
record number but this is useless as it needs to be a different
variable each time (the specified contact name).
Also, I would like the alternative contacts subform to exclude the
contact currently displayed in the main form - although this is not
essential unlike the 1st problem ...
Any help would be much appreciated!
Thanks
Mike
I have a main form which displays contact details for a particular
person, and then a subform which currently displays the name and
position of all other contacts for the same organisation.
What I am trying to do is use the GoToRecord command in the OnClick
event (in the alternative contacts form, contact name field), so that
when I click a name in the subform all their details will be
displayed
in the main form. I'm not very experienced with VBA so am in above my
head here!
I have managed to use the GoToRecord event to take me to a specified
record number but this is useless as it needs to be a different
variable each time (the specified contact name).
Also, I would like the alternative contacts subform to exclude the
contact currently displayed in the main form - although this is not
essential unlike the 1st problem ...
Any help would be much appreciated!
Thanks
Mike