Re: Sub Form controls
First, advise you not use special characters such as #, $, / in names. Use Num or No for #, just drop the $, use _ instead of /.
If you want to enter data into record with those two comboboxes, they should be in the Detail section. Really shouldn't save Stock_Name or Symbol_Stock or Symbol_Stock_Y, just Investmentl_ID.
If those controls are for input of filter criteria then they should be UNBOUND.
And what do you mean by 'grouped'? Forms do not group records. You can sort and filter. Reports can group records.
To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression. Attachment Manager is below Advanced editor window, click Go Advanced below Quick Reply window.
Last edited by June7; 10-14-2018 at 12:39 AM.