Show Note on Continuous Form

  • Thread starter Thread starter Bonnie
  • Start date Start date
B

Bonnie

Hi there. Using A02 on XP. Have a form that shows all
deposit records for the contract number keyed into the SQL
parameter. Form is set to show continuous forms so I can
see most or all on one screen.

I have a separate table with special notes for some
contract numbers. Would like to show the note, if any, on
the form (on the header or footer seems logical).

The subform wizard says I cannot have a subform on a form
using continuous view. Can't seem to get around it.

I would really appreciate any help or advice on this.
Thanks in advance for your time!
 
Bonnie,

I am not clear of your meaning. Can there be more than one Special Note
for any given Contract Number? If so, then I think you will need a main
form, possibly unbound, or else based on your Contracts table (assuming
you have one), and then the existing Deposits form, and the SpecialNotes
form, will both be separately placed on this main form as subforms.
However, if only one Special Note for a Contract, you can base your
existing form on a query which includes both the Deposits and the Notes
tables, with a Left Join on the Contract Number field, and then include
the Special Note (if there is one) into the query, and then straight
onto the form, bound to a textbox in the Form Header or Form Footer.
Hope that makes sense.
 
Hi Steve! Yes, just one possible note per contract, sorry
I was vague. Glad you continued with the possible cure.
Sounds logical. I'll give it a try. Thanks bunches!!!
 
Back
Top