Visual Basic..................................

[keys]

im using access and visual basic as the code behind it. i want to enable a button only when the date in a text box is the same as in the database column (date). any part of the column on the bottom of the column or top or middle. this only works with the top (top row).

Thanks.......

[Tweed]

Have you tried traversing the whole column?

[keys]

no, wot is traversing?

[Tweed]

Traversing, go through every date in that column, if you find a match then enable the button.

[keys]

Thanks

Do you know wot coding i need? I dont know how to search through the columns. do u have an example of any kind.

thx

[Tweed]

It's been a while, but try:

DataBase.Recordset.Index = "FieldName"

DataBase.Recordset.Seek "=", SearchStr 'do the search
If DataBase.Recordset.NoMatch = false Then

   Button1.enabled = true        'enable the button
End If

where:

DataBase is the name of your database

FieldName is the column you want to search

SearchStr is the date you want to find