Passing Data Between Forms

[exeTrix]

Hi All!

I'm new to Access so you'll have to bare with my limited and somewhat noobish understanding of the product.

I have a form that a user fills in to add a event to a database which works fine What I would like to know is how to add a command button that will open another form to show people that may wish to attend the event.

I have some VB.Net knowledge and from this I know that you can set the buttons visibility based upon an if statement like below:

If SomeVar Then
btnUpdate.Visible = true
End If

So running off the back of that I wanted to show the command button if the record has been saved then pass the day the event is to another form so when the user clicks the button they have a list of all people who may be able to attend.

Unfortunately, I'm unable to find out how to do this on the net. My experience is predominantly internet programming so I'm a bit lost and don't know where to start.

Any help would be greatly appreciated.

[exeTrix]

Ok I think I've managed to find something useful on the net with regards to checking if the form has been saved:

If Me.Dirty Then
'show the button - however that may be 
End If

Would this go into a equivalent of Page Load found in web development? Then I need to pass the Day to my second form and somehow use it to display the correct records - maybe with DLookup() function.

Sorry if I'm well off the mark i don't really understand how Access deals with events nor do I really know how forms work in the background in preparing the output.

[exeTrix]

Hope somebody can help me. I think I was barking up the wrong tree earlier. I have managed to create a form based upon an SQL query let call it FormA. So when the form is opened it asks for the user to enter a day, then displays all matches.

What I want is to put some kind of control on another form so that when it's clicked the user is taken to FormA but the day is passed to it automatically.

Hope that makes sense. If anybody could help with this it's be great

[exeTrix]

Did it myself. Thanks for all the help lol

Just in case anybody comes across this here's what I did. Might not be right but it was the best I could do....

Private Sub btnFindVolunteer_Click()
    'assign the variables
    Dim MyDB As DAO.Database
    Dim qdef As DAO.QueryDef
    Dim strSQL As String
    Dim Day As String
    
    'pull the day from the form
    Day = Me.Day

    'let the engine know which database to use
    Set MyDB = CurrentDb()
    
    'here's the SQL we need to use
    strSQL = "SELECT Volunteer.Title, Volunteer.ForeName, Volunteer.FamilyName, Volunteer.PhoneNo " & _
             "FROM Volunteer INNER JOIN Availability ON Volunteer.VolunteerID = Availability.VolunteerId " & _
             "WHERE (((Availability.Day)= '" & Day & "') AND ((Volunteer.CRBCheckDate) Is Not Null))"
    
    'delete the old query :)
    MyDB.QueryDefs.Delete "FindEventVolunteer"
    
    'now recreate the query
    Set qdef = MyDB.CreateQueryDef("FindEventVolunteer", strSQL)

    'Open the query and display to the user
    DoCmd.OpenQuery "FindEventVolunteer", acViewNormal

End Sub