Form Help.

[Guest]

Hi,

I have a form that for my users in different region to fill it out to add
data but since I have so many site/country I want to program my form so that
when the user select the country either from a button or a combo box the form
will highlight in a certain color so that the user know exactly which text
field to type in based on the coloring of the text field. Another option
taht I have is also with a combo box of button when the user select the
country the fields that they are not required to fill out will be hidden in
the form and show only the field they need to fill in. I don't know how
complicated that would be but I would definately know if that is possible.

Thanks!!!!

 

[Guest]

Hi

It's not too complecated to do either of what you suggested. But can I
offer an even easier solution. Make a different form for each country and
use the switchboard for the user to select which country they live in then
open the form for that country.

You could select the countries from a combo and use the AfterUpdate event.
Something like this

Private Sub Combo_AfterUpdate()
If Me.Combo = "Country1" Then
DoCmd.OpenForm "Country1Form", acNormal, "", "", , acNormal
End If
If Me.Combo = "Country2" Then
DoCmd.OpenForm "Country2Form", acNormal, "", "", , acNormal
End If
If Me.Combo = "Country3" Then
DoCmd.OpenForm "Country3Form", acNormal, "", "", , acNormal
End If
End Sub

 

[Guest]

Thanks Wayne,

I thought about this one as well but that means I will have to create over
200 forms because I have about 200 countries. That is a lot of work.

 

[Larry Linson]

"E-mail report using Lotus Notes rather t" wrote

I thought about this one as well but that means I
will have to create over 200 forms because I have
about 200 countries. That is a lot of work.

So will writing code to modify for all the possibilities be a lot of work.

I do not think we have enough information to give you either a comparison of
which will be more work for you, nor any detailed instructions on how to
approach code to modify the forms based on country. Are you conversant in
Office VBA? Do you wish to be? If the answer to either is "yes", then you
will want to consider doing it yourself; if the answer to both is "no", then
contracting someone to do this for you would be an option.

Larry Linson
Microsoft Access MVP