unbound Field

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

Guest

I have a form that I want to display values from tables or queries that are
not part of the form or subform. If I make a relationship with the table or
query that has the information I want displayed, it makes the record set
non-updatable. As a result, I am thinking that an unbound field is the way to
display the data.

The way the database is structured, there two seperate forms one is
appointments including subforms of related data (this is where I want to
display the Chronic Care Status) and the other form is diagnoses with its
subforms and related data. Diagnoses is where the Chronic Care is available
and displayed. However as stated when joining the two Appointments and
Diagnoses, the records are not updatable.

My question is how can I display the Chronic Care status in the Diagnoses
table on my Appointment Subform.
 
You can try and bound the Status field to a dlookup
=dlookup("Status","QueryName","Crit = " & [FieldToCrit])

Or
try again and link the two the table and the query and in that recordsource
change the UniqueRecords property of the query to true. I think that will
allow you to update the records.
 
Back
Top