Append Query problem

[yoti29]

Hi all,

I have a form which appends records in a table using a few append querys. I need the records to be written only if the control on the form is not empty/null but when I try the criteria in the query I get an error message saying "Query input must be at least one table/query".

As I see it I can either set a condition in each of the querys or set a condition on the run query command in the form. I tried both but I think I am getting the syntax wrong or something because nothing works.

I am quite new to Access so I am sorry if this question sounds a bit weird but I could really use some help and will appriciate it.

Thenks.

 

[neileg]

Wouldn't it be easier to bind the form to the table and then you won't need any append queries?

 

[tkoh78]

You can use macro for this purporse.
When you first open the macro the "condition" column is hidden. Press "condition" icon from the menu bar. (the icon next to insert rows icon)
Under condition column type the condition you want, such as [forms]![form name]![control box name] Is Not Null. Under action column, choose to open the query, and choose the query name that you want to execute. If you don't want to see the warning sign, put Setwarning action before any action, and change the argument to No. Hope this works.