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

[C_Kubie]

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

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

[Larry Linson]

"C_Kubie" <c_*****@yahoo.comwrote

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

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

[bubbles]

On Oct 26, 4:36 am, C_Kubie <[e-mail]:

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

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