Hi. Althoughoften times I may think there must be an easy & simple solution to my inquiry, it never seems to work out that way for me. The reason being is, my database is probably improperly designed in many ways. Still, many members here are incredibly patient with me & try to help me at their best. So, I have a form that has a subform linked (or rather joined) together by 'WkDys' fld (the days of the week). In my main form I’m trying to create a combo box in the 'WkDy' fld on my main form to select that same weekday in my sub-form. No, I do not have the weekday field in 2-tables, however, for the weekday’s fields are from 2-different queries based on a date if the date field is ‘TodyDate’ then for the weekday field I have, Wkdy: Format [TodyDate], “ddd”}. I’m sure that it was unnecessary to tell you that, but I wanted you to know where the ‘weekdays’ field came from 2-different queries/tables. Already I feel like I’m talking out of my a**, but then again nobody needs to reply to my post if it sounds so senseless. If I may add, in the Row Source for the Combo Box, I thought by selecting the query from my sub-form & choosing the weekday field from that query. Then I thought I could pull up a particular weekday on my subform by selecting that same day of the week from my main form. I figured maybe, if I can link the 2-forms together based on the 'WkDy' fld from both forms than why can't I select any particular weekday from my main form & see the second form (sub-form) corresponding with the same weekday. When I tried to run the form & tried selecting weekday from my combo box of course nothing happened. When I click on the Combo box I do see a list of 7-days of theweek, but I cannot select any of them. I'm sure that I'm probably making any sense here at all. I do have a seperate table containing just the 7-days of the week & a sorting order fld. I have the days of the week set as the Primary Key. Here is an example of that table:
WkdyID WkdySort Sun 1 Mon 2 Tue 3 Wed 4 Thu 5 Fri 6 Sat 7
Usually, when I need to create queries involving weekdays I want them to run Sun through Sat. That is just my way of creating weekday-related queries; may it be right or wrong. I only mentioned this table called, 'WkDys_tbl' because although I knew that it wouldn't work, I tried just using this 'WkDys_tbl' as for my Row Source wondering if could pull up the corresponding weekday in the subform. As I said, I knew that idea wasn’t going to work for me. I’m including an image of my form which may provide you with a better understanding. Instead of having to go through all of the weekdays on my main form by selecting the Previous Record or the Next Record controls, I would like to have the option to pull up a certain weekday (on the subform) from the main form by using a Combo Box shown in my illustration3. I feel like an idiot, but I’m just trying to learn as I go along
Any advice/suggestions would be greatly appreciated! Thanks in advance!
Dammit , I'm unable to attached the image i wanted to present. Always have this trouble.