I want to open a form from another form just by pressing a button called "Notes" That will display notes with only the last name of the displayed perdon on the first form.
I placed the last name of a person into a string variable called glastname. Using the

Dim stDocName, GastName As String
gLastName = Me.Lastname ' get the Last name from the current form
stDocName = "notes" 'the form to open

This does not work Why?
    DoCmd.OpenForm stDocName, , , "LastName = gLastName"

This does
    DoCmd.OpenForm stDocName, , , "LastName = 'Book'" 'Book is a name taken from the table I am displaying.

It does not seem that GLastName is getting through to the openForm function. How do I get this to work.

Thanks I would appreciate any help you can give.

Bill

You did not include the delimiters for the last name, nor did you seperate it out as a variable.

DoCmd.OpenForm stDocName, , , "[LastName] = '" & gLastName & "'"

When writing SQL conditions, strings are surrounded by apostrophes and dates by the pound sign (#). Numbers get nothing. Other Examples:

For a date: DoCmd.OpenForm stDocName, , , "[DateOfBirth] = #" & gDOB & "#"

For a number: DoCmd.OpenForm stDocName, , , "[NoOfDependants] = " & gDependants

For a boolean (yes/no/true/false): DoCmd.OpenForm stDocName, , , "[ActiveRecord] = " & gActive


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division