Splitform will not filter on listbox

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Dawg62
    New Member
    • Feb 2010
    • 1

    Splitform will not filter on listbox

    DB is attached.

    On the listboxt updates 8 fields. The other fields I fill in myself. Ideally I would like to have an enter button to insert the updated data from the form to the table below that can not be updated unless I do some changes on the form. The listbox is information that does not change. I add the dropdown info on another form as new studies are started. I'm trying to show history for each study. The information should filter by the dropdown in the split form table. I hope that clarifies what I'm trying to do.

    I don't know if I have to do this in a tab format but I like this way better as it is easier to see all the information at once.
    Attached Files
  • mshmyob
    Recognized Expert Contributor
    • Jan 2008
    • 903

    #2
    I have read this many times and still have no idea what you are asking.


    information should filter by the dropdown in the split form table
    What combobox (I assume dropdown) are you talking about (you have a few).

    On the listboxt updates 8 fields
    I have looked at your database and don't see any list boxes on your form.
    What do you mean a listbox updates 8 fields?

    Ideally I would like to have an enter button to insert the updated data from the form to the table below that can not be updated unless I do some changes on the form.
    What table below??? If your form is bound to a table then it gets updated when you update the bound controls on the form.
    Obviously if you do not update anything on the form nothing will be updated.

    I hope you start to see why this is such a confusing question.

    Please rephrase your question so that it can be understood easily.

    cheers,

    PS: You also have a database that is not normalized that consists of two tables that are not even related to each other in any way. Most of your data is redundant. You should read up here on normalization

    Comment

    Working...