View Single Post
  #1  
Old July 23rd, 2009, 05:49 AM posted to microsoft.public.access.gettingstarted
anders bitzer
external usenet poster
 
Posts: 2
Default Create "cancel" button on a form collecting parameters

Hi
As new danish user in Access 2007 I have a small question.
With help from the help menu, I have created a form that collects parameters
for a report. Only thing missing is a cancel button on the form that allows
me to cancel the query.
Following the help menu I have following module in VBA, but I guess
something should be changed between the brackets.

Function IsLoaded(ByVal strFormName As String) As Boolean

Dim oAccessObject As AccessObject
Set oAccessObject = CurrentProject.AllForms(strFormName)

If oAccessObject.IsLoaded Then
If oAccessObject.CurrentView acCurViewDesign Then
IsLoaded = True
End If
End If

Thanks in advance for any help.
Anders