Results 1 to 3 of 3
  1. #1
    Join Date
    May 2006

    Unanswered: Form does not record data in table but displays it.

    Hi there,

    I have created a form "A" for entering data in table "A" in my dbase. Somehow, when I use the form, the data of the field A1 is not recorded in the table but is displayed in the form. The value list for A1 comes from a field in table B.
    Does anybody know why it does this and how i can get the data to appear in the table datasheet and not just in form?

    Thanks very much


    ps: I use Windows XP (home ed.) and Access 2003

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    Hi Habs, and welcome to the forum
    Its difficult to know as there is insufficoent information
    I'm guessing that the control that is not updating is not "bound" (access speak for linked) to a column in your table

    open your form in design mode, select the column, look at the "Data" tab and see what is set for "Control Source". If its blank (and I'm expecting it to be) select the relvant column (field from the drop down list accessed by the down arrow to the right of the dialog)
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    May 2006
    Thanks Healdem,

    It was'nt exactly what was wrong but your message was very helpful. In fact the form was selecting the wrong column count. Anyway, thanks very much, everything is OK now.



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts