error after adding report field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hello- (using access 2000)
After creating a mdb for managing patient information, I
decided to add a field "waist_circ" to a
table "clinic_visit" as a number. I succesfully added it
to the form for data entry, and added it to the report.
everything seems to go well until previewing the report
where instead of taking the data entered for the new
field, it pops a dialog box up and asks for
the "waist_circ" value.

interestingly, when i try to confirm the correct control
source on the report, the field list that usually has all
the table fields doesn't contain waist_circ . so i
manually add =[waist_circ] but still get the error. So how
can I add a field to my entire db and get it to link
correctly? there are no queries (yet) in my db, and my
report is limited to the current record being
edited/added. any thoughts?
 
hello- (using access 2000)
After creating a mdb for managing patient information, I
decided to add a field "waist_circ" to a
table "clinic_visit" as a number. I succesfully added it
to the form for data entry, and added it to the report.
everything seems to go well until previewing the report
where instead of taking the data entered for the new
field, it pops a dialog box up and asks for
the "waist_circ" value.

interestingly, when i try to confirm the correct control
source on the report, the field list that usually has all
the table fields doesn't contain waist_circ . so i
manually add =[waist_circ] but still get the error. So how
can I add a field to my entire db and get it to link
correctly? there are no queries (yet) in my db, and my
report is limited to the current record being
edited/added.
Click to expand...


It sure sounds like the report is base on a query (or an SQL
statement) that doesn't include the waist_circ field.

Either that, or you spelled it differently in the table.
 
I have no query, but this is the code i use to open the
report with the current record (from a subform)

rivate Sub Clinic_visit_report_preview_Click()
On Error GoTo Err_Clinic_visit_report_preview_Click

Dim stDocName As String

stDocName = "Clinic_visit"
DoCmd.OpenReport stDocName,
acViewPreview, , "visit_ID = Forms!Demographics!
Clinic_visit2!

this seemed like it should not cause a problem.... what
gives? TIA
-----Original Message-----
hello- (using access 2000)
After creating a mdb for managing patient information, I
decided to add a field "waist_circ" to a
table "clinic_visit" as a number. I succesfully added it
to the form for data entry, and added it to the report.
everything seems to go well until previewing the report
where instead of taking the data entered for the new
field, it pops a dialog box up and asks for
the "waist_circ" value.

interestingly, when i try to confirm the correct control
source on the report, the field list that usually has all
the table fields doesn't contain waist_circ . so i
manually add =[waist_circ] but still get the error. So how
can I add a field to my entire db and get it to link
correctly? there are no queries (yet) in my db, and my
report is limited to the current record being
edited/added.
Click to expand...


It sure sounds like the report is base on a query (or an SQL
statement) that doesn't include the waist_circ field.

Either that, or you spelled it differently in the table.
Click to expand...
 
I have no query, but this is the code i use to open the
report with the current record (from a subform)

rivate Sub Clinic_visit_report_preview_Click()
On Error GoTo Err_Clinic_visit_report_preview_Click

Dim stDocName As String

stDocName = "Clinic_visit"
DoCmd.OpenReport stDocName,
acViewPreview, , "visit_ID = Forms!Demographics!
Clinic_visit2!

this seemed like it should not cause a problem.... what
gives?
Click to expand...


I don't see how the errors in that could cause the
parameterprompt. Try fixing the above and then see what
happens. Assuming the above is a complete statement and
that visit_ID is a numeric type field:

DoCmd.OpenReport stDocName, acViewPreview, , _
"visit_ID = " & Forms!Demographics!Clinic_visit2
 
Back
Top