I understand. The book was informative. More than most of the books at the local book store. I have a cub question:
I'm a little confused on a concept.
The statement: "If Rst.BOF And Rst. EOF Then"
This seems to be for checking to see if there are any records
in the Rst.
What is the dif. between using this method or using
the statement: "If Rst.RecordCount <> 0 Then"

Also, the Me.Filter. Why do I need to place a filter
when loading a form? example:
Me.Filter = "([Drawing Number] <> '')"
Me.FilterOn = True
Isn't it filtered when using a "rst.open Select * Mytable,cnx"
??Does each form requires the me.filter statement?

The RecordCount will not necessarily contain the number of records in the recordset at the time you read it depending on the type of recordset you have opened, and depending on if you have navigated around in that recordset. This is particularly important when you are working with a read only cursor. No matter what, use the EOF method for determining if there are records you can process.

When first opening a recordset, your cursor is pointing at the first record if there is one. If there isn't, then it is pointing at EOF. I see a lot of sample code that checks BOF and EOF, but you only need to check BOF if you are navigating backwards.

Regarding yoiur "filter" question. I must be missing something, as a form does not have a filter. Is this Access code or something? I haven't messed around with recordset filters all that much, but the reason you might want them is to work with a subset of records in the recordset. This could potentially give you a performance improvement if getting data from the database is very costly.




Woody Z
http://www.learntoprogramnow.com
How to use a forum to help solve problems

Woody, this is largely true, but I am addressing it so that the poster will be clearer.

It is true that when you open a recordset, the first record is the current record, if there are any records.

If there are no records, both .BOF (beginning of file) and .EOF (End of File) will be true. If .EOF is true (and that's all you know) then two situations are possible: there are no records, or you have run off the end. If .BOF is true (and that's all you know) then two situations are possible: there are no records, or you have run off the beginning of the recordset.

If you have run off the end, it is manifestly obvious that you are not at the beginning...

So if both .E– [u]and</u> .BOF are true, there cannot be anything in between, you see. Checking for both guarantees that under any arrangement, if both are true the recorset is empty.

Now, again, when you open a RecSet the first record is current—so the following is never necessary:     So, since the recset is not at .BOF, but is at the first record,     is a functional shorthand to test whether any records were returned. So is

Regarding using .Filter, you can use this, or you can use restriction language in the WHERE clause of the query. With .Filter, you actually return all of the records into the recordset, but you don't see them all. This can be advantageous if you are going to chnage the filter. This removes the necessity of getting records again. But if you are never going to alter which records you see, using a WHERE clause is easier on the computer resources, and probably ever-so-slightly faster.