Displaying Data

[carol.taylor]

Hi All,

I need some urgent help with a database that i'm creating and i'm a
bit stuck.

I have 2 lists of data they are both linked. I need to create a query
where by if a certain criteria matches on the other sheet then all
record for that are displaying. For example tasks if 1 assignment has
10 tasks, i need to be able to run a query whereby all tasks are
displayed. I'm not sure that makes sense.

It does in my head. I've managed it so that it works within my form
view. But i need to set up access so that when a person clicks a
command button it then open up another form and displays the tasks in
detail.

Any help someone may give me would be much appreciated.

Thanks
Carol

 

[banem2]

Hi All,

I need some urgent help with a database that i'm creating and i'm a
bit stuck.

I have 2 lists of data they are both linked. I need to create a query
where by if a certain criteria matches on the other sheet then all
record for that are displaying. For example tasks if 1 assignment has
10 tasks, i need to be able to run a query whereby all tasks are
displayed. I'm not sure that makes sense.

It does in my head. I've managed it so that it works within my form
view. But i need to set up access so that when a person clicks a
command button it then open up another form and displays the tasks in
detail.

Any help someone may give me would be much appreciated.

Thanks
Carol

Hi Carol,

I am not sure I understood this, but I will give a try.

Second form which opens by clicking command button should have Record
Source set on query which is filtered by Assignment number set in
first form, first list. The same way as your second list is filtered.

This looks fairly simple, so I doubt I have understood. Let us know do
you have 2 tables with data or there is only one table? Where are
stored assignments and tasks? Is it necessary to open second form (can
you use same form)?

Regards,
Branislav Mihaljev