I've run into a problem with memo fields locking out the record and preventing saves, so I've decided to just place all memo fields from each table into their own tables. For example, all the memo fields for tbl_Effects are now in tbl_Effects_Memo.
My question is, if I were to make the recordsource of frm_Effect a query that joins tbl_Effects to tbl_Effects_Memo, will editing the memo field place a lock on both sides of the join, or will it just place a lock on the tbl_Effects_Memo side? I'm hoping to do it this way instead of creating individual child subforms for each memo field on frm_Effect.
My question is, if I were to make the recordsource of frm_Effect a query that joins tbl_Effects to tbl_Effects_Memo, will editing the memo field place a lock on both sides of the join, or will it just place a lock on the tbl_Effects_Memo side? I'm hoping to do it this way instead of creating individual child subforms for each memo field on frm_Effect.