Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. looking887

    Form w/subform

    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.
  2. looking887

    Form w/subform

    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...
  3. looking887

    Form w/subform

    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...
  4. looking887

    Form w/subform

    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...
  5. looking887

    Form w/subform

    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...
  6. looking887

    Form w/subform

    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...
  7. looking887

    Form w/subform

    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...

Part and Inventory Search

Back
Top