View Single Post
  #3  
Old June 1st, 2010, 11:29 PM posted to microsoft.public.access
Kelly
external usenet poster
 
Posts: 469
Default Click on List box and move to that record in the form

HI, Thank you that worked and put the record information from the list box
into the form field.
I now have another problem with the form and the list boxes. Lets say I have
2 or more records in the list box. After clicking the first user information
from the list box and it places it in the form fields and I then click
clock-out, it places the username into the completed list box. It also clears
the form feilds lik it should.

If I pick on a second entry or a third, the first entry stays in the form
fields and doesn't clear the initial entry info. that was first clicked.
Also, when I click the first entry to "clock-out" it will place it in the
completed list box "OK", but when I click the second entry or click the
clock-out button, it doesn;t add a new record to the 2nd list box, it just
addes more time to the current record. I need it to add unique records
everytime I click the clock-out button. I also need to be able to click from
the first list box (Clocked in user).
To summarize; If I have (1) record only, it works fine. If I have another
record of the same name or different name. It only uses the first record
entry, although the time does modify.

Thank you,

"Kelly" wrote:

I have a single form which will be used for users to clock in and out. On the
form I have a list box showing the completed clock-in's and another list box
with incomplete clock-in's. I would like to have the user be able to select
their name from the incomplete clock-in and have their record load so they
can clock out. I've tried to find the solution, but can't quite find it.

Thank you,