Click on List box and move to that record in the form

  • Thread starter Thread starter Kelly
  • Start date Start date
K

Kelly

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,
 
Kelly said:
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.
Click to expand...

The following link is to a sample database that looks up a record from the
Northwind sample database:

http://accessmvp.com/Arvin/Combo.zip

This actually demonstrates a Drill Down technique, but you merely need to
use the second list box to accomplish what you which.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access
Co-author: "Access 2010 Solutions", published by Wiley
 
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,
 
Back
Top