John is out of town so I would only follow my advice ;-) Ken is also good
but he handed this off to me.

What are the table and field names of your students table and your lunch
attendance table?

All you should have to do is create a continuous form based on your table
tblStudentsLunchAttend. You should have a combo box based on your students
table to allow the scanning of the student ID to capture a value to store in
tblStudentsLunchAttend. You can include other controls on the form depending
on what you want to see on the form when you scan.

The form should be set up as "Data Entry: Yes". This will hide all the old
records when it opens.

--
Duane Hookom
MS Access MVP
--

wrote in message
...
Do you know of a sample of this anywhere that I could look at? It
seems like I am changing everything that was done originally with John
Vinson. Should I follow all the directions in this thread both yours
and Ken Snells advice or just yours?

I have been working on this for over a week and seem to be going in
circles at this point.

I now have built another table. What can I post to show you what I
have so far.

On Fri, 11 Feb 2005 18:44:28 GMT, wrote:

On Fri, 11 Feb 2005 18:04:22 GMT, wrote:

So the first thing I have to do is add another textbox to the original
form
with the date and that will be bound to the new table
tblStudentsLunchAttend.LunchDate field correct?


On Fri, 11 Feb 2005 11:53:35 -0600, "Duane Hookom"
wrote:

Go back to my reply that begins "As Ken mentioned..." You will find your
solution there. Make sure you have a table as Ken suggested and then
build
the form etc as I suggested. Any other attempt to use a form bound to
your
student table will just result in failure and cause me to get upset and
possibly not respond.

--
Duane Hookom
MS Access MVP