Basic Question

  • Thread starter Thread starter Tom
  • Start date Start date
T

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
 
In
Tom said:
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?
Click to expand...

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)
 
Thanks.
Dirk Goldgar said:
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)
Click to expand...
 
Back
Top