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]

Cross posting. http://www.access-programmers.co.uk/...d.php?t=257012
Please read: http://www.excelguru.ca/content.php?...-cross-posters

[naeemahmad]

I personally dont like to use the parent/child properties because sometime they are not flexible enough to perform the task you would like to see happen.
I use VBA most of the time when I can , even if there is a Macro that can accomplish a similar task.

How about using vba to have the forms FILTER event triggered to provide the necessary results.

I have use the code below in the past reliably, bypassing the 'parent/child' aggravation..

'--------------------------------------------
Forms![frmTCDILOG]![UPDATE UNIQUE DEVICE].Form.Filter = "[User_Comment]=" & Me.[User_Comment]
Forms![frmTCDILOG]![UPDATE UNIQUE DEVICE].Form.FilterOn = True
'--------------------------------------------

Of course there are many ways to achieve the desired results.. good luck!

Naeem~