Continuous Forms

[LRib]

I have a form with the default view property set
to "Continuous Forms". How can i programatically fill this
form with info from a table?

 

[Marshall Barton]

I have a form with the default view property set
to "Continuous Forms". How can i programatically fill this
form with info from a table?

Specify the table in the form's Record Source property.

 

[LRib]

The problem is that i just want the information that match
a certain criteria, and i want to modify that information.
That cannot be done with a Select query. How can this be
done?

 

[Marshall Barton]

Well, that's clear as mud. Are you saying you want to use
an unbound continuous form?? If so, forget it, you'll have
to use a bunch of text boxes arranged to look like rows.

What do you mean a Select query can't filter data?

I'm afraid I'm just not getting a picture of what you're
trying to do.

 

[LRib]

I'm not saying that a select query doesn't filter data,
i'm saying that with a select query you cannot alter the
data you have filtered. And this is what i'm trying to do.
Is fill a continuous form with data acording to a certain
filter criteria, but i need to be able to modify the data.

-----Original Message-----
Well, that's clear as mud. Are you saying you want to use
an unbound continuous form?? If so, forget it, you'll have
to use a bunch of text boxes arranged to look like rows.

What do you mean a Select query can't filter data?

I'm afraid I'm just not getting a picture of what you're
trying to do.
--
Marsh
MVP [MS Access]

The problem is that i just want the information that match
a certain criteria, and i want to modify that information.
That cannot be done with a Select query. How can this be
done?

.

 

[Marshall Barton]

I'm not saying that a select query doesn't filter data,
i'm saying that with a select query you cannot alter the
data you have filtered. And this is what i'm trying to do.
Is fill a continuous form with data acording to a certain
filter criteria, but i need to be able to modify the data.

I still don't follow what you're saying. As long as they're
updatable, select queries are standard fare as a form's
record source.

There are only a few reasons why you may not be able to edit
the data presented by a select query. Using a non-standard
db engine, using a non-standard data source (e.g. text
file), or a xomplex data source (e.g. Union).

What kind of query are you using?

 

[LRib]

I'm not using a query. I was trying to retrieve data
directly from the table.
I'm not seem to be able to put an update query as the
record source of the form.
And that's my main problem, because this is supposed to be
a form where users are allowed to insert, delete, update
table data.

 

[Marshall Barton]

There is a fundamental misunderstand going on here. What I
think you're describing is a standard everyday Bound form
using either a table or a select query in the form's
RecordSource property. In this situation, any controls that
are bound to a field in the record source table/query will
automatically be updated whenever a record is added, edited
or deleted. There is no need for you to do anything about
writing data back to the table.