I have a form (FRM_X) that that has a text box w/ the primary key value (Dir Num). I also have a subform inside FRM_X called FORM_X_sub.
I am trying to create a query for the subform that retrieves records like the value in the Dir Num text box.
My main concern is that I also have several other forms similar to FRM_X. Is there away to change this code to say "i want all values like Dir Num in current form". Reason why I ask is because I would not like to create several of the same queries w/ slight modifications. I just want one query vs. many.
I have come up with this for the criteria input:
QRY 1: Like ([FORMS]![FRM_X].[Dir Num])
My idea: "Like ([Current Form].[Dir Num])" --> im looking for syntax???
I hope I explained this correctly, so if anyone can give any tips or solutions please help, thanks.
I am trying to create a query for the subform that retrieves records like the value in the Dir Num text box.
My main concern is that I also have several other forms similar to FRM_X. Is there away to change this code to say "i want all values like Dir Num in current form". Reason why I ask is because I would not like to create several of the same queries w/ slight modifications. I just want one query vs. many.
I have come up with this for the criteria input:
QRY 1: Like ([FORMS]![FRM_X].[Dir Num])
My idea: "Like ([Current Form].[Dir Num])" --> im looking for syntax???
I hope I explained this correctly, so if anyone can give any tips or solutions please help, thanks.