How do you Populate a field on a form based on a field in another form ?
I have a form to enter new donations for donors and one of the fields for describing donations is [catagory] and one selection choice is "Gift In Kind". The table for Catagory is Donations. I have another Table named GIK where a decription of any Gift In Kind is to be entered. The Donations and GIK tables linked by the Receipt_Number field in both tables.
I have a form for the GIK table called GIKForm which opens up on the after update event for the catagory field if the user selects "Gift In Kind" But I want it to open up with the Receipt_Number field already populated with the receipt_number from the main form. I see that it is done in a sub form, but do not want to have a subform in the main form. I do not want this form to appear unless the Gift In Kind is selcted.
I know this is basic stuff, but I have looked at the code for the subforms I have and cannot figure out how those forms get the linked field to be populated by the correct data from the main form. I would really like to have the form pop up as a single line item to enter the descrition and have it tied automatically to teh same receipt_number (i.e., not actually have the receipt_Number filed visible on the GIK Form, just know it is the correct receipt number from the main form).
I have a form to enter new donations for donors and one of the fields for describing donations is [catagory] and one selection choice is "Gift In Kind". The table for Catagory is Donations. I have another Table named GIK where a decription of any Gift In Kind is to be entered. The Donations and GIK tables linked by the Receipt_Number field in both tables.
I have a form for the GIK table called GIKForm which opens up on the after update event for the catagory field if the user selects "Gift In Kind" But I want it to open up with the Receipt_Number field already populated with the receipt_number from the main form. I see that it is done in a sub form, but do not want to have a subform in the main form. I do not want this form to appear unless the Gift In Kind is selcted.
I know this is basic stuff, but I have looked at the code for the subforms I have and cannot figure out how those forms get the linked field to be populated by the correct data from the main form. I would really like to have the form pop up as a single line item to enter the descrition and have it tied automatically to teh same receipt_number (i.e., not actually have the receipt_Number filed visible on the GIK Form, just know it is the correct receipt number from the main form).
Last edited: