Understanding what stuff means

[RandomGuy123]

What do the following things mean:

If Not rst.EOF Then 'there is a clash

Me.Undo
Else ' there is not a clash

End If
Set rst = Nothing

 

[CJ_London]

You'll need to provide the whole code so it is context for others to help

background for other viewers:

the previous query tried to find an appointment with the same characteristics as the one you are trying to book.

rst is a recordset object which has been populated by the query usinf the openrecordset method

If it finds such a record then eof (end of file) is false - so there is a clash

If it doesn't find such a record then eof =true - so there is not a clash

You need to research recordsets and their properties so this link may help

http://msdn.microsoft.com/en-us/library/office/ff197799.aspx

This tells you about dao type recordsets (primairly used by Access) and you will see an option to look at properties