How do I do this?

  • Thread starter Thread starter Oli
  • Start date Start date
O

Oli

Hi (again)

Im learning albeit slowly!

What I have is a drop down box with 2 options in it; T1, T2

When the user selects either of these options the information that relates
to this needs to be displayed on a report. For example, if T1 is selected,
we want one paragraph of information to be displayedand likewise for T2.

Any ideas? I do not know where to start!

Thanks in advance,
Oli
 
There are lot's of ways to do this. Hopefully the one I give you now will be
the easiest to implement for you.

In the underlying query for your report you should have the column which
contains the T1 or T2 values. Use the criteria box to refer to the combo box
on the form, thusly:

Forms!YourFormName!YourComboBoxName

If the values of T1, T2 are not available, you may need to use the Switch()
function (check the help files in VBA for more info) in a column of the
query. Something like:

Switch([FieldName] = "T1", "Paragraph1", [FieldName] = "T2", "Paragraph2")
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top