how to use a value from a combo box in a report

[bella]

Hi,

can anyone tell me, if there's a way to put a value that a user selects from a combo box in a form into a report?

EG. The report has a field called Names which it needs to get from a Combo box on a form that stores various values for Names (eg. Bella, Bob, Jane, etc)

So, if the user selects Bella from a combo box on the form, Bella should turn up in the Names field on the report.

how do i do this? -

and more specifically - how do i do this if the report is based on a query that is independent of that particular combo box?)

any ideas?

Bella

 

[WayneRyan]

Bella,

The form must be currently OPEN.

Then you can just reference the combo as:

Forms![YourOpenMainForm]![YourCombo]

Note: you could also use this value as a criteria
in the query for your report (but don't have to).

Wayne