Multiple values for drop down boxes

[MishkaNanook]

I have created a database that has both English and French forms feeding information into the same table. I'm not concerned if the info stored in the table is stored in French or in English. It all works fine other then the drop down boxes in the forms, here I only seem to be able to either have the English or the French options visible on both the English and the French form. Is there a way to have the English options on the English form and the French options on the French form, both feeding the results into the same field in the table.

 

[Uncle Gizmo]

>>>all works fine other than the drop down boxes in the forms<<<

What you need to do is change your combo boxes so that you store an integer instead of text.

Make a table, with 3 columns, one for an integer, one for english, one for french, like this:


ID.............colour.........couleur
1..............yellow..........jaune
2..............red..............rouge
3..............brown..........brun
4..............green..........vert

modify your combo to show the necessary language.

 

[pbaldy]

With the proviso that I've never created a multilingual db, I'm envisioning a table with an ID field plus fields for the English and French info. Then the row source of your combo can select the ID field plus the field with the desired language. I'd probably use a single form, and change the rowsource of the combo (and other things) when it opens.

 

[pbaldy]

This is what happens when you go get a cookie halfway through typing a response.

 

[Uncle Gizmo]

>>>when you go get a cookie<<<

Wheres mine?

 

[pbaldy]

Wheres mine?

About halfway down I'd say.

 

[MishkaNanook]

With the proviso that I've never created a multilingual db, I'm envisioning a table with an ID field plus fields for the English and French info. Then the row source of your combo can select the ID field plus the field with the desired language. I'd probably use a single form, and change the rowsource of the combo (and other things) when it opens.[/QU

My first thought was to only use 1 form also, but if you have ever met a French person you will know that we hate to say something in a word when we can say it in 20. That being said, the single form becomes awkward at best as there is just too much on it, making it not very user friendly. Labels are too long, the form does fit on the screen properly and its puzzling to users which field English users should complete vs French users.

 

[pbaldy]

You would certainly have a better feel for that than I. One of my daughters speaks French, but not "being" French she probably doesn't follow the pattern.

Downside of course is double the workload both to create and later modify forms/reports. I guess we can call that "job security"!

 

[Uncle Gizmo]

No Paul didn't mean that...

What you do, is change the text in the labels with code, or possibly hide/unhide a label ... things like that...