Requery form

  • Thread starter Thread starter Chris
  • Start date Start date
C

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
 
Chris said:
Windows 95/98/2000
Access 2000

I have an unbound form based on a query.
Click to expand...

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.
Click to expand...

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.
Click to expand...

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.
 
Back
Top