All of my forms are loaded based on the member_id of the record displayed in the main form. The member_id is passed during the form load event and by the forms open arguments. When I review the filter properties of the forms that still hold the filter, I get Filter=[GROWER].[MEMBER_ID]=39, which is the member_id of the record displayed on the main form.
But I've lost my filters for my edit forms, which again is loaded based on the main forms member_id record.
How can I reestablish this filter while editing my forms properties form filter? I've tried to enter [GROWER].[MEMBER_ID] but this does not work.
So now, when I open my edit form, in the bottom left corner it states that this is 50 of 200 records and says that it's unfiltered. While it should only be 1 of 1 record.
CementCarver