Re: .BOF and .EOF are lying!

Use .recordcount > 0 to check if the recordset is empty.
Then use move or find if you want to position at a record.

Remember that by definition .RecordsetClone is a recordset
with different record pointers than those used by the form.

Ignore whatever the help files say about .bof and .eof
for recordset clones: The help was never correct.

(david)

"Laurel" <FakeMail@xxxxxxxxxxx> wrote in message
news:OISvtztoFHA.2580@xxxxxxxxxxxxxxxxxxxxxxx
> Are there steps one should take before requerying a form with different
> retrieval arguments? If I reetrieve the data in the form and there are
> rows, and then I change the values that are used as arguments to something
> that would return no rows .EOF and .BOF are both false.
>
> If the arguemtns that would return no rows are used first, .bof and .eof
> are true as one would expect.
>
> Any suggestions?
>


.

Relevant Pages
Loading