If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
Click on List box and move to that record in the form
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, |
#2
|
|||
|
|||
Click on List box and move to that record in the form
"Kelly" wrote in message
news 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. 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 |
#3
|
|||
|
|||
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, |
Thread Tools | |
Display Modes | |
|
|