I have created 2 tables -
Main -
1-ID - Autonumber
2-Company Name
3-Subject
Child
1-ID - Autonumber
2-MainID - connected to Table Main - ID
3-RemarkDate
4-Remarks
Based on these I created the following:
1-Main Form - with all the data entry
2-Report - shows company name, ID, listed all the dates and remarks under the Main ID
On the form, I need a button to get for me the specific report for Main ID 1.
What I did was create a query where it ask the ID Number. If you put let say "10", all the details for 10 taken from the Child Table will appear. This is what I am trying to eliminate. on the form, I am already in ID 10, when I press the button for the report, it still ask me what ID number to get.
I need that since I am already in the form 10, when you click the report button, report 10 will appear and not ask as mentioned above.
Thank you for the assistance.
Trident