+ Reply to Thread
Results 1 to 5 of 5

having different display controls (eg list, combo list, text) in the same table

  1. #1
    Registered User
    Join Date
    10-21-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    11

    having different display controls (eg list, combo list, text) in the same table

    I'd like to create a form with multiple columns and rows. Some of the options will allow the user to input text, other others will permit them to select from a list (one or more response options).

    I've provided a screenshot to help explain.

    I am relatively new to access and aware of a list or combobox (display control) and where i can place a value list in the row source type. However, I can only make single columns.

    Therefore, Id like to add a column that allows me to have text options, another column that shows a list, another column for a combo list, and one for a checkboxes.

    How can I create a column that allows for a checkbox, another column that is a drop down list, and a third that is a combo list in the same table?

    I've attached a screenshot to help explain the type of form I am hoping to create.

    Cross posted: http://www.accessforums.net/showthre...209#post390209
    Attached Images Attached Images
    Last edited by ftcnt; 03-08-2018 at 08:36 AM.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,860

    Re: having different display controls (eg list, combo list, text) in the same table

    Have you built your tables -- this is the starting point of building a RDBMS. Once this is in place then you can build your form based upon the fields in your table. While it may appear that you have columns in your form, each item is an individual control and must be inserted and formatted as such. In forms there is no formatting of columns or rows as they don't exist.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,860

    Re: having different display controls (eg list, combo list, text) in the same table

    crossposted: http://www.accessforums.net/showthread.php?t=70955

    Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

    Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

    Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

    Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

  4. #4
    Registered User
    Join Date
    10-21-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: having different display controls (eg list, combo list, text) in the same table

    Thanks for your suggestions.

    I have created my tables. So each column would be a separate variable and I would put them together in the same table in my form?

  5. #5
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,860

    Re: having different display controls (eg list, combo list, text) in the same table

    There are no columns in a form. Each item in your perceived columns should be a control bound to a specific field in your table. Each form is bound to only a single table. If you have multiple tables you will need to have sub forms that are bound to the tables and referenced/linked to the main form. It might be helpful to build your form using the form wizard and moving controls around in design view as you require.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Combo box list and text box form vba
    By wilsonwilson4 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 05-29-2017, 12:42 AM
  2. Combo Box from list and getting table to populate
    By jprobst in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-13-2015, 09:45 PM
  3. Searching in a list, display the result in combo box
    By khellen in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-24-2013, 07:38 AM
  4. How a combo box(form control) to display its list index value in Greek
    By Sotiris Kordas in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-22-2013, 05:37 AM
  5. Looking to code combo/drop down list user selection and display formula results
    By toddbailey in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-07-2012, 06:17 PM
  6. Combo Box wont Display list on initial launch
    By oliver_l in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-22-2010, 01:53 AM
  7. Combo Box - Display Unique Items in List
    By Gary S in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-20-2007, 11:15 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1