forms and unbound controls

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form that is bound to a table.There are several unbound cbo Boxes
and I am inserting the value in the the table on the afterUpdate event
me!Field Name = me!cboName

The cbo boxes are Yes/No and 1/0 are stored in the table.

The problem I am having is that after I close the form and reopen the form
the data (from the cbo Boxes)does not appear in the form.

Thanks in advance for your help!
meb
 
Mary,

Any reason for doing it this way? On the face of it, using bound
controls on the form would be lot simpler.
 
It is my understanding that this is a more efficient way of doing it. The
database will not be as slow
 
Mary,

This is incorrect. I am not familiar with this idea, or where it came
from, so can't comment further. Certainly if you have a very large
amount of data, you need to design your forms for efficiency... but then
that would equally apply to loading data into unbound controls, in fact
probably more so. If you have a concern about slowness of your
database, perhaps you could describe the problem you are experiencing.
But again, in terms of what you have told us so far, bound controls on a
bound form is absolutely the way to go here. Access's abilities in this
regard are one of the things that make it such a great tool.
 
.... in fact, Mary, now that I look again at what you are doing, with
me!Field Name = me!cboName
you must be using a bound form, and writing the value from unbound
controls to the fields in the bound form's record source table/query.
So, I would be interested to know where you got that idea from, but no,
this is absolutely a much less efficient approach.
 
Back
Top