report generated from different forms

  • Thread starter Thread starter Michael D. McGill
  • Start date Start date
M

Michael D. McGill

i have 2 forms one form that the user adds proposal information (form A).
the other is to review proposal information (form B). the user needs to
print a proposal from either one.

how do i set the query that the proposal is based on to say "if form A is
open then use the proposal id from that form, else if form B is open then
use the proposal id from that form."

hope this makes sense. up to this point i have been creating 2 queries and 2
reports that are identical except for being based on the form that is
currently open.

thanks,
mike
 
Back
Top