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
|
|||
|
|||
Subsubform doesn't update
I thought I had this wiped once but what happens is that it only updates the
first entry, after that I have to close the MainForm and reopen for the sfrm_EmployeeHours to update. I have a three level form, and a Popup for entering new employee names and data. frm_MainForm sfrm_DailyReport sfrm_EmplyoeeHours (datasheet and a Name field with a lookup/dropdown list) frm_MainForm contains sfrm_DailyReport sfrm_DailyReport contains sfrm_EmployeeHours sfrm_EmployeeHours is a datasheet form for selecting personnel names that worked. It’s record source is tbl_EmployeeTime with a lookup/dropdownlist for selecting Names from tbl_EmployeeData The Popup Form is for adding new personnel to tbl_EmployeeData The problem is when I need to add a new employee I open the popup, add the name, close the popup and the name will show in the lookup/dropdownlist in sfrm_EmployeeHours, but this only happens once, if I need to add another name I have to close and reopen the main form for it to show in the list. I had another Post called : Requery 2nd Subform The advice I received I thought fixed the problem but I didn’t try more then one entry at the time. We tried to requery the subform on the close event of the popup but it doesn’t fix the problem. Forms!frm_MainForm!sfrm_DailyReports.Form!sfrm_Emp loyeeHours.Form.Requery Appreciate any help and will keep searching the forum. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200612/1 |
#2
|
|||
|
|||
Subsubform doesn't update
Follow Up: I got it to work by requery the dropdown list in the datasheet
form called NameLast. This is what I used: Forms!frm_MainForm!sfrm_DailyReport!sfrm_EmployeeH ours.Form.NameLast.Requery ' chopper57 wrote: I thought I had this wiped once but what happens is that it only updates the first entry, after that I have to close the MainForm and reopen for the sfrm_EmployeeHours to update. I have a three level form, and a Popup for entering new employee names and data. frm_MainForm sfrm_DailyReport sfrm_EmplyoeeHours (datasheet and a Name field with a lookup/dropdown list) frm_MainForm contains sfrm_DailyReport sfrm_DailyReport contains sfrm_EmployeeHours sfrm_EmployeeHours is a datasheet form for selecting personnel names that worked. It’s record source is tbl_EmployeeTime with a lookup/dropdownlist for selecting Names from tbl_EmployeeData The Popup Form is for adding new personnel to tbl_EmployeeData The problem is when I need to add a new employee I open the popup, add the name, close the popup and the name will show in the lookup/dropdownlist in sfrm_EmployeeHours, but this only happens once, if I need to add another name I have to close and reopen the main form for it to show in the list. I had another Post called : Requery 2nd Subform The advice I received I thought fixed the problem but I didn’t try more then one entry at the time. We tried to requery the subform on the close event of the popup but it doesn’t fix the problem. Forms!frm_MainForm!sfrm_DailyReports.Form!sfrm_Em ployeeHours.Form.Requery Appreciate any help and will keep searching the forum. -- Jim Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200612/1 |
#3
|
|||
|
|||
Subsubform doesn't update
by "lookup/dropdownlist", i assume you mean a combo box control on your
form? and the problem is that when you add a new record to the table that is used as the RowSource of that combo box control, the new employee does not show in the control's "droplist"? if the preceding is correct, then suggest you requery the combo box control, rather than requerying the entire subform. hopefully tbl_EmployeeTime does NOT have a Lookup *field* in it. if so, suggest you get rid of it. you never need a "look-up" at the table level, since all data entry/review should be done in forms, and table Lookup fields cause numerous problems and headaches in queries, forms, etc. for more information, see http://home.att.net/~california.db/tips.html#aTip8. hth "chopper57 via AccessMonster.com" u17099@uwe wrote in message news:6aa1a59bb4258@uwe... I thought I had this wiped once but what happens is that it only updates the first entry, after that I have to close the MainForm and reopen for the sfrm_EmployeeHours to update. I have a three level form, and a Popup for entering new employee names and data. frm_MainForm sfrm_DailyReport sfrm_EmplyoeeHours (datasheet and a Name field with a lookup/dropdown list) frm_MainForm contains sfrm_DailyReport sfrm_DailyReport contains sfrm_EmployeeHours sfrm_EmployeeHours is a datasheet form for selecting personnel names that worked. It's record source is tbl_EmployeeTime with a lookup/dropdownlist for selecting Names from tbl_EmployeeData The Popup Form is for adding new personnel to tbl_EmployeeData The problem is when I need to add a new employee I open the popup, add the name, close the popup and the name will show in the lookup/dropdownlist in sfrm_EmployeeHours, but this only happens once, if I need to add another name I have to close and reopen the main form for it to show in the list. I had another Post called : Requery 2nd Subform The advice I received I thought fixed the problem but I didn't try more then one entry at the time. We tried to requery the subform on the close event of the popup but it doesn't fix the problem. Forms!frm_MainForm!sfrm_DailyReports.Form!sfrm_Emp loyeeHours.Form.Requery Appreciate any help and will keep searching the forum. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200612/1 |
#4
|
|||
|
|||
Subsubform doesn't update
Thanks for your help Tina, it's a combo, I wasn't sure it you still call it a
combo or lookup when it's in a datasheet Form. And I did requery the combo control and it's working good now. Thanks for the link also, that's full of good information. tina wrote: by "lookup/dropdownlist", i assume you mean a combo box control on your form? and the problem is that when you add a new record to the table that is used as the RowSource of that combo box control, the new employee does not show in the control's "droplist"? if the preceding is correct, then suggest you requery the combo box control, rather than requerying the entire subform. hopefully tbl_EmployeeTime does NOT have a Lookup *field* in it. if so, suggest you get rid of it. you never need a "look-up" at the table level, since all data entry/review should be done in forms, and table Lookup fields cause numerous problems and headaches in queries, forms, etc. for more information, see http://home.att.net/~california.db/tips.html#aTip8. hth I thought I had this wiped once but what happens is that it only updates the first entry, after that I have to close the MainForm and reopen for the [quoted text clipped - 12 lines] sfrm_EmployeeHours is a datasheet form for selecting personnel names that worked. It's record source is tbl_EmployeeTime with a lookup/dropdownlist for selecting Names from tbl_EmployeeData [quoted text clipped - 7 lines] I had another Post called : Requery 2nd Subform The advice I received I thought fixed the problem but I didn't try more then one entry at the time. [quoted text clipped - 3 lines] Appreciate any help and will keep searching the forum. -- Jim Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200612/1 |
#5
|
|||
|
|||
Subsubform doesn't update
you're welcome.
I wasn't sure it you still call it a combo or lookup when it's in a datasheet Form regardless of what View a form is in when used, the objects on the form are called by the same names - a textbox control is a textbox control, a combo box control is a combo box control, a command button is a command button, etc, etc. hth "chopper57 via AccessMonster.com" u17099@uwe wrote in message news:6aa37c3dddca7@uwe... Thanks for your help Tina, it's a combo, I wasn't sure it you still call it a combo or lookup when it's in a datasheet Form. And I did requery the combo control and it's working good now. Thanks for the link also, that's full of good information. tina wrote: by "lookup/dropdownlist", i assume you mean a combo box control on your form? and the problem is that when you add a new record to the table that is used as the RowSource of that combo box control, the new employee does not show in the control's "droplist"? if the preceding is correct, then suggest you requery the combo box control, rather than requerying the entire subform. hopefully tbl_EmployeeTime does NOT have a Lookup *field* in it. if so, suggest you get rid of it. you never need a "look-up" at the table level, since all data entry/review should be done in forms, and table Lookup fields cause numerous problems and headaches in queries, forms, etc. for more information, see http://home.att.net/~california.db/tips.html#aTip8. hth I thought I had this wiped once but what happens is that it only updates the first entry, after that I have to close the MainForm and reopen for the [quoted text clipped - 12 lines] sfrm_EmployeeHours is a datasheet form for selecting personnel names that worked. It's record source is tbl_EmployeeTime with a lookup/dropdownlist for selecting Names from tbl_EmployeeData [quoted text clipped - 7 lines] I had another Post called : Requery 2nd Subform The advice I received I thought fixed the problem but I didn't try more then one entry at the time. [quoted text clipped - 3 lines] Appreciate any help and will keep searching the forum. -- Jim Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200612/1 |
Thread Tools | |
Display Modes | |
|
|