ACCESS FEED: [MS_AccessPros] Fill List Box from Date Search

Selasa, 25 Juni 2013

[MS_AccessPros] Fill List Box from Date Search

Hi,

I have two text boxes for entering Before and After dates to get a date range. I want to then fill a list box with the items in the date range.

I then want the user to click on the list box and update the bottom section of the form.

I have added a screen grab of the form to the Photos section with the same name as this post.

I have the following SQL statement that works in a query:

SELECT tbl_Event.EventID, tbl_Event.Date, tbl_Event.OrganisationID, tbl_Event.Time, tbl_Organisation.Organisation, [Last Name] & ", " & [First Name] AS Name, tbl_Event.StaffID, tbl_Staff.[Last Name], tbl_Staff.[First Name]
FROM (tbl_Organisation INNER JOIN tbl_Event ON tbl_Organisation.OrganisationID = tbl_Event.OrganisationID) INNER JOIN tbl_Staff ON tbl_Event.StaffID = tbl_Staff.StaffID
WHERE (((tbl_Event.Date) Between [Forms]![frm_Event]![txt_Date_After] And [Forms]![frm_Event]![txt_Date_Before]))
ORDER BY tbl_Event.Date DESC;

I have a basic understanding of VBA but are not to good with recordsets etc.

Any assistance would be gratefully appreciated.

Thank you

Grant Beinke