Subsubform doesn't update

[chopper57 via AccessMonster.com]

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_EmployeeHours.Form.Requery

Appreciate any help and will keep searching the forum.

 

[chopper57 via AccessMonster.com]

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_EmployeeHours.Form.NameLast.Requery

'

 

[tina]

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]

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.

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.

 

[tina]

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

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.

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.