Fields not appearing

Now this is probably quite a simple problem, but its been driven me nuts all morning! I have created a simple database with one form in it. At some point an agent gets this document and all dependant of what is in a certain field carries out a sub routine, ie If field1 = “” then Call Sub, field1 = “Done”, End If

The problem I have is it keeps telling me field1 doesn’t exist. I’ve set a default value, still doesn’t work, tried deleting & recreating still nothing. I’ve even created another field and that didn’t work. When I debugged the code the field doesn’t appear in the ITEMS under the document. All the other fields appear. There is one difference about this field and that it was created after the form and the agent was, but that shouldn’t matter.

Any help would be greatly appreciated.

Thanks

Subject: Fields not appearing

It does matter when the field was added to the form.

The documents that are created with a form only contain the fields that were present on the form when they were created. Adding a field to a form will not add it to the documents as well. Documents have no knowledge of form changes unless you open the document and re-save it, then it checks the form design and will add any new fields.

So, if you want to add an item to a document that already exists you’ll need to run an agent to do so. A formula agent run on all documents saying FIELD Field1:=“” will do.

Dan

Subject: RE: Fields not appearing

Cheers Dan, worked perfectly.