Recent content by jmcclow

Thanks for providing that link "Beetle", I really appreciate your help. It seems to be hanging up on this part of the code: 'Dim rs As DAO.Recordset and then it highlights in yellow: Function Concatenate(pstrSQL As String, _ Optional pstrDelim As String = ", ") _ As String...

I am trying to create a form that has list box controls for months (period), and when selected it takes all of the data currently on the form and copies it for each month selected. This will help speed up data entry, rather than entering the details in the form each time. In other words, I...

Any wise guys out there? I have been trying to get this to work for hours, but lack the experience to pull it off. I have provided an example with the names of my actual table and fields. Table name: eventlog SELECT e.period, e.center, e.event FROM [eventlog] as e results in this...