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" <Shawn@discussions.microsoft.com> wrote in message 
news:57D433B2-DC20-4D5C-9085-91EC138B8F88@microsoft.com...
> 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" <Shawn@discussions.microsoft.com> wrote in message 
> news:57D433B2-DC20-4D5C-9085-91EC138B8F88@microsoft.com...
> > 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. 
> 
> 
> .
>