I hope someone can help me. I need help running a query through my forms that will display the results in a text box on the same form...Here is my situation...

I have a calendar made up of buttons(one for each day).Click on a date it will display events that were taken from another table in a text box below the calendar.... I wouldnt mind even having a subform with that information.

How can i write in VB to query that table and take the results and display then in a text box below or even make subform with the results.


Please help.

Welcome to P2P, Jennifer!

I assume the other table has a list of events (e.g. tblEvents), and in that table there is an event date field (e.g. dtmEventHeld).

Suppose you used a subform that lists the events (e.g. sfrEvents) and a date button for each day of the month (e.g. cmdDate1, cmdDate2, etc.). In the main form's date button ON CLICK event, you can put something like this:

Me.sfrEvents.SourceObject = "SELECT * FROM tblEvents WHERE [dtmEventHeld] = #" & Me.cmdDate1 & "#"



Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Oops... that should read

Me.sfrEvents.SourceObject = "SELECT * FROM tblEvents WHERE [dtmEventHeld] = #" & dtmDate & "#"

Where dtmDate is a date that is compiled when you click a specific button (e.g. cmdDate) on the main form. For example, if you click the "1" button on the mainform then you'd have to figure out which month, day, and year you're talking about and then assign it to the date dtmDate using the DateSerial function.

Dim dtmDate as Date

dtmDate = DateSerial(YYYY, MM, DD)

YYYY, MM, DD are the parts of the date you "collected" when you clicked that button. If the button said "1", then DD = 1. I don't know enough about what your form looks like to guess how you express what date you're sitting on.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

So I should put this all in the VB for the onclick event?

Here is what I have... I have a home made caledar with button named 1_1_2006, etc... This is on one form. I have added a subform called Date_Req. This has all of my events. When I click on 1_1_2006 I want the subform to just show events for that day. I hope this helps.