You need to clarify:
Is the field in your table the control source to your toggle button? If yes and the field is text, you cannot use an option control. If no, how are you converting the text back to a number for the option control?
Do you really want your
table to store 'dog', 'cat', etc rather than a number? - bearing in mind you can easily display 1,2, etc as dog, cat etc in a form, report or query?
I guess I'm trying to say you should not look at tables directly - except perhaps during development and tables should contain what you need for the system to work, not what you want to see because it is sometimes easier to look at the table with a translated value rather that writing a query
I'm using access to register members of a fraternal organization for conventions. As their information is entered on the form, the degree they hold is entered by way of a toggle button. (BTW, nothing to do with dog,cat etc, I just used that as an example)..There are 4 degrees to choose using the toggle option buttons.
Once a person's info is entered into the form, a "credential' is printed out and placed into a lanyard as proof the member is registered for the convention. We are using the option (toggle) button to select the degree the member holds. This button not only uses VBA to assign and print a logo associated with their degree, it also is a control to a field inside a table using values (1-4). True example: 1=Candidate, 2=Moose Legionnaire, 3=Fellow,4=Pilgrim.
Here's my problem....the "Degree Field" inside the table now shows as 1,2,3,or 4.. Not a problem until now because it's understood what number corresponds to what degree. However, we now want to use "Adobe Forms Central" for online pre-registration and the online form will allow an export to excel, which will be used to import into the access table. The online form will offer the wording of degrees (Candidate, Moose Legionnaire, Fellow & Pilgrim), not the numbers 1-4.
So importing the data from "forms central" into the "degree" field will have the wording for their degrees, but manual entry using the form (for those registering onsite and
not imported through forms central) will show 1-4 in the degree field.
Bottom line is: In order to import the excel file from forms central into access, need a way to convert...
1) the imported data coming from "forms central" (example): convert from "Candidate" to "1" in the degree field..or
2) Have the toggle button values from access read as (example) "1" reads as "Candidate".
It seems it would be better for me to simply have the values (1-4) converted to the text "candidate" instead of "1" into the "degree" field in order to avoid altering an Excel file to be compatible for import into the access table.
My apologies for such a confusing issue, it's hard to explain in written format. Thanks so much for your reply.
