here is a visual example of the form that i am about to ask for help with because i don't know if it would make much sense without it.
So the way that the form is set up is that there are thee sub-forms on it, there is no main form. You can see what the three sub-forms are because of the different color of the labels.
On the first sub-form (Batch Query - located on the left side of the picture) I want to be able to put in a batch number and it will populate all the serial numbers that are assigned to that batch (which i already have it doing where it populates the list below where you put in the batch).
Then i want to be able to click on one of the serial numbers from the list and have it apply a filter to the other two sub-forms.
all the tables have serial numbers and what i am trying to accomplish is a data entry form so i need to have the two other sub-forms on the same record to accomplish this.
I am self taught at access so i have hit a huge wall because i can't figure this one out. The only solution I have been able to come up with is setting the selected serial number to a string or a tempvar so that i can use it as the criteria in a filter, but i do not know how to set a string or tempvar, so that didn't work very well for me.
If anyone knows of anyway that i can accomplish this task it would be of great help to me. thank you so much in advance. I hope this all made sense i can clarify more if needed.
So the way that the form is set up is that there are thee sub-forms on it, there is no main form. You can see what the three sub-forms are because of the different color of the labels.
On the first sub-form (Batch Query - located on the left side of the picture) I want to be able to put in a batch number and it will populate all the serial numbers that are assigned to that batch (which i already have it doing where it populates the list below where you put in the batch).
Then i want to be able to click on one of the serial numbers from the list and have it apply a filter to the other two sub-forms.
all the tables have serial numbers and what i am trying to accomplish is a data entry form so i need to have the two other sub-forms on the same record to accomplish this.
I am self taught at access so i have hit a huge wall because i can't figure this one out. The only solution I have been able to come up with is setting the selected serial number to a string or a tempvar so that i can use it as the criteria in a filter, but i do not know how to set a string or tempvar, so that didn't work very well for me.
If anyone knows of anyway that i can accomplish this task it would be of great help to me. thank you so much in advance. I hope this all made sense i can clarify more if needed.
