The Situation
I have a form (frmDETAILED) with three fields: cboDESCRIPTION, cboCONCEPT and cboSUBCONCEPT. Now, cboDESCRIPTION look at tblDESCRIPTIONS. Also tblDESCRIPTIONS have the defaults values for cboCONCEPT and cboSUBCONCEPT; but cboCONCEPTS and cboSUBCONCEPTS fields get their values from tblCONCEPTS and tblSUBCONCEPTS.
My Problem
I and needing that after a select a value in cboDESCRIPTION, cboCONCEPT and cboSUBCONCEPT get the default value assigned in tblDESCRIPTIONS, but still be able to change it from their current sources.
What I Have Tried
I try using DLookUp (=DLookUp("[cboCONCEPT]","tblDESCRIPTIONS"," [cboDESCRIPTION] = & Form![frmDETAILED]![cboDESCRIPTION] &") but is not working.
I am not looking for a cascading method. I just need that after updating combo box, another combo box get a default value based on the data from the updated combo box.
Notes
The frmDETAILED record cboDESCRIPTION, cboCONCEPT and cboSUBCONCEPT values at tblDETAILED (along with other data)
I am a mid level user, with little knowledge about Access programming codes. My experience on this is limited to copy/paste internet codes and name changing to adjust it to my necessities.