Is ther a way to enter a new record in a listbox rather than in a form tied to the listbox?

Posted on 2012-08-14
Last Modified: 2012-08-20
In other words, if I double-click on the blank area of a list box I want to be able to enter the data for the new record right in the listbox rather than have a form popup to enter the data into.


Question by:SteveL13
    LVL 61

    Accepted Solution

    You can't enter data directly into a listbox like that.

    The closest workaround I can think of would be to use a subform in continuous forms or datasheet view instead of a listbox.
    LVL 74

    Expert Comment

    by:Jeffrey Coachman
    <No Points wanted>

    With a "ComboBox" you kinda have a shot at this because of all the: "new data" and "edit List" properties.

    But ultimately I am with mbizup, ...use a form in place of the listbox (as a subform)



    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
    In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
    In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
    In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now