sending values to report..

keybearer

Registered User.
Local time
Today, 21:12
Joined
Jul 7, 2003
Messages
41
hi.. i need some simple help here..
How do i send the value (string) of a textbox on a form to a textbox on a report?
 
sets the recordsource of the text box on the report to
=forms![yourformname]![Textboxname]
 
thanks bjackson.. that helps..
if u don't mind, do u know how to display a report based on the values of a cascading combo box? let's say i have a state combobox (1st) and city combobox (2nd) where the 2nd cbx will populate when i click on a value in the 1st. i want to display a report which matches the values of both cbx..
thanks again..
 
in the reports record source click to build a query

include the two fields that you want to set criteria on and set
the criteria as before
field1
=forms![yourformname]![cb1]

field2
=forms![yourformname]![cb2]
 
that was quick.. but i think u misunderstood me.. i'll try to make it clear..
i have a query to open a report which is grouped by states and city.. It diplays all the records that i currently have by every state and city..
the textboxes on the report is bound to the fields state and city in my table.. so how do i use the combobox to open the report and display only the state and city that matches the cbx in the form?
FYI, i can do this with just one combobox, namely states..

thanks in advance..
 
not knowing exactly what your table set ups are
i will try to help
if your query contains the fields ,field state and, field city
and the combo boxes are based on
1.cb1 table states
2.table citys

then in your query the criteria would be
field state
criteria=forms![formname]![cb1]
field state
criteria=forms![formname]![cb2]

the query would return only those records whose state = cb1
and whose city = cb2 on the form you open the report from
 
This works just fine.

What about if the textbox on the form references a record textbox of, for example, a keyword.

It is showing up as the keyword-id (as a number).

I don't want it to show up as a number, I want it to show up exactly as it is on the form.

help.
 

Users who are viewing this thread

Back
Top Bottom