Help on date on form

  • Thread starter Thread starter red skelton via AccessMonster.com
  • Start date Start date
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 think you need to change from two checkboxes to an option group. With two
checkboxes they both could be checked or both not. With an option group only
one at a time can be checked.
Use the option group data for comparison in an IIF statement for the address.
 
Back
Top