I need to add an If statement before inserting a record
I have an Insert Form that adds records to two tables.
The first insert query adds a record to PORC_records and captures the ID field.
I then have multiple fields on the form (Link1, Link2, Link3, etc.) which I want to add to the PORC_ebirdlinks table using the ID captured above and the contents of Link1, Link2, etc.
Each of those form fields will create a new record. So Link1 will be a record, Link2 will be a record, etc.
However, not all of those fields will have data, so I want an "if not null" type of condition before each of those insert queries.
I know the algorithm, just not the syntax for the coding.
I have only put two "Link" Insert Queries in so far. I will add the others once I have the "If" coding.
See attached code.