textbox memo type

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

Guest

Hi:

I have a textbox on my Form bound to memo type field in a table.
Additionally, I have a cmdbutton that runs query based on the current form
contents that also checks null values of all textboxes in my Form. Now, I'm
adding records through the Form, the * appears on the left side. My problem
is, even I entered data in the "memo type textbox" and have lost the focus
on it. it does not save to my table (the * did not changed to >). It works
when I lost the navigation from the current record, (either by clicking to
the subforms or by adding new records). What seems to my problem. Thanks.
 
The data you see on the Form resides in the Form's buffer which has not been
updated into the Table. The data is updated into the Table only when you
move to another Record or move to another Data Object (e.g. Subform) or you
explicitly save the Record.

HTH
Van T. Dinh
MVP (Access)
 
Thanks for the prompt response.
I figured it out when I checked my codes. The reason was that my codes
point to table name field and not to the textbox name. I love this forum.
Thanks again.
 
Back
Top