I have a form which consists of customer records. On that main form I have a sub-form that shows the contracts associated with the current customer that is being shown on the form.
What I want to do is open another form based on what contract is currently showing in the sub-form.
Which will be the best way to complete this action?
Have the new forms data source query criteria set to open based on the sub-form
or
Have nothing in the new forms data source query criteria and use VBA on the command button.
I tried setting the criteria on the new forms data source query criteria but can't get it to work.
Like [forms]![sub-form].[field_name]
Like [forms]![main-form]![sub-form].[field-name]
Any assistance would be greatly appreciated.