Where Condition? - Passing Unique ID to My Report?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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