Consulting

Results 1 to 3 of 3

Thread: Form Will Not Stay Maximized

  1. #1
    VBAX Regular VWP1's Avatar
    Joined
    Sep 2011
    Posts
    7
    Location

    Form Will Not Stay Maximized

    I am trying to keep my forms maximized, but sometimes, the form will end up non-maximized; this is to say that the form, while not minimized, refuses to get maximized, unless I go into design view, then back out to form view again. I double click on the title bar, but I'd prefer not to ever have to do that....
    I am using

    Private Sub Form_Open (Cancel as Integer)
    DoCmd.Maximize
    End Sub

    Private Sub Form_Current()
    DoCmd.Maximize
    End Sub

    Please help! What else do I need?

  2. #2
    Try using the form's On Activate event.

    [VBA]Private Sub Form_Activate()
    DoCmd.Maximize
    End Sub[/VBA]
    Boyd Trimmell aka HiTechCoach
    Microsoft Access MVP -2010-2015

    Programming: Nine different ways to do it right, a thousand ways to do it wrong.
    Binary--it's as easy as 1-10-11

  3. #3
    VBAX Regular VWP1's Avatar
    Joined
    Sep 2011
    Posts
    7
    Location

    Filter Records on Subform (continuous) according to Value in Combo Box on Parent Form

    This is a new posting, for a new problem, but I cannot seem to locate any button for a new post,...SO....

    Here is my situation:
    I wish to filter the records on a subform (continuous) according to numeric value in a combo box on the parent form. I do not want the properties linked permanently, as the parent form is set to Data Entry.

    When the null combo box (on the parent data entry form) is given a value (by selecting a line item), there is an AfterUpdate event (as well as a new record) and that AfterUpdate occurs, I would like the subform's coninuous recordset to THEN...and only then...to become filtered.

    The parent form is data entry for a new lesson. The lesson name is a textbox, and the category of the lesson is the combo box. Now, the subform begins with displaying the entire list of lessons (non-filtered, and non-linked to parent form).

    Upon selecting the category (during the data entry process), I would like the subform to be filtered according to the new record's category on the parent form; the master list of lessons is on the subform (to help avoid repeating an existing lesson).

    For example, when the data entry form (parent form) opens, it awaits new data, but the subform lists all the lessons (no link to parent form). Upon entering a new lesson name and category, the subform's "master list" becomes filtered after the new category is selected in the parent form's combo box. The filtering will use the subform's category field.

    In other words, the subform has a listing of all the lessons, each, with its category. Upon selecting the category (parent form's combo box) for the new record, the subform uses that value (a number) to filter against the subform's matching category list.

    No clue how to do this....

    Private Sub ParentFormCategoryComboBox_AfterUpdate()
    If Me.ParentFormCategoryComboBox IsNull
    Then Do Not Filter Me.Subform
    Else Me.Subform.[categoryID] =Me.ParentFormCategoryComboBox
    End Sub

    Obviously, When the parnet data entry form opens, there will be no filtering....
    VWP1
    Novice Extraordinairre

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •