Q: How to update form after Listbox is updated???

I have a populater listbox and I update the contents by running a
different SQL statement via
listbx.Rowsource =""

The contents of the listbox changes but the form doesn't.


What sytax or command should I use to update the form fields?

thanks,
c_kubie

Re: How to update form after Listbox is updated???

"C_Kubie" wrote

> I have a populater listbox and I update the contents
> by running a different SQL statement via
> listbx.Rowsource =""
>
> The contents of the listbox changes but the
> form doesn't.

That is exactly what I'd expect from the instruction you show. The
RowSource of a ListBox determines the contents of the ListBox and nothing
else.

What change, exactly, do you want in the contents of the Form? The
RecordSource of a Form determines the contents of the Form.

> What sytax or command should I use to update
> the form fields?

Without knowing what you have and what you expect, we couldn't be more
specific, nor tell you if your expectations are acheivable.

Larry Linson
Microsoft Access MVP

Re: Q: How to update form after Listbox is updated???

On Oct 26, 4:36 am, C_Kubie wrote:
> I have a populater listbox and I update the contents by running a
> different SQL statement via
> listbx.Rowsource =""
>
> The contents of the listbox changes but the form doesn't.
>
> What sytax or command should I use to update the form fields?
>
> thanks,
> c_kubie

try:

Me.Requery
Me.Refresh

HTH

Bubbles