Hi all, I don't really have a problem for anyone to solve but I do have a question as to a difference I found between Access 97 and 2000.
I am in the process of converting some 97 databases to 2000. I am doing this by simply using the convert option within Access 2000. I thought things would have been pretty straight forward, but the first database I converted didn't work the same way as it did in A97. The first difference I found is that I have a button on a form which has the following code.
Private Sub cmdSearchAM_Click()
DoCmd.ApplyFilter "qryAMSearchFilter"
Me.AMFilterInput = Null
End Sub
The query "qryAMSearchFilter" looks at the combobox AMFilterInput which is on my form. In A97 I could simply pick different names from the combobox and then each time I clicked my button it would filter the form correctly, however in A2000 this isn't the case and I have had to do the following.
Private Sub cmdSearchAM_Click()
Me.Requery
DoCmd.ApplyFilter "qryAMSearchFilter"
Me.AMFilterInput = Null
End Sub
Would somebody be able to explain to me why this is now happening and if there are any other things I should be aware of when converting to A2000 from A97.
If anybody thinks my solution to my initial problem is wrong could you let me know, even though it seems to work I don't know if it the appropriate fix.
Cheers,
Steven.
I am in the process of converting some 97 databases to 2000. I am doing this by simply using the convert option within Access 2000. I thought things would have been pretty straight forward, but the first database I converted didn't work the same way as it did in A97. The first difference I found is that I have a button on a form which has the following code.
Private Sub cmdSearchAM_Click()
DoCmd.ApplyFilter "qryAMSearchFilter"
Me.AMFilterInput = Null
End Sub
The query "qryAMSearchFilter" looks at the combobox AMFilterInput which is on my form. In A97 I could simply pick different names from the combobox and then each time I clicked my button it would filter the form correctly, however in A2000 this isn't the case and I have had to do the following.
Private Sub cmdSearchAM_Click()
Me.Requery
DoCmd.ApplyFilter "qryAMSearchFilter"
Me.AMFilterInput = Null
End Sub
Would somebody be able to explain to me why this is now happening and if there are any other things I should be aware of when converting to A2000 from A97.
If anybody thinks my solution to my initial problem is wrong could you let me know, even though it seems to work I don't know if it the appropriate fix.
Cheers,
Steven.
