Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

match

Discussion in 'Information Technology' started by Chey, Jul 28, 2006.

Tags:
  1. Chey

    Chey
    Expand Collapse
    Guest

    I have a combo box with a list of months-text
    I alos have date field that only shows month. When the form opens I want
    the two fields to match. However I have one in a date field and one in a
    text field. I don't know what to do. When I choose my month from the combo
    box, it filters my form. I would like for it to do that. The current code I
    have is
    Private Sub Combo87_AfterUpdate()
    Me.Filter = "[tblGrantCompletion.theMonth] = '" & Me.Combo87 & "'"
    Me.FilterOn = True

    End Sub

    tblGrantCompletion.theMonth is a text field. I can not at this time change
    it to a date field. I gives me error messages and won't perform the task.
    Thanks
     
  2. Loading...

    Similar Threads Forum Date
    GurmatChanan Updates Gurbani Download Aug 27, 2011
    India Manmohan invites Zardari, Gilani for India-Pakistan match Breaking News Mar 26, 2011
    Harbhajan hits his maiden test century,saves match for India Sports & Fitness Nov 9, 2010
    Arranged marriage? Or Love-match? Insights, Prospects for the future Love & Marriage Oct 11, 2010
    Wimbledon tennis epic ends in games (183 of them), set and match Sports & Fitness Jun 26, 2010

  3. default105

    default105
    Expand Collapse
    Guest

    try
    Private Sub Combo87_AfterUpdate()
    Me.Filter = "[tblGrantCompletion.theMonth] = #" & Me.Combo87 & "#"
    Me.FilterOn = True


    "Chey" wrote:

    > I have a combo box with a list of months-text
    > I alos have date field that only shows month. When the form opens I want
    > the two fields to match. However I have one in a date field and one in a
    > text field. I don't know what to do. When I choose my month from the combo
    > box, it filters my form. I would like for it to do that. The current code I
    > have is
    > Private Sub Combo87_AfterUpdate()
    > Me.Filter = "[tblGrantCompletion.theMonth] = '" & Me.Combo87 & "'"
    > Me.FilterOn = True
    >
    > End Sub
    >
    > tblGrantCompletion.theMonth is a text field. I can not at this time change
    > it to a date field. I gives me error messages and won't perform the task.
    > Thanks
     
  4. Chey

    Chey
    Expand Collapse
    Guest

    I tired this and nothing happened. I actually want it to go under on open.
    So the drop down box will choose the month that matches my date field, and
    filter I want to leave the combo box alown when it comes to the filtering
    part. I still want to be able to choose a different month and it filter. I
    use the months to log in billing forms. That is why I would like to match my
    date field. I have it formated to make the current billing month visiable.
    Thanks

    "default105" wrote:

    > try
    > Private Sub Combo87_AfterUpdate()
    > Me.Filter = "[tblGrantCompletion.theMonth] = #" & Me.Combo87 & "#"
    > Me.FilterOn = True
    >
    >
    > "Chey" wrote:
    >
    > > I have a combo box with a list of months-text
    > > I alos have date field that only shows month. When the form opens I want
    > > the two fields to match. However I have one in a date field and one in a
    > > text field. I don't know what to do. When I choose my month from the combo
    > > box, it filters my form. I would like for it to do that. The current code I
    > > have is
    > > Private Sub Combo87_AfterUpdate()
    > > Me.Filter = "[tblGrantCompletion.theMonth] = '" & Me.Combo87 & "'"
    > > Me.FilterOn = True
    > >
    > > End Sub
    > >
    > > tblGrantCompletion.theMonth is a text field. I can not at this time change
    > > it to a date field. I gives me error messages and won't perform the task.
    > > Thanks
     

Share This Page