Displaying data from 3 tables in unbound form

[Gary]

I need to display and be able to update data from 3
tables in an unbound form. I create a pop-up form to set
criteria for a parameter query and then use the query to
create a recordset that consists of data from the
customer and address tables. I display this data in
unbound text boxes on a form. I then need to display
categories of a customer on the same form, there can be
many categories for a given customer. I tried to display
this data in a subform (with my category table as the
source), but Access will not allow you to use
parent/child field ids for a subform within an unbound
form. How can I coordinate displaying the correct
categories for a customer using an unbound form? Is there
an example I can look at? Thanks.

 

[Marshall Barton]

I need to display and be able to update data from 3
tables in an unbound form. I create a pop-up form to set
criteria for a parameter query and then use the query to
create a recordset that consists of data from the
customer and address tables. I display this data in
unbound text boxes on a form. I then need to display
categories of a customer on the same form, there can be
many categories for a given customer. I tried to display
this data in a subform (with my category table as the
source), but Access will not allow you to use
parent/child field ids for a subform within an unbound
form. How can I coordinate displaying the correct
categories for a customer using an unbound form?

If the subform is bound, then you can use a main form
textbox for the Link Master property.