Re: Unbound form

I am working with a Access 97 Database. The only reason I am going to the
trouble of unbounding some of the forms in the database is because when the
backend of the database get over 40 kb the forms on the frontend work very
slow. Twice a day the Backend of the database has to be repaired and
compacted. Do you have another ideas on how I can improve the performance of
the database?

"Allen Browne" wrote:

This is a bug in Access. If a form has no records, and no new record can be
added, the Detail section goes blank, and controls that are still visible in
the Form Header or Form Footer misbehave. More info and example in:
http://allenbrowne.com/bug-06.html
More info on the conditions that trigger this:
http://allenbrowne.com/casu-20.html

Back to the original issue though. Saving the form without a RecordSource,
and then assigning one in Form_Load probably won't speed it up in most
cases. There may be something else going on here too.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Database Girl" <DatabaseGirl@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:3568BC6F-C0B5-4FAC-8BB4-FC45E9A761E0@xxxxxxxxxxxxxxxx
I am trying to speed up a form by making it unbound. On the Main Form, the
record source is set when the form is loaded and cleared when the form is
unloaded. I also have three tabs, one has a unbound subform, and the other
two have bound subforms.

On the form Header of the Main Form there are three cbo boxes that I use
to
filter the records by Manufacturer, Division, and Location. On one of the
tabs with a bound form, I have another cbo box with a list of Orders for
the
particular Manufacturer, Division, and Location selected in the header of
the
Main Form. Also on this tab there are fields that are associated with the
record source of the Main Form. Once I select the order from the drop
down
list I get the following error:
2427 - You entered an expression that has no value.

So in other words, it is not loading the fields from the record source on
the Main Form.

When the form was bound is worked fine.

Any idea why loading the record source OnLoad acts different then making
the
Main Form bound to a select statement?



----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?mid=3568bc6f-c0b5-4fac-8bb4-fc45e9a761e0&dg=microsoft.public.access.formscoding


.