Requery form

[Chris]

Windows 95/98/2000
Access 2000

I have an unbound form based on a query. The query record
id criteria comes from a combo box on the form. Since it
is an unbound form I want to refresh the form when I change
the value in my combo box. The reason I set this up this
way is my tables are large and binding the form to the
table takes up too many resources and is slow.

Thanks

Chris

 

[Rick Brandt]

Windows 95/98/2000
Access 2000

I have an unbound form based on a query.

If it's based on a query it's not unbound. Do you mean that you are
populating an unbound form with the results of a query?

The query record
id criteria comes from a combo box on the form. Since it
is an unbound form I want to refresh the form when I change
the value in my combo box.

What code are you using to populate the form in the first place? You would
just repeat that process by calling it from the AfterUpdate event of the
ComboBox.

The reason I set this up this
way is my tables are large and binding the form to the
table takes up too many resources and is slow.

Nonsense. Using a RecordSource or filter that only returns one record at a
time would be just as fast as using an unbound form. There are some
legitimate reasons to use unbound forms, but performance is not one of
them.