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
|
|||
|
|||
Unbound controls
I've created an Attendance Tracking database. There are 3 tables tbl_Associates Clock Number Last Name First Name tblAttendance Attendance Code Hours Used Date of Infraction The form for entering the information uses a query: Clock Number (Associate Table) Combo Box for Last Name ***code below*** Combo Box for First Name ***code below*** Attendance Code (Attendance Table) Hours (Attendance Table) Date (Attendance Table) ***Code for combo box*** Private Sub Clock___AfterUpdate() Me.LastName = Me.Clock__.Column(1) Me.FirstName = Me.Clock__.Column(2) End Sub The form I've designed is in a continuous form format to allow the clerk to enter all data for the previous day. The clock # uses a lookup for the associate clock number, then fills in the last name and first name. Everything works fine until I go to the next record to enter a different associate. Although I change the clock number, the last name and first name changes to the new name on all records. What simple, stupid thing am I doing wrong this time? THanks, Linda Was this post helpful to you? Reply | Print post TopTop luan 5/27/2008 8:04 PM PST On May 28, 12:23 am, Boz wrote: I've created an Attendance Tracking database. There are 3 tables tbl_Associates Clock Number Last Name First Name tblAttendance Attendance Code Hours Used Date of Infraction The form for entering the information uses a query: Clock Number (Associate Table) Combo Box for Last Name ***code below*** Combo Box for First Name ***code below*** Attendance Code (Attendance Table) Hours (Attendance Table) Date (Attendance Table) ***Code for combo box*** Private Sub Clock___AfterUpdate() Me.LastName = Me.Clock__.Column(1) Me.FirstName = Me.Clock__.Column(2) End Sub The form I've designed is in a continuous form format to allow the clerk to enter all data for the previous day. The clock # uses a lookup for the associate clock number, then fills in the last name and first name. Everything works fine until I go to the next record to enter a different associate. Although I change the clock number, the last name and first name changes to the new name on all records. What simple, stupid thing am I doing wrong this time? THanks, Linda Hi, Linda ! I guess LastName and FirstName control in your form are unbound control, Right ? If so, this is the trouble come from. HTH Thanks for the reply, but I really need to know what to do to fix it. |
#2
|
|||
|
|||
Unbound controls
Boz,
The problem is that on a continuous Form, there is really only *one* combo box - displayed many times. If you change its properties (its RowSource in this case), all rows reflect that change. One work around is to put a Textbox onto the form, carefully superimposed over the text area of the combo box (don't cover the dropdown tool though). Set its Control Source to either a DLookUp expression looking up the current record's value from the lookup table, or (if practical) base the Form on a query joined to the lookup table and simply make it a bound textbox. Set the textbox's Enabled = No, Locked = Yes, Tab Stop = No so the user can't do anything with it; it's for display only. You may need to move it in front of the combo box (with Move To Front on the Format menu). When the user selects the dropdown, the combo box data will come in front and allow (filtered) selection; when it's not selected, the user will see the textbox. Jeanette Cunningham -- Melbourne Victoria Australia "Boz" wrote in message ... I've created an Attendance Tracking database. There are 3 tables tbl_Associates Clock Number Last Name First Name tblAttendance Attendance Code Hours Used Date of Infraction The form for entering the information uses a query: Clock Number (Associate Table) Combo Box for Last Name ***code below*** Combo Box for First Name ***code below*** Attendance Code (Attendance Table) Hours (Attendance Table) Date (Attendance Table) ***Code for combo box*** Private Sub Clock___AfterUpdate() Me.LastName = Me.Clock__.Column(1) Me.FirstName = Me.Clock__.Column(2) End Sub The form I've designed is in a continuous form format to allow the clerk to enter all data for the previous day. The clock # uses a lookup for the associate clock number, then fills in the last name and first name. Everything works fine until I go to the next record to enter a different associate. Although I change the clock number, the last name and first name changes to the new name on all records. What simple, stupid thing am I doing wrong this time? THanks, Linda Was this post helpful to you? Reply | Print post TopTop luan 5/27/2008 8:04 PM PST On May 28, 12:23 am, Boz wrote: I've created an Attendance Tracking database. There are 3 tables tbl_Associates Clock Number Last Name First Name tblAttendance Attendance Code Hours Used Date of Infraction The form for entering the information uses a query: Clock Number (Associate Table) Combo Box for Last Name ***code below*** Combo Box for First Name ***code below*** Attendance Code (Attendance Table) Hours (Attendance Table) Date (Attendance Table) ***Code for combo box*** Private Sub Clock___AfterUpdate() Me.LastName = Me.Clock__.Column(1) Me.FirstName = Me.Clock__.Column(2) End Sub The form I've designed is in a continuous form format to allow the clerk to enter all data for the previous day. The clock # uses a lookup for the associate clock number, then fills in the last name and first name. Everything works fine until I go to the next record to enter a different associate. Although I change the clock number, the last name and first name changes to the new name on all records. What simple, stupid thing am I doing wrong this time? THanks, Linda Hi, Linda ! I guess LastName and FirstName control in your form are unbound control, Right ? If so, this is the trouble come from. HTH Thanks for the reply, but I really need to know what to do to fix it. |
Thread Tools | |
Display Modes | |
|
|