469,330 Members | 1,331 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,330 developers. It's quick & easy.

trying to make a filtered list and then add new data

I have a main table with teacher names and students
I can put this in a subform and filter by teacher name so I have
a list of her students in a sub form.
the problem I have is this is created in tblmain

but now I need to have them enter data each day for each student
so I have a new table tbldata that has TimeStart, TimeEnd

how can I make a list of students in a subform like I have now
created from tblmain, and filtered(so far so good) then have them
enter a start and end time for this list and store this in another
table.
You can't tie 2 tables to one form so I can create the list but can't
figure out a way to do both.
anyone ?

man my head hurts LOL
thanks for any help

Jerry

Oct 5 '06 #1
1 1414
Anyone have any ideas on how you can create a list with a query and
then add records to a table ???

it would be something like this

teacher date child name start end
the teacher and child name are in tblmain

the date start and end files have to be in tbldata1

so the beginning they want to choose a teacher and a date
so I shifted and put the teacher in a combo box and tied it to nothing
but the subform
so combo box teacher and field date
links to subform are teacher;date
but they want a filtered list on teacher so the form would have to be

teacher date child name start end
Ms. Eve 01/01/06 mary lamb
Ms. Eve 01/01/06 billy bull
Ms. Eve 01/01/06 bob jones
then they could put in start and end for each child

I don't see how I can get the child names filtered thru a query (this
I can do) BUT then to be able to edit the fields and put this data
into a new table.

IS there a way to do this?



On Thu, 05 Oct 2006 15:24:10 GMT, sparks <js******@swbell.netwrote:
>I have a main table with teacher names and students
I can put this in a subform and filter by teacher name so I have
a list of her students in a sub form.
the problem I have is this is created in tblmain

but now I need to have them enter data each day for each student
so I have a new table tbldata that has TimeStart, TimeEnd

how can I make a list of students in a subform like I have now
created from tblmain, and filtered(so far so good) then have them
enter a start and end time for this list and store this in another
table.
You can't tie 2 tables to one form so I can create the list but can't
figure out a way to do both.
anyone ?

man my head hurts LOL
thanks for any help

Jerry
Oct 9 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by it hates me | last post: by
7 posts views Thread by Ken | last post: by
1 post views Thread by abTech | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by haryvincent176 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.