Combo Box in Table

[PL]

For Access 2003.

1) In Table, I want to use a combo box with the options from another table,
what the syntax I should enter for the row source?

2) In Table, I want to use ID for the field, but want the combo box options
to be the names connected with these ID, what's the syntax?

Thanks

 

[Stefan Hoffmann]

hi,

1) In Table, I want to use a combo box with the options from another table,
what the syntax I should enter for the row source?

2) In Table, I want to use ID for the field, but want the combo box options
to be the names connected with these ID, what's the syntax?

Basically, you shouldn't do that:

http://www.mvps.org/access/lookupfields.htm

Access is for building forms around your tables to perform user
interface tasks.

Setup a combo box:

http://www.blueclaw-db.com/comboboxlist/table_lookup_combo_boxes.htm

Set the forms view property to Datasheet to emulate the table look and feel.



mfG
--> stefan <--