Using VB5 (sp3)
I have a form with a data control (Data1) a dbGrid control (dbGrid1), a Command Button (Command1) and 3 Text Boxes (Text1, Text2, Text3)
I have a Database structure consisting of
Field1 - Book Name (eg B1, B2, B3 etc)
Field2 - Boot Type (eg T1, T2, T3 ext)
Field3 - Date (Any Date you want to enter)
The Data1 databaseName is "Book1.mdb"
The RecordType is "Dynaset"
The RecordSource is "BT" (for Book Type Table)
The dbGrid DataSource is Data1
How do I get dbGrid1 to fill with records where the Book Type Name is "T2" (or whatever booktype is entered into Text1) and the dates are between whatever Dates are entered into text2 and text3