Creating a new record on a form maintaining one of the keys

[SyuRi]

I'm creating a database on Access where to manage the products some farmers have. Now, i created a form from a table that relates the FarmerID with ProductID (both primary keys). I put a button to create a new record, but as expected, it asks the input of the FarmerID and ProductID. I wanted that by clicking the "add new product" button, it would already know it's for the Farmer i'm vieweing, so i would only need to input the ProductID. How can i do it?



Relevant info: For each farmer i click on "manage products", where i put the condition [FarmerID]=[Forms]![F_Farmer]![FarmerID], so that the manage products window only shows entries with FarmerID = the one i selected. Now clicking on the new entry, as it shows on the 3rd pic, has neither FarmerID nor ProductID, but if the Farmer is FarmerID=2 like the pictures i wanted to add the product for that farmer without having to enter FarmerID again.

[apr pillai]

1. Design a separate Form for Manage Products (a contineous Form is better)and insert it on the Main Form as a sub-form.
2. Click on the sub-form to select it.
3. Display it's Property Sheet (F4).
4. Type FarmerID on the Link Master Field Property.
5. Type FarmerID on the Link Child Field Property (assuming that you have a FarmerID field on the Products Table and don't define this as Primary Key).
6. Save the Forms and open the Main Form in Normal View.
7. Select a FarmerID on the Main-Form.

You will see the same FarmerID is appearing on the Sub-Form also.

[SyuRi]

Thank you it worked