Hi--

I'm importing new files into my database from a website and would like to use @IsNew programming (not @Add) as I initially go through and modify them, but it seems that after I import, those files are not considered new (even though it's the first time I've actually seen them).  Any suggestions?

--Nate

@IsNew is working fine, as a record is only in the "New" state if it has yet to be saved to the database.  Once it is imported, it has been saved, and thus is no longer "New".  I suggest adding a Boolean field that you can use to indicate if the record has had its first edit.  Then, you can check the state of the field in the On Form Load event in order to execute your logic, making sure to also change the state so that your logic only runs once.

Add other elements to the form used for the import: DataSource, ImportDate, ImportTime, and make the default value of the Source element = "Data Entry".  Make the elements Visible if DataSource <> "Data Entry".  This will make them visible only for imported records.

Now, import your records and retrieve records where the DataSource element is blank.

Now do a Mass Udate on the imported records to fill in the name of the data source in DataSource, and the date and time imported into the other two elements.  Now you can select all records associated with a particular import process and do additional processing as needed.

You could do some things with visibility on these extra elements, for instance only make them visible on the Retrieve Spec screen.