Phucon
Yes, the bound column should ALWAYS be the ID. Should there be duplicate texts the combo box will not work if bound to the text field.
The client should not see the data directly in the table. It should always be presented in a form or report so you have better control over what the user does. And it is an easy matter to present the text instead of the ID.
One example of user error:
1. The document warnings have been turned off.
2. the user clicks the upper left corner of the table. All records will be highlighted.
3. Then the user panics and presses Esc. Poof! the entire table is emptied.
Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com
--- In MS_Access_Professionals@yahoogroups.com, "saigonf7q5" <saigonf7q5@...> wrote:
>
> If the rowsource of a combo box has an id column and a description column, and when we use the wizard to create a combo box, it bounds to the id column automatically.
> Each time an item's selected, it stored the id in the table instead of the text (description). The users prefer to see the text in the table rather than an id. I satisfied user's request by changing the bound column from the id column to the description column.
> My question is, should the bound column always be the id column? Or it does not matter?
>
> Thank you
>
> Phucon
>
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (3) |
Tidak ada komentar:
Posting Komentar