Search results for query: *

I did as you had suggested and upon correcting the typo on my part it works perfectly now. I appreciate your patience and explanations while I continue to learn the magic of Access. Thanks again.

That is what I had thought but I was not sure of the formatting to make it work. For example under link master would I just type - Months;Year; CategoryID with them separated by colons, inputting the same for Child? I am thinking this is not correct since it does not work. Once typed...

I am sorry for my continued comeback to you but my inexperience causes me to ask a couple of more questions but if I don't ask, I will never learn it right. I do understand now why you would not use the same record source for both the main and sub-form. I have now set up an unbound main form...

Reason for the 2 tables (tblCategories also) is so each of these fields on the main form can used as a combo box to make appropriate selection and then subsequently list all expenses for those choices on subform. If another category is to be selected, a new record is created and the combo...

MajP, I am sorry but apparently I don't have it set up right. When I check the properties of the subform, nothing is showing under the link master and child fields, even though I did set them up originally. As I said, this is a bit new to me and now I am confused. Below is the Sql for my...

I did change the linkage to month number, year number and category name. Upon doing this I do see now why it didn't work before. Thanks for posing that question. Now the only question I have is this. When I open a new form and select the Year, Month and category, and then enter my expense...

I am relatively new to access and have a question on a form that I have been struggling with. Below you will find the SQL of the query I am using. My primary form "ExpensesTest" is using the fields YearNumber, Months, and CategoryName. What I am trying to do is set the 3 fields above, and...