Text Box to display

[DeWayne]

Sorry for such a dumb question. But I am not doing well.
I have a Form based on a query that uses many tables. I
have a table called JobNumbers with 5 or six fields two
of which are JobNumber, and JobName. I am using the
JobNumber to referance this job and I have a combo box on
the main form that you can select the job. This box
shows shows both fields when you pull down. However
after you select a job only the JobNumber shows (control
source) How do I have a second Text Box to display the
JobName, and When I print a report I want both the
jobname and number on the report.

 

[Andrew Smith]

In the test box control source property put:
=cboName.column(1)
(replace "cboName" with the name of your combo box).

To print both the name and number on the report, just add the name field to
the query behind the report.

 

[DeWayne]

-----Original Message-----
In the test box control source property put:
=cboName.column(1)
(replace "cboName" with the name of your combo box).

To print both the name and number on the report, just add the name field to
the query behind the report.




.

Ok I have form working fine however am having trouble
adding name field to query. Query is very complex and
the name field exist only in the JobName table. I tried
to add the table to the query and add the jobName field
to the query only to have many unexpected results. I am
have errors stating to complex to outer join errors to no
errors but no data in the fields in my report. Do I need
to build an expression in the query? Or What?

 

[DeWayne]

-----Original Message-----
tables. box

Ok I have form working fine however am having trouble
adding name field to query. Query is very complex and
the name field exist only in the JobName table. I tried
to add the table to the query and add the jobName field
to the query only to have many unexpected results. I am
have errors stating to complex to outer join errors to no
errors but no data in the fields in my report. Do I need
to build an expression in the query? Or What?
.
Found it this works great

=[Forms]![PurchaseOrders]![JobNumberCBO].column(1)
where PurchaseOrders is the name of the open form
and JobNumberCBO is the name of the combo box and column
1 has the info I need.

 

[Andrew Smith]

-----Original Message-----
tables. box

Ok I have form working fine however am having trouble
adding name field to query. Query is very complex and
the name field exist only in the JobName table. I tried
to add the table to the query and add the jobName field
to the query only to have many unexpected results. I am
have errors stating to complex to outer join errors to no
errors but no data in the fields in my report. Do I need
to build an expression in the query? Or What?
.
Found it this works great

=[Forms]![PurchaseOrders]![JobNumberCBO].column(1)
where PurchaseOrders is the name of the open form
and JobNumberCBO is the name of the combo box and column
1 has the info I need.

Obviously this will only work if you open the report when the form is
already open, but if this is always the case then it will work.