how pass value from a textbox in form to report?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jaYPee - 22 Mar 2005 07:02 GMT

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)?

Reply to this Message

Sylvain Lafontaine - 22 Mar 2005 18:34 GMT

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 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)?

Reply to this Message

jaYPee - 23 Mar 2005 07:47 GMT

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
[quoted text clipped - 11 lines]
>> how can I pass this value if i'm accessing SQL Server 2000 and
>> not the jet engine (mdb)?

Reply to this Message

Sylvain Lafontaine - 23 Mar 2005 17:25 GMT

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.

> I'm using adp to access sql server 2000. using this code
> (=[Forms]![MyForm]![MyField]) in a controlsource of a textbox in a
[quoted text clipped - 18 lines]
>>> how can I pass this value if i'm accessing SQL Server 2000 and
>>> not the jet engine (mdb)?

Reply to this Message