473,394 Members | 2,071 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,394 software developers and data experts.

Splitform will not filter on listbox

1
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
File Type: zip Database2.zip (102.6 KB, 85 views)
Feb 10 '10 #1
1 1506
mshmyob
904 Expert 512MB
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
Feb 13 '10 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: RRT | last post by:
I have an existing table which describes Streets and sections of streets between intersections: Table 1: Streets by Intersections Street Area Ann St. Main to Jackson...
5
by: Rated R1 | last post by:
I wrote this before in the NGs, so I am going to paste the responses that I got and see if someone can please help me. Email me and we can set something up as Id even be willing to pay for your...
0
by: marcelo | last post by:
Could you help me out here. I need to accomplish this: I need to filter listbox items from by entering some characters to the textbox. But the problem is that items (files that are read from...
2
by: bobdydd | last post by:
Hi All Access 2007 I have a form with a ListBox called "ListContactTasks" DoubleClicking the ListBox opens another form called "frmContact" at a particular record corresponding to the one in...
1
by: daniani | last post by:
Hello, Can you help me, to show a splitform view in subform? Cuz, when I open a form, a subform which contains a splitform view being single form view. I need it to enhance my application...
1
by: Joelle | last post by:
Hi everyone, i am really stack!i need help I have this report:"RequirementObjects_Report",i have also a multiselect listbox whicg contains a list of products.what i want to do is to filter the...
0
by: Kassimu | last post by:
Hi guys out there, There is this database Iam creating, I have a table with 40 fields among which there are Date/time, Text, Number, Memo and Yes/No fields and I have created the form bound to that...
2
by: troy_lee | last post by:
I have a form that screens the database. I build a dynamic WHERE clause into a string and apply it to the form's filter. I want to allow the user to save, say, five or 10 of their most-used...
2
by: lhsiber | last post by:
I am new to access and am having a problem with filtering. Here is a little bit of my setup: I have a main form that has a listbox so that users can choose one or many groups in which to display...
9
by: weirdguy | last post by:
Hello, Just for anyone information, there is a similar title "Search in Listbox" but it is via Combo Box. In case, anyone need it, I put a link to here. Please let me know if I break any rules...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.