M
Maver911
what im needing to do is, first off i have 3 different subforms all in
datasheet format. each one are on separate queries. the first one is a list
of store numbers, the second, upcs and the last one is a compilation of store
numbers and upcs of different sort and from the last query. Naturally as an
end result im trying to take each single record from the first subform and
each single record from the second and combine the two to see if i cant find
a match in the third subform. If it isnt in the third then i want to be able
to toss the upc from the second subform into a listbox for later reporting.
Im having problems thinking of ways to loop through the subforms to extract
the information. Ive thought about making queries that do this operation and
havent thought of a way so im resorting to forms. If anyone has any
suggestions or comments please let me know. much abliged. thankyou.
datasheet format. each one are on separate queries. the first one is a list
of store numbers, the second, upcs and the last one is a compilation of store
numbers and upcs of different sort and from the last query. Naturally as an
end result im trying to take each single record from the first subform and
each single record from the second and combine the two to see if i cant find
a match in the third subform. If it isnt in the third then i want to be able
to toss the upc from the second subform into a listbox for later reporting.
Im having problems thinking of ways to loop through the subforms to extract
the information. Ive thought about making queries that do this operation and
havent thought of a way so im resorting to forms. If anyone has any
suggestions or comments please let me know. much abliged. thankyou.