Re: Populating unbound forms
- From: "Larry Linson" <bouncer@xxxxxxxxxxxxx>
- Date: Fri, 20 Apr 2007 22:14:57 -0500
"Dean" <Dean@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:CDC596D4-894C-47F4-8DCE-8D6557626366@xxxxxxxxxxxxxxxx
Hi how do i populate a unbound form. What is the best way to get the data
from the tables to the fields. I can not find much documentation on this
so
if anyone could point me in the right direction that would be great
It is worth the minimal time and effort to learn how Access works with bound
forms for forms with data. Really. It is.
If not, you are duplicating the time and effort that was expended to build
form population and updating into the product, and you are subjecting
yourself to possible errors for which you have to test anew on each unique
form.
That said, if you feel _compelled_ to use unbound forms for data, and the
data is not to be updated, you can populate the Controls, as was suggested,
with domain aggregate functions, e.g. DLookup, Dsum, DMax, Davg. If the data
is to be updated, you'll have to write VBA code to get the data, display it,
determine if it has been changed, and then write the data back to the tables
in your database.
I often use unbound forms as "switchboards" for navigation, or to allow a
user to enter criteria for choosing a report, or choosing what data to
display on a bound form. But they complicate matters if you decide to use
them for data entry or data update.
Larry Linson
Microsoft Access MVP
.
- Prev by Date: Which Function...
- Next by Date: Re: complete all the fields before exit
- Previous by thread: Which Function...
- Next by thread: Re: Populating unbound forms
- Index(es):
Relevant Pages
|
