Search results

  1. P

    Combo Box Selection/filter not applying when using Navigation Form

    Hi, This format isnt working. I get the same prompt: Take a look at my set up: Navigation Form =Main Subform =frmDateSelection (Mapped onto "Report" button) frmDateSelection has a Combo box "cboMonth" frmDateSelection has a Command Button "Open Report" which when clicked, should open the...
  2. P

    Combo Box Selection/filter not applying when using Navigation Form

    Hi there, I have created a Navigation form thinking it would ease form and report navigation. I have added my forms to Navigation buttons. However, when for instance i want to generate a report, i click on the report Navigation button with the form, the form is displayed but when i choose the...
  3. P

    Navigation Form, Combobox Not Working

    Hi there, Am having the same problem and the "Allow Edits" property is set to Yes. Is it that we must use the format mentioned of Forms!YourMainFormName.YourSubformContainerName.Form.YourControlName in conjunction with the "All Edits" =Yes? I just dont want to mess up before knowing the right...
  4. P

    Using Combo Box to select a month and return records for only that month

    This works perfect too. After recreating the query, it worked well.
  5. P

    Using Combo Box to select a month and return records for only that month

    My problem solved. Thank you so much for the help.. I appreciate..
  6. P

    Using Combo Box to select a month and return records for only that month

    Its interesting how perfect your solution is with the sample DB. I cant tell why for some reason, on my DB, the combo box is empty after using the Select Statement provided. I have properly substituted the table name but the drop down is empty. I have attached my DB. Please help look at it...
  7. P

    Using Combo Box to select a month and return records for only that month

    Hi there, My response is late because of the difference in the time zoom. See the attached sample DB 1. There are 3 table but for this query in question, am using tblAdvances 2. The query I want to run is QryAllAdvances 3. And the form I want to read the month from is frmDateSelection...
  8. P

    Using Combo Box to select a month and return records for only that month

    Hi arnelgp, My reply is kinda delayed but its because am on a different time zoom. Where should i use this select statement? It looks like the criteria but not sure where to use it at. Am new to access, i haven't grasped most of the basics. Thanks
  9. P

    Using Combo Box to select a month and return records for only that month

    Thanks for this. However, the query instead returns duplicate months. E.g The combo box lists each unique date in may,, so if my table has records for 5/1/2020, 5/2/2020, and 5/3/2020, then there are 3 items with May 2020 in the combo box list. See attached snap. Th criteria doesn't seem to work...
  10. P

    Using Combo Box to select a month and return records for only that month

    Its 1
  11. P

    Using Combo Box to select a month and return records for only that month

    The Bound Column is set to 1
  12. P

    New member, new to access

    Hi team, just joined this forum. I am a complete newbie to access and bare with me if my posts are kinda vague. Thanks
  13. P

    Using Combo Box to select a month and return records for only that month

    No, it only has dates..
  14. P

    Using Combo Box to select a month and return records for only that month

    Hi there, Am new to access and trying to accomplish something with combo box. So i have created a combo box on a form where a i can select a month (e.g May 2020). Then when i run a query, it should return only transactions for the selected month. How do i add the combo box selection (of the...
Top Bottom