Filtering a record out of a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a make table query that produces the data that I am looking for in a
table. But the table always includes a blank line which I do not want to see
on the form that uses the table. How do I filter out this offending (blank)
record so that it does not appear on the form?
 
Make a query based on the maketable and set criteria on a specific field Not
Null
that should get rid of your unwanted record.

Or you could modify your maketable query with this criteria (Not Null) to
your specific field. That way the maketable doesn't have the empty record.

Maurice
 
PeteVTX said:
I have a make table query that produces the data that I am looking
for in a table. But the table always includes a blank line which I do
not want to see on the form that uses the table. How do I filter out
this offending (blank) record so that it does not appear on the form?
Click to expand...

Are you sure it's not just the NEW RECORD row? That is not an actual record,
but a placeholder where you can enter a new record. If you don't want to
see it on your form set the AllowAdditions property to No.
 
That sorted it. Thanks.

Rick Brandt said:
Are you sure it's not just the NEW RECORD row? That is not an actual record,
but a placeholder where you can enter a new record. If you don't want to
see it on your form set the AllowAdditions property to No.
Click to expand...
 
Thanks

Maurice said:
Make a query based on the maketable and set criteria on a specific field Not
Null
that should get rid of your unwanted record.

Or you could modify your maketable query with this criteria (Not Null) to
your specific field. That way the maketable doesn't have the empty record.

Maurice
Click to expand...
 
Back
Top