PC Review

Thread Tools Rate Thread

Need help on creating option buttons on Form

CAD Fiend
Posts: n/a
      25th Jul 2005

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

#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?



Reply With Quote

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Need help with form with a single combobox & multiple textboxes, option buttons hansjhamm@yahoo.com Microsoft Access Getting Started 4 21st Dec 2006 04:41 PM
Need help on Form with Combobox and mutiple textboxes, option buttons hansjhamm@yahoo.com Microsoft Access Forms 1 15th Dec 2006 09:27 PM
Creating a form with option buttons Jon Microsoft Excel Programming 3 15th Apr 2006 03:15 AM
Creating a Form Using Option Buttons =?Utf-8?B?ZHNhdXNzYXll?= Microsoft Word Document Management 0 2nd Nov 2004 07:44 PM
Help! Help! Help! Help! Help! Help! Help! Help! Help! Help! Help! Help! Help! -$- Windows XP Internet Explorer 2 21st Dec 2003 11:45 PM




All times are GMT +1. The time now is 02:25 AM.