Updating subforms not working

main form has a dropdown combot box selecting query values which updates a
record on main form.
Subform being dispaly references this value to display records from a second
table.

But when I select a value the subform doesn't change.
but then I noticed that the sub form is one value behind, not always.
select employee but emolpyee detail records don't update.
select another employee and last employee records gets displayed.

private sub cbEmployee_Change()
docmd.Save
Me.EmployeeDetails.Requery
end sub

butthis doesn't seem to work.

Try replacing the Change event with the AfterUpdate event (Change fires with
each keystroke) and replace:

docmd.Save

Me.Dirty = False
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"Shawn" wrote in message
...
main form has a dropdown combot box selecting query values which updates a
record on main form.
Subform being dispaly references this value to display records from a
second
table.

But when I select a value the subform doesn't change.
but then I noticed that the sub form is one value behind, not always.
select employee but emolpyee detail records don't update.
select another employee and last employee records gets displayed.

private sub cbEmployee_Change()
docmd.Save
Me.EmployeeDetails.Requery
end sub

butthis doesn't seem to work.

ok that works.

Thanks.

"Arvin Meyer [MVP]" wrote:

Try replacing the Change event with the AfterUpdate event (Change fires with
each keystroke) and replace:

docmd.Save

Me.Dirty = False
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"Shawn" wrote in message
...
main form has a dropdown combot box selecting query values which updates a
record on main form.
Subform being dispaly references this value to display records from a
second
table.

But when I select a value the subform doesn't change.
but then I noticed that the sub form is one value behind, not always.
select employee but emolpyee detail records don't update.
select another employee and last employee records gets displayed.

private sub cbEmployee_Change()
docmd.Save
Me.EmployeeDetails.Requery
end sub

butthis doesn't seem to work.


.