how to refer value from a main form into a subform.

[biscuitmunchy]

I'm trying to refer the data from the field "SearchResult" listbox (highlighted red) in the FRM_searchMulti into "ID" TxtBox (highlighted blue) in the "RecordsForms" Sub Form.



My idea is to built and inventory control.. worker has to search the item in "FRM_searchmulti" form and click on " Stock in/out" command_click in main form, it will open sub form "RecordsForms" and fill all the info.


"Frm_SearchMulti" i got this from uncle google, is to search in PartInvetory table
"RecordsForms" i use sSQL = "SELECT to fill the info from PartInvetory table

The problem is i want to refer the "ID" in Main form to "ID" in Sub form..
so when worker click command_click in main form, it will open sub form and fill all the info.

any idea


I'm new in Access and Please someone help me.





attach is my work for references, i'm afraid i'm not good in explanation.


Thanks..

[ranman256]

Open the item detail from the search form using the key in the textbox...
doCmd.OpenForm "frmDetail",,,"[id]=" & me.txtID

[ssanfu]

The syntax can be tricky.....
You might look at http://access.mvps.org/access/forms/frm0031.htm

[biscuitmunchy]

Hi ranman thanks for the answer, but i'm sorry, i do not understand your instruction. where should i put this doCmd.OpenForm "frmDetail",,,"[id]=" & me.txtID.. I'm very noob sorry

https://wetransfer.com/downloads/dee...9080319/c2d8a2