Hello,
I have created a "calendar grid" on a subform in this way:
I have 12 rows of unbound textboxes, 31 textboxes per row. The 12 rows correspond to 12 months and 31 textboxes per row represents up to 31 days in a month. I have named each unbound textbox as "01/01" for the first row first column textbox, "01/02" for the first row second textbox, and so on up to the last row last column textbox which is "12/31".
I have a select query that returns the date and a one or two letter symbol for an event that happens on that date (e.g. date = "04/05" and symbol = "A"). What I would like to do is have the "A" appear in the unbound textbox named "04/05" which corresponds to the date that this event took place.
What is the best way to make this happen? Also, maybe there is a better way to do this than my line of thinking. Any help or suggestion is welcome.
thank you,
Rey
I have created a "calendar grid" on a subform in this way:
I have 12 rows of unbound textboxes, 31 textboxes per row. The 12 rows correspond to 12 months and 31 textboxes per row represents up to 31 days in a month. I have named each unbound textbox as "01/01" for the first row first column textbox, "01/02" for the first row second textbox, and so on up to the last row last column textbox which is "12/31".
I have a select query that returns the date and a one or two letter symbol for an event that happens on that date (e.g. date = "04/05" and symbol = "A"). What I would like to do is have the "A" appear in the unbound textbox named "04/05" which corresponds to the date that this event took place.
What is the best way to make this happen? Also, maybe there is a better way to do this than my line of thinking. Any help or suggestion is welcome.
thank you,
Rey