Is this a one off macro to retrospectively update a load of existing records to add a new optional field to those records? If it's for a one off job to do a retrospective update, this would be a lot easier just to do a SQL update.

Yes it is - but my SQL update skills are lacking too.  I would need to know what values to insert into every field, correct?  Whereas with a macro, I only need the Optional Field name.  Open to suggestions though...  It certainly would be a lot faster in SQL.

Yes it is - but my SQL update skills are lacking too.  I would need to know what values to insert into every field, correct?  Whereas with a macro, I only need the Optional Field name.  Open to suggestions though...  It certainly would be a lot faster in SQL.

I'd suggest you determine the range of ORDUNIQ values to simplify - the default index for the view is ORDUNIQ.  You can change the index, but risk issues on updating the view.

Here's a basic Browse / Fetch Loop:

OEORD1header.Browse ("ORDUNIQ >= 1000 AND ORDUNIQ <=9000 AND TYPE = 3"), True
Do While OEORD1header.Fetch = True

'Do some stuff with Optional Fields

Loop
MsgBox "It's Miller Time!"

Looks great!  Thanks.  I might leave the message box just as you suggested.