Thanks guy's i maybe should have narrowed it down further, the combo box source is based on a folder name as follows
When an invoice is paid, there is a folder generated and a file renamed and saved in that folder
Then a record is edited with a paid date, the combo box is populated by a folder name
in the meantime i will try suggestions you have very kindly advised or now you know the combo source, maybe you guy's would have 1 answer rather an options
Code:
Me.cboOptions.RowSource = ""Me.cboOptions.Requery
Me.cboOptions.RowSource = "Value List"
Me.cboOptions.RowSource = ""
Set fs2 = CreateObject("Scripting.FileSystemObject")
Set fl2 = fs2.getfolder("T:\MyFolder\PDF\") THIS PATH I HAVE CHANGED FOR POSTING
Set sf2 = fl2.SubFolders
For Each fl2 In sf2
iFld = iFld + 1
Me.cboOptions.AddItem fl2.Name
Next
Me.cboOptions.Requery