Combo Box in Table

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

hi,

PL wrote:
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/comboboxl...ombo_boxes.htm

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



mfG
-- stefan --