I have a flat table with the following structure where I need to record events applicable to days - only one event record per day:
Even Long Text
What I need to do is create a form to display the records across the page by weekday and have them editable (hence I can't use a crosstab query). This form will actually end up as a subform displayed on top of another sub form that displays bookings records by day. That way I can see (and edit) my Events by week day and see the bookings that have been made by day below it.
I need help figuring out how to create the form to display editable records across the page. Suggestions welcome