Where Condition? - Passing Unique ID to My Report?

N

Neil

Hio there,

I have a form with a button on it, which i put on via the wizard - this
opens up a report.

My Report is run from a query, which requires a unique id - i want my button
to pass my unique id from the record currently on the form, to the report it
is opening up - what code do i need to achieve this?

Many thanks,

Neil
 
M

Marshall Barton

Neil said:
I have a form with a button on it, which i put on via the wizard - this
opens up a report.

My Report is run from a query, which requires a unique id - i want my button
to pass my unique id from the record currently on the form, to the report it
is opening up - what code do i need to achieve this?
Click to expand...


THe report can refer to the value on the form the same way
the query does. For example, a report text box can use an
expression like:
=Forms!theform.theIDtextbox
 
N

Neil

Hi Marshall,

thanks for your reply......

Can you explain exactly what code i need - im a tad confused (im new to the
whole coding thing) - many thanks,

Neil
 
M

Marshall Barton

The expression I posted is not VBA code, it's just an
expression you use in a text box's control source property.

If that's still confusing you, please post more details
about what you're trying to accomplish, what you have in the
query and on the form.
 
Top