Displaying information in one form related to info in another form

[Mark909]

I have created a form based on "customer records".

I have another form outlining "property details". This form is created from
a Open Form macro on the customer records form.

I want the "property details" form to be linked to the "customer records"
form so when it opens up it displays data relating to the data already
displayed in the "customer records" form.

 

[Jeff Boyce]

Have you looked into using the standard "main form/subform" approach?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Jim Bunton]

Assuming that the Customer Records form includes a field (can be invisible)
containing the key to the customer table rows eg CustomerId
and
The Properties Form includes a field which also contains the same key (a
foreign key)

Then make the query which is the row source for the Properties Form have the
Where Clause
WHERE CustomerId = [Forms]![Customers]![CustomerId]

[If, on the Customers Form, you can requery it to frind another customer
then include a trigger (eg on change for a search for customer combo box)
which requeries the Properties Form if it is open]

There's anews group called access.forms which would be a better place to
post questions about forms.

Jim Bunton