MonthView control 1

[cbiker]

Two Questions
1 I have a form that is associated with a table called Inspections with a field called nextinsp showing next inspection how do i get the form to show only the inspections due on the date that you click on in the monthview control named Monthviewcntrl0.

2 Can you have the dates on monthview control turn bold on the dates that have a next inspection and if so how? (MS does this in MS Money)

Thanks for the help.

 

[HomeALone]

In your On_Current event of the form, put in the following code

Private Sub Form_Current()

‘This is your answer # 1
Me.Filter = “nextinsp = Monthviewcntrl0”
Me.FilterOn = True

‘This is your answer # 2
If Not IsNull(Me!MonthViewControlName) Then
Me!MonthViewControlName.FontBold = True
Else
Me!MonthViewControlName.FontWeight = Normal
End If

End Sub

I hope this helps