hi
i have 8 textboxes and i have 16 append queries.Two for each one of the textboxes.
Each one of these Queries has a criteria equal to the textbox.
is it possible to write a loop to all textboxes and change the criteria depend on the textbox name? and i will use just two append queries
textboxes name : subject1,subject2......
criteria : =subject1,=subject2,..........
i hope it is clear
i have 8 textboxes and i have 16 append queries.Two for each one of the textboxes.
Each one of these Queries has a criteria equal to the textbox.
is it possible to write a loop to all textboxes and change the criteria depend on the textbox name? and i will use just two append queries
textboxes name : subject1,subject2......
criteria : =subject1,=subject2,..........
i hope it is clear