Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2012

    Unanswered: Forms - fields with lookup list box change to plain text when inserted into form


    I have created a multi-paged form with 3 seperate tables. In two of the tables, however, there are 2 fields in each that should have a lookup list. The list does not show, and in the field properties (in form view) it shoes a "plain text" format and does not show any row source, and lookup tale information. How should I fix this issue?

    I have out up a picture in the attachments as well. The selected box should have a lookup list in it, but it does not. The other picture is an example of another field with lookup info that does show up.
    Attached Thumbnails Attached Thumbnails cts - form error.png   cts - form proper.png  
    Last edited by kumail123; 03-01-12 at 09:07. Reason: added examples/attachment

  2. #2
    Join Date
    Feb 2012

    And each table is assigned a respective page.

  3. #3
    Join Date
    Nov 2004
    Harrogate, N.Yorks, UK
    Right click on the field and change to either a combo box or in your case (as your second example shows) a list box if that is what is preferred. You will then get the option in the properties to set your row source. If this is set as a lookup list in the table before form creation then it would appear as a combo when you create the form.
    Last edited by jonesyfella; 03-01-12 at 18:52.

Posting Permissions

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