bounding an option group to a table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi all,

I created an paid by option group in a form and I bound it to a table. The
pb i have is that on the table the value 1, 2, 3 appear instead of the
choices. When creating the option group I made Company=1, client=2 and NA=3.
How can i make the paid by column say company, client, NA instead of 1,2 or
3?
You help will be appreciated.
Note: i have to turn it in today
 
fifi said:
hi all,

I created an paid by option group in a form and I bound it to a
table. The pb i have is that on the table the value 1, 2, 3 appear
instead of the choices. When creating the option group I made
Company=1, client=2 and NA=3. How can i make the paid by column say
company, client, NA instead of 1,2 or 3?
You help will be appreciated.
Note: i have to turn it in today
Click to expand...

If you use an OptionGroup you get numbers. However; its very easy in
reports or queries to display the text you want with the choose function...

=Choose([YourFieldName], "Company", "client", "NA")

Otherwise you would have to switch to a ListBox or ComboBox to store the
text directly. You could unbind the option group and translate between
numbers and text in code events, but that would be a somewhat sloppy way to
go about it and I wouldn't recommend that.
 
Fifi,

Another way is to create a table that has a numeric primary key and a text
field containing the descriptions. Then in a query you can join the tables
by the corresponding numeric fields and select the description. Then base
your forms and reports on the query.

Sprinks
 
Back
Top