Hi

How can I select a form name and feed it into an SQL query? What I want to do is, create an internal help file but filtering by form name. So for example, if you want to add a new record form a form, if you click on the help file it will only display info on how to add. If you are in a delete form, and click help button it will only display info on how to delete (just examples).

Is there any way I can do this?

Lindsey

Just package it with Me.Name, like this:

Dim sForm, sName, sLink As String
sForm = Me.Name

Then something like:

sLink = "[FormName] = '" & sForm "'"

Then
sName = "rptMyHelpReport"

DoCmd.OpenReport sName, acPreview, , sLink

Check the syntax to make sure you have the sLink in the WHERE clause.

This should work, assuming your report is based on entries that are determined by the form name. You could also do this with button names.

HTH

mmcdonal