subform filter

  1. R

    Filter Report with SubForm after filtering from Form - Confused already?

    Hi everyone, I wonder if you are able to assist me at all? I am using Access 2010 and am attempting to build an internal skills database for my organisation. I am almost there, but am struggling with the final hurdle... I have designed a form, which opens automatically when the database is...
  2. S

    Optional Filters based on Combo Boxes

    I have a tab page with a data sheet subform that lists all the records for the linked field in the master form. I am trying to set up two simple filters on the tab page with unbound combo boxes using this approach: Private Sub ComboFilterSpp_AfterUpdate() If IsNull(Me.ComboFilterSpp) Then...
  3. 8

    Glitch in subform/main form linking?

    On my form I have a list box containing manager names. Below that list box is a subform. This subform shows the multiple store associated with that manager, multiple programs associated with each store, a percentage for each program, and a yes/no column. The form is used to add and delete...
  4. K

    Subform Filter from Mainform ComboBox

    Hi guys, 1st time poster, long time lurker ; ) I know this issue has been covered a number of times, but I've been experiencing problems applying the various solutions listed to my problem. Basically, I have a form (frmCompany) which lists Company Details and a linked subform...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top