Hello I have a sample db attached- microsoft accesss
main form- 3 subforms
if you open database a form opens:
*this may be not able to do -or hard*
enter 111 in serial number
select 159355 in item number
enter 1111111 in SO number
The two subforms on the right - i am concerned with
The top right subform labeled 'installed parts'?
it is working good- only SO number 1111111 and p/n 159355 display
The bottom lower right hand subform labeled 'repair history'
is not working good.
i want to only see SO number 1111111 and Part_number 159355
If you notice it displays 1591
can you make that subform only display so number 1111111 and Part_number 159355?
right now it is joining on SO number - but displays all Part_Numbers