Append only Null records in table

[accesshacker]

Hello,
I am trying to use an Append Query, based on data from a form, to append
Null fields in a table. When I execute the Append Query, it is appending all
records in the 4 fields to the new data.

I am using a continous form to add records to the table and want to append 4
fields without having to type in the data for each record.

Any help will be appreciated. Thanks!

 

[KARL DEWEY]

Post your query SQL.

 

[accesshacker]

Actually figured out by placing in the criteria of the Append Query the
control name on the form and in the 'or' section put in Is Null for the
fields that contained the Null value and it is now working fine.

Thank you for the quick response though!