Show records from diff table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My case,

I hv 2 tables as follow

1) Cust_table 2)
Account_table
Field 1 Cust_ID-----------------------------------Field 1 Cust_ID
Field 2 Cust_NAME Field 2
Acct_No

Question,

If i want to enter new data in Account table thru form , how to display cust
name the moment i keyed in the cust ID. (display thru unbound control)

Hope the info is sufficient...

Appreciate any reply
 
My case,

I hv 2 tables as follow

1) Cust_table 2)
Account_table
Field 1 Cust_ID-----------------------------------Field 1 Cust_ID
Field 2 Cust_NAME Field 2
Acct_No

Question,

If i want to enter new data in Account table thru form , how to display cust
name the moment i keyed in the cust ID. (display thru unbound control)

Hope the info is sufficient...

Appreciate any reply
Click to expand...

Well, simplest is to use a Combo Box, so the user doesn't need to key
in the ID at all, just have the combo look it up (or autocomplete it
if they do key).

The combo can be set up with the Cust_Name field included; if the name
is the first visible field in the combo the user can see and select
the name directly. If customer IDs are known to the user and
meaninful, then you can put a textbox on the Form with a control
source

=cboCustomer.Column(1)

where cboCustomer is the name of the combo box, and (1) means to
display the second column of the combo's row source query (it's zero
based).

John W. Vinson[MVP]
 
John,

You saved me again....

Thanks

John Vinson said:
Well, simplest is to use a Combo Box, so the user doesn't need to key
in the ID at all, just have the combo look it up (or autocomplete it
if they do key).

The combo can be set up with the Cust_Name field included; if the name
is the first visible field in the combo the user can see and select
the name directly. If customer IDs are known to the user and
meaninful, then you can put a textbox on the Form with a control
source

=cboCustomer.Column(1)

where cboCustomer is the name of the combo box, and (1) means to
display the second column of the combo's row source query (it's zero
based).

John W. Vinson[MVP]
Click to expand...
 
Back
Top