Donald Calloway <dr********@verizon.netwrote in
news:lnvnj.7230$v86.6825@trnddc08:
I have created a database application that uses a macro, activated
by a button click event, that runs a query which returns a
recordset consisting of a subset of the matching database record,
and displays the data within a form. The query on the table
produces a recordset based on the matching criteria consisting of
a person's first and last name, or fields ClientFirstname and
ClientLastname, respectively. I've programmed the application to
display the recordset in the form only if a third field,
AgentName, in the record has a null value. If the AgentName field
is not null, then no record is displayed because the query will
return a null recordset.
Now, with this backdrop, here is my goal: I'm trying to determine
the VBA code that would determine whether a recordset returned by
a query is null or not. Then, if the recordset is null, I want to
have other VBA code run an another query to yield the same subset
of data fields and display them in a replica of the first form,
but this time, I want to display the actual value of the AgentName
field along with the other data in the record as defined by the
form. I hope this is clear.
Essentially, what I need to know this: what is the syntax of VBA
code that can be used to determine whether or not a recordset
returned by a query is null or not null? Thanking anyone in
advance for their help with this problem.
Why go to all that trouble?
Code the onClick event to open the form directly, with the first and
last name criteria, and set a filter on the form to show only the
records with null agent_name. If the form's recordset is empty,
based on the simple test of recordcount being 0, then remove the
filter.
--
Bob Quintal
PA is y I've altered my email address.
--
Posted via a free Usenet account from
http://www.teranews.com 
