Hello,

I have a problem with ComboBox. I want to have a ComboBox which by default source shows DlookUp source and which have "List" where I can choose some item. (When I choose item, ComboBox not updating tables)

So...

I have tables "Orders", "Companies". Those tables don't have any connection. So I have a form with "ID" and "Address" (from table "Orders") Textboxes and created ComboBox which have a list with "Companies" (in "RowSource" I Selected all "Companies" from table "Companies").

Working fine, I can choose "Company", but now I need first to show me by default "Service Company" from table "Orders". I was trying to set in DefaulsSource "Dlookup" function, it working but when I choose form then list some "Company" and going to then next record ComboBox not shows me Dlookup function, it shows me that item which I was selected before.

Where I must use DLookUp function which working when I going to the record, but still I can select item from the list.

Thanks