inheritance module

[@ndy]

I've a the same form in Dutch and in French. There is an Access
database with all the users with their language preference. How can I
depending on the language of the person call a form in Dutch OR
French. Don't won't to program 2 times the form but do it with a
module or something like that.

Any help is welcome.

 

[Guest]

Does this work for you?

If you are willing to create a copy of your UserForm and Rename the forms:

Then
Create two UserForms named:
UserFormDutch
UserFormFrench

Assuming you are able to query the db and get the language for the User,
assign the Language to a Public variable, say Lang.

Then

Sub OpenUserForm()
UserForm & Lang.Show
End Sub