hello
i have form1 - form2 - table1 - query1
form1 contains textbox with specific value
query1 bring data from table1
form2 (data source query1) show data from query1 (ID like the textbox on the form1)
if i run the query1 it will ask me to give input so i add any number the query will run correctly
but when i open the form i dont get any data
this what i write in the criteria section for the id
i have form1 - form2 - table1 - query1
form1 contains textbox with specific value
query1 bring data from table1
form2 (data source query1) show data from query1 (ID like the textbox on the form1)
if i run the query1 it will ask me to give input so i add any number the query will run correctly
but when i open the form i dont get any data
this what i write in the criteria section for the id
Code:
[Forms]![frm_Personal_Main]![PID]