returning values from a combobox

[papa]

Hi Guys,

I need help with the following problem:

I have a combobox called "teams", when you click on any
entry in this combobox it automatically fills my other
combobox "agents" with all the agents of that particular
team. (this works fine!).

After you pick the agent you need it opens a new form
called "frmTaxiProcurement" which then has the agents
name displayed (this works fine!!)

What I need help with is, I want this form
("frmTaxiProcurement") to display all of this agents
details: address, telno, manager, etc. this information
is stored in a table called "TBL_TAXI_REQ_DETAILS".

Is there an easy way to make this happen?
Most of what I want shown are just textboxes but there
are also checkboxes...


Many thanks,
Papa

 

[Guest]

Bind form "frmTaxiProcurement" to table
"TBL_TAXI_REQ_DETAILS". When you open the form, use a
WHERE clause specifying that the Agent in the table is
equal to the Agent in the ComboBox.

The syntax would be something like:

"WHERE [tbl_Agent_Field_Name] = Me![teams]

Make sure that the bound column of the teams combobox
contains the same data as "tbl_Agent_Field_Name".

Good luck,

Chuck

 

[Chuck Minarik]

Papa,

I looked back at my response and realized it could have
been clearer. The where clause would actually be:

"WHERE [tbl_Agent_Field_Name] = " & Me![teams]

Chuck

-----Original Message-----
Bind form "frmTaxiProcurement" to table
"TBL_TAXI_REQ_DETAILS". When you open the form, use a
WHERE clause specifying that the Agent in the table is
equal to the Agent in the ComboBox.

The syntax would be something like:

"WHERE [tbl_Agent_Field_Name] = Me![teams]

Make sure that the bound column of the teams combobox
contains the same data as "tbl_Agent_Field_Name".

Good luck,

Chuck

-----Original Message-----
Hi Guys,

I need help with the following problem:

I have a combobox called "teams", when you click on any
entry in this combobox it automatically fills my other
combobox "agents" with all the agents of that particular
team. (this works fine!).

After you pick the agent you need it opens a new form
called "frmTaxiProcurement" which then has the agents
name displayed (this works fine!!)

What I need help with is, I want this form
("frmTaxiProcurement") to display all of this agents
details: address, telno, manager, etc. this information
is stored in a table called "TBL_TAXI_REQ_DETAILS".

Is there an easy way to make this happen?
Most of what I want shown are just textboxes but there
are also checkboxes...


Many thanks,
Papa

.

.