By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,475 Members | 1,367 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,475 IT Pros & Developers. It's quick & easy.

Need help on user input decision for Form

P: n/a
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.

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
I would suggest using a control box with radio buttons for each case.
After typing the address the user would select on of the three options.

In the AfterUpdate event of the control box (which you should probably
tie in to a new integer field in your table) you can do either of three
things depending on the selection:

Sub ControlBox_AfterUpdate()
Select ControlBox
Case 1
'Owner Lives on property, will use physical address....
me.ActualAddress.visible = true
me.PostalAddress.value = me.ActualAddress.value
me.POB.visible = false
Case 2
'Owner Lives on prop, but uses POBox
me.PostalAddress.visible = false
me.POBControl.visible = true
me.POBControl.SetFocus
Case 3
'owner on property - not sure what you want to do here
end select
end sub
....something like that could work? (obviously this will require
modification to your specific needs/control names)

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.