Results 1 to 3 of 3
  1. #1
    ashish_access is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2013
    Posts
    6

    Problem in displaying control from databse to form automatically


    I have created and saved a form in access automatically from database table.But when I change Display Control of a field from text box to combo box,it is not reflected in the form automatically after I refresh the form.
    Please suggest me some solution.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,952
    Changing the field in table to have a combobox will not reflect in control already created on form. You will have to convert the control to a combobox and manually edit properties or delete the textbox and drag the field from field list to form which will adopt the properties of field.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    A Lookup Field in a Table is considered to be a very bad idea by many experienced Access developers, especially when done by inexperienced developers! For the reasons why read the article "The Evils of Lookup Fields in Tables" here:

    http://mvps.org/access/lookupfields.htm

    Note that this refers to Lookup Fields/Comboboxes in Tables not to Comboboxes in Forms, being used to lookup Records. That is something else all together.

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 01-06-2013, 01:47 PM
  2. Replies: 2
    Last Post: 11-19-2012, 10:54 AM
  3. Replies: 2
    Last Post: 05-13-2011, 02:34 PM
  4. Replies: 3
    Last Post: 11-24-2010, 09:50 PM
  5. Weird Form Control Problem
    By MWB in forum Access
    Replies: 3
    Last Post: 11-17-2010, 05:42 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums