Continues form

P

Peter Morris

I'm new to Access programming. I've used other versions
of Visual Basic before, but I'm finding a lot of differences
between my prior experience and access.

In another thread someone suggested that I use a continues form.
Can someone please give me a 101 on these. I'm not familiar
with them. I understand that it creates a repeating group of
controls in tabular format. Is that right?

How do I run a SQL query and put the result in the grid?
 
W

Wayne Morgan

A continuous form is just a "display method". The information is just the
same as it is on a single display form, you just see multiple rows of data
at once. You don't "run" SQL to do this. You set a Record Source for a
continuous form just as you would for a single view form. If there is more
than one record returned, you'll get more than one row showing. The problem
is with unbound controls. Since there is really only one control repeated
several times, unbound controls will show the same thing in each row. If the
unbound control is based on a value in the current record, as you move the
focus through the records, each copy of the unbound control will change as
you move through the records.
 
Top