By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,853 Members | 1,052 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,853 IT Pros & Developers. It's quick & easy.

trying to make a filtered list and then add new data

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.