Good morning.
I have a little issue about a system I am developing.
It’s a system for calculating values with USG exams and there are many patients data recorded in it.
I have a form where are insert data and where I have commands to print different reports coming from the same query and table. It works fine from this form. I have to capture the code value on the form to print specifically data from this code that is unique for each patient, using the criteria:
WHERE (((tbl_OB_1_ObstetriciaGeral_Precoce.Codigo)=[Formulários]![frm_Obstetricia_2].[Codigo]));
The issue is, this form is actually a subform, and when it is a subform this doesn’t work. When I click the command to preview the form or to directly print, it asks me (insert dialog box) to insert the value [Formulários]![frm_Obstetricia_2].[Codigo]).
Anyone could help me on this?
Thank you.
Ivan Sinigaglia (Brasil)
================================================== =========
SQL query
SELECT tbl_OB_1_ObstetriciaGeral_Precoce.Codigo, tbl_OB_1_ObstetriciaGeral_Precoce.Nome,
//.......//
tbl_OB_1_ObstetriciaGeral_Precoce.imd3d_11
FROM tbl_OB_1_ObstetriciaGeral_Precoce
WHERE (((tbl_OB_1_ObstetriciaGeral_Precoce.Codigo)=[Formulários]![frm_Obstetricia_2].[Codigo]));
================================================== ===========
ONLY AS A FORM
=============
AS A SUBFORM
======================
Query