Text/Combo Boxes displaying columns from records in specific tables

  • Thread starter Thread starter Brendan Irwin
  • Start date Start date
B

Brendan Irwin

Hi Everyone,

I am currently modyfying a Form in Access 2000,
I need to know whether there is a way where I can have a
group of 5 or more text/combo boxes displaying row
information from a table.

I want each text/combo box to perform as though they were
holding information like a table cell

For example, some of the fields in my table are

Cust_ID (text box 1)
Company Name (text box 2)
Address (text box 3)
Suburb (text box 4)
State (text box 5)
Post_Code (text box 6)

I've fiddled around with the Control & Row source
properties, and I've had no success.
Any help would be appreciated.


From
Brendan Irwin
(e-mail address removed)
 
Sure. Make the first box a combo box with the record source set to Cust_ID.
Set the row source to be a SQL statement with all the fields you to show.
Use text boxes for the other fields and set them to equal the different
fields from the combo box.

Combo Box 1: Cust_ID with SQL statement
Text Box 2: = cmBoxName.Column(1) 'Company Name
Text Box 3: = cmBoxName.Column(2) 'Address
Text Box 4: = cmBoxName.Column(3) 'Superb
Text Box 5: = cmBoxName.Column(4) 'State
Text Box 6: = cmBoxName.Column(5) 'Post_Code

replace cmBoxName with the actual name of Combo Box 1.

Kelvin
 
TO Kelvin,

You have been a great help, I really appreciate it.
Access is still giving me problems, I entered in the
following expression in Expression Builder (I couldn't
access SQL view from the properties from the text boxes)

Combo Box 1.Column(1) 'Company Name

I even tried the following

Combo Box 1.Company Name


I keep on getting a #Name? error appearing in each text
box.

I'm still doing something wrong, there could be a way to
run a query from each text box that makes reference to the
Cust_ID, each Cust_ID entry is a number eg. 1 to 10

Don't worry to much if there's no way to achieve this,
it's not of absolute importance


Thanks!
Brendan Irwin.
 
Back
Top