Basic Question

[Tom]

Hi all,

I have a table called Companytbl with 2 fields: CompanyID (autonumber),
CompanyName(text)

On the form ( which related to a different table)I have company combobox.

What exactly is the setup so on the combobox it will show the companyName
and it will store in the table theCompanyID?

TIA,

Tom

 

[Dirk Goldgar]

In

Hi all,

I have a table called Companytbl with 2 fields: CompanyID
(autonumber), CompanyName(text)

On the form ( which related to a different table)I have company
combobox.
What exactly is the setup so on the combobox it will show the
companyName and it will store in the table theCompanyID?

Row Source Type: table/query
Row Source: Companytbl
Column Count: 2
Bound Column: 1
Column Widths: 0"; 2"
(the second column width can be any suitable non-zero value)

 

[Tom]

Thanks.

In

Row Source Type: table/query
Row Source: Companytbl
Column Count: 2
Bound Column: 1
Column Widths: 0"; 2"
(the second column width can be any suitable non-zero value)

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)