i have a form with one sub_form .sub_form data is coming from table via combo box , now to restrict reentry in the sub form i want to hide previous entered record from combo box so that reentry will be restricted.
combo box is getting data from table1 and after adding 2 column it goes to query where it is stored .
there are 500 record in combo box so its time consuming with dlook or dcount function to restrict data for each row . it combo box itself hide the data after checking the query status then balance data can be easily entered to subform.
the following code iam using but not getting the desired results
Me.PROJNO.RowSource = "SELECT projno & iditemmaster FROM itemmaster WHERE projno & iditemmaster NOT IN (SELECT projno & iditemmaster FROM projitemmasterquery);"