Text Box to display

  • Thread starter Thread starter DeWayne
  • Start date Start date
D

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.
 
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.
 
-----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.




.
Click to expand...

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?
 
-----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
Click to expand...
=[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.
 
DeWayne said:
-----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
Click to expand...
=[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.
Click to expand...

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.
 
Back
Top