how pass value from a textbox in form to report?

  • Thread starter Thread starter jaYPee
  • Start date Start date
J

jaYPee

I have a form (dialog form to display report) that has an unbound
textbox. I want to pass the value of this textbox to my report. But
how can I pass this value if i'm accessing SQL Server 2000 and
not the jet engine (mdb)?
 
Probably in the same way that you are doing it now with the MDB file. For
example, if you want to set the value of one of the report's control to the
value of an open form:

=[Forms]![MyForm]![MyField]

Also, this newsgroup is about DAP. If you are using an MDB file with linked
tables to a SQL-Server, you are not at the best newsgroup for your problem.

S. L.
 
I'm using adp to access sql server 2000. using this code
(=[Forms]![MyForm]![MyField]) in a controlsource of a textbox in a
report does not work.


Probably in the same way that you are doing it now with the MDB file. For
example, if you want to set the value of one of the report's control to the
value of an open form:

=[Forms]![MyForm]![MyField]

Also, this newsgroup is about DAP. If you are using an MDB file with linked
tables to a SQL-Server, you are not at the best newsgroup for your problem.

S. L.

jaYPee said:
I have a form (dialog form to display report) that has an unbound
textbox. I want to pass the value of this textbox to my report. But
how can I pass this value if i'm accessing SQL Server 2000 and
not the jet engine (mdb)?
Click to expand...
Click to expand...
 
Is the form still open? Does the same code work with your MDB file?
Are-you able to read this value from the other form in the Report_Open event
for that report?

S. L.

jaYPee said:
I'm using adp to access sql server 2000. using this code
(=[Forms]![MyForm]![MyField]) in a controlsource of a textbox in a
report does not work.


Probably in the same way that you are doing it now with the MDB file. For
example, if you want to set the value of one of the report's control to
the
value of an open form:

=[Forms]![MyForm]![MyField]

Also, this newsgroup is about DAP. If you are using an MDB file with
linked
tables to a SQL-Server, you are not at the best newsgroup for your
problem.

S. L.

jaYPee said:
I have a form (dialog form to display report) that has an unbound
textbox. I want to pass the value of this textbox to my report. But
how can I pass this value if i'm accessing SQL Server 2000 and
not the jet engine (mdb)?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top