Form to Report

  • Thread starter Thread starter Mr-Re Man
  • Start date Start date
M

Mr-Re Man

I have a form that includes a continuous subform. Within that subform is a
field called (contractno_txt). At the end of that row, I have included a
button that links to a report.

The report includes the field (contractno_txt), I am trying to link the two
together so that only the matching staff assigned to that contract appear in
the report.

I have searched for various threadds within the discussions, but nothing
matches what I need. Should I be looking at it another way perhaps or I am
missing out something simple?

regards
 
This is my code: contractno_txt =
forms!frm_schools.subfrm_schools_contracts!form.contractno_txt but i get an
error once I press the button the subform which indicates:
ENTER PARAMETER VALUE, then it displays the code abvoe and a blank line to
enter a value.

Any ideas?

Thanks so far though
 
I did it, after playing around with the previous code I managed to get it
working, the code I used was:

contractno_txt =
[forms]![frm_schools].[subfrm_schools_contracts]![contractno_txt]

instead of

contractno_txt =
forms!frm_schools.subfrm_schools_contracts!form.contractno_txt
 
I have a form that includes a continuous subform. Within that subform is a
field called (contractno_txt). At the end of that row, I have included a
button that links to a report.

The report includes the field (contractno_txt), I am trying to link the two
together so that only the matching staff assigned to that contract appear in
the report.

I have searched for various threadds within the discussions, but nothing
matches what I need. Should I be looking at it another way perhaps or I am
missing out something simple?

regards
Click to expand...

The syntax for referencing a control on a subform is a bit convoluted: you
need to reference the main form and the name of the Subform Control (which
might or might not be the same as the name of the form within that control):

Forms!mainformname!subformcontrol.Form!contractno_txt
 
Back
Top