How to have SubForm filterd via user entry request ?

[azzi2000]

This is what I am trying to accomplish. It is to have a subform list all orders for a specific employeeid and specific date via tabs.
I do not know how to filter a subform based on a parent entry form ???

Table used:
Table1: orderno (primarykey), employee, entrydate....,notes
Table2: orderno, hours, wage, description....
table1.orderno --> table2.orderno

1 Form using 2 tabs:
Tab1: orderno, employeeid, entrydate
subform1 with table2 detailed (linked via orderno)

Tab2: subform2 (identical to subform1) but need to be filtered (ie: show all entry for employeeid = tab1.employeerid AND = tab1.entrydate)
Please advice,
thank you.
dré

 

[dhookom]

You mention employeerid and employeeid yet this field is not contained in either table. What's up with that?

Is all of your data in subforms or is the main form bound to a table/query?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[azzi2000]

Sorry:
Only employeeid is in table1
Table1 is in the main form
Table2 in in the subform
and both form and subform are bound. Subform is created via the wizard.
Please advice,
Thank you.
Dré

 

[dhookom]

To filter records in a subform based on values in the main form, set the Link Master/Link Child to the appropriate field names.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[PHV]

And if the RelationShips are properly set the wizard does that automagically...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244