Need help on creating option buttons on Form

Discussion in 'Microsoft Access Forms' started by CAD Fiend, Jul 25, 2005.

  1. CAD Fiend

    CAD Fiend Guest

    Hello,

    I am making a form that will contain address fields for a land owner,
    but sometimes the land owner does not live on the same property they own
    (for instance, they may be renting it out to a tenant), or in the other
    case, they are using a PO Box instead of the physical address.

    I am interested in finding out if there is a way to reduce the amount of
    typing for the user when inputting the land owner's information twice.

    My table has the fields, OwnerAddress, and PropertyAddress, OwnerPOB.

    Here are the possible scenarios:

    #1 - Owner lives on property, and will use the physical address for
    mail,

    #2 - Owner lives on the property, but instead prefers to use a POB for
    mail address,

    #3 - Owner does NOT live on property, tenant lives on it instead.

    The form will have the same fields.

    When the user opens the form, and enters the physical address (field
    named Property Address) of the property (which is mandatory) is there a
    way that I can set it up so they can (then) click on (of some type -
    what would you recommend?) a button next to the physical address field
    to indicate WHETER or NOT this address is the mailing address? And if
    they clicked on it to say YES, it would populate both the
    PropertyAddress AND the OwnerAddress in the table (and can it populate
    the Owner Address field on the form as well)? Likewise, if they (the
    user) clicked NO, then the PO Box field would "set focus" so the user
    would input the PO Box number?

    And how would you suggest I create a button for #3?

    TIA.

    Phil.
     
    CAD Fiend, Jul 25, 2005
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Sheri Emery

    Buttons, buttons

    Sheri Emery, Dec 31, 2004, in forum: Microsoft Access Forms
    Replies:
    6
    Views:
    142
    MacDermott
    Jan 28, 2005
  2. Guest

    option buttons on a sub form

    Guest, Jun 2, 2005, in forum: Microsoft Access Forms
    Replies:
    0
    Views:
    142
    Guest
    Jun 2, 2005
  3. Replies:
    1
    Views:
    134
    Guest
    Dec 15, 2006
  4. Guest

    need help in creating form

    Guest, Mar 28, 2007, in forum: Microsoft Access Forms
    Replies:
    4
    Views:
    145
    Guest
    Apr 2, 2007
  5. summernight

    I need help creating a form please

    summernight, Dec 14, 2007, in forum: Microsoft Access Forms
    Replies:
    1
    Views:
    133
    Arvin Meyer [MVP]
    Dec 14, 2007
Loading...

Share This Page