Ok heres the situation.
I have 2 tables Company Details and Waste Available, what happens at the minute is that i have a form showing company details which contains a sub form which shows what waste the company has available. so what happens at the minute is when i click on the sub form, you can added new materials to the waste availble table but it also only adds it to that specific company data.
What i want to do is change the form by deleting the sub forms and adding buttons, the problem im having is that when i click the button that opens the Waste Available form it shows what waste that company ahs available but when i make a new record it doesnt display company ID (its just blank), in the old form it actually keeps the company ID when you clcik add new record.
hope you can help me out, i think its got something to do with subform Master and Child Link, is there any way of having the same link on a button?
thanks
I have 2 tables Company Details and Waste Available, what happens at the minute is that i have a form showing company details which contains a sub form which shows what waste the company has available. so what happens at the minute is when i click on the sub form, you can added new materials to the waste availble table but it also only adds it to that specific company data.
What i want to do is change the form by deleting the sub forms and adding buttons, the problem im having is that when i click the button that opens the Waste Available form it shows what waste that company ahs available but when i make a new record it doesnt display company ID (its just blank), in the old form it actually keeps the company ID when you clcik add new record.
hope you can help me out, i think its got something to do with subform Master and Child Link, is there any way of having the same link on a button?
thanks
