Is the dlookup giving you the expected value? (use debug.print DLookup("[PrintOptionFormat]", "tbeFixtureSchedulePrintOptions") to see if it is)
If the lookup is giving you the correct value you will likely have to program for the value being missing
so assuming you have a front end for each person and there is either 1 or 0 records in the table tbeFixtureSchedulePrintOptions you would have
Code:
if dcount("*", "tbeFixtureSchedulePrintOptions") > 0 Then
frmPrintOptionFormat = dlookup("[PrintOptionFormat]", "tbeFixtureSchedulePrintOptions")
else
frmPrintOptionFormat = 'put in whatever your 'default' value is here
endif
you may also have to do a conversion on the dlookup, sometimes dlookup will make a number behave like a string but I would check to see if your dlookup is actually giving you the value you expect first, if it's not you have other things going on.