R
red skelton via AccessMonster.com
Hi all,
I am having a porblem trying to get my head around this. I have a form that
receives its record source from a query. My problems comes into play when I
want to display a certain address. I have a main form where I put a grouping
on two check boxes. What I want to happen is if I check the first check box,
pull in an address. If I check the other , I want the address to change to a
different address. Here is an example, When I check box "a", the form will
print my home address. If I check box "b", my offce address will print on
the form. My address is in a table, and my office address is in an other
table. Both tables are part of the record source query. I hope I have
explained this well enough and provided enough information. Any help would
be greatly appreciated.
VR,
Red
I am having a porblem trying to get my head around this. I have a form that
receives its record source from a query. My problems comes into play when I
want to display a certain address. I have a main form where I put a grouping
on two check boxes. What I want to happen is if I check the first check box,
pull in an address. If I check the other , I want the address to change to a
different address. Here is an example, When I check box "a", the form will
print my home address. If I check box "b", my offce address will print on
the form. My address is in a table, and my office address is in an other
table. Both tables are part of the record source query. I hope I have
explained this well enough and provided enough information. Any help would
be greatly appreciated.
VR,
Red