Form and Subform

[Drunkenneo]

I have a Form and a subform:

Subform: its an direct display of table with the datasheet view

ID
Name
order_number
process_date
Status


And i have form linked on parent/Child on Order_number.

Problem is when i open form the subfor displays only single order_number record, eg 3 records for order_number xxxx. I want it to display whole when opened.

 

[bob fitz]

Problem is when i open form the subfor displays only single order_number record, eg 3 records for order_number xxxx. I want it to display whole when opened.

If you don't want the sub form to only show records related to the main form, remove "order_number" from the sub form's Master Link Fields and Child Link Fields properties.