initiating a value for a combobox

[RuralGuy]

Import the two Linked tables into this db and then post it again. Remove any sensitive data of course.

[markjkubicki]

thanks


(try the attached)
the resistant combobox is the ony one on the page REPORTS (upper right)

[RuralGuy]

On the cbo, change the ColumnWidths to 0.1";1.5" and change the OnLoad event to:

Private Sub Form_Load()
   Dim vtext As String
   vtext = DLookup("[PresetTitle]", "tbeFixtureSchedulePrintOptions")
   Me.cboPresetOption = vtext
End Sub

...and see what happens. Without a criteria in the DLookup() function you know that it returns a random record from the Domain, right?

[markjkubicki]

that did it
THANKS FOR ALL YOUR PATIENCE !!!

btw, the table will never have more than (1) record, so I ought to be OK without a criteria for the DLookup()