counting records displayed on a form

[Joan]

Hi there,

Can I do a record count on a form? If so how. Why? I'd like to use it if I can in a query or something (I'm not sure). Here's what am I trying to do.

If a sub-form has no records on it, I would like to send the main-table information to a report. The report should show all records from the main table where the sub-form number of records is = 0. Please tell me this can be done somehow? It seemed easy in my thought process but I can't even figure out how to do the record count for the form. I tried to use an unbound txt box, but it didn't show anything.

Thanks in advance for any advice,

Joan

 

[Jeff Boyce]

Joan

The typical arrangement of a main form/sub form is based on the one-to-many
relationship of the underlying data. I am confused by your description,
which sounds like you want to use the subform to "drive" your main form.

 

[Joan]

Thanks for your reply. I found what I was looking to do was to find unmatched records - basically to report on so the user can go back and perform functions necessary.
I created a query using wizard to find unmatched records between my main table and 'subtable' information.

Shawna