Filtering a record out of a form

[PeteVTX]

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?

 

[Maurice]

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

 

[Rick Brandt]

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?

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.

 

[PeteVTX]

That sorted it. Thanks.

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.

 

[PeteVTX]

Thanks

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