Hi All,
In a details subform I have two combo boxes, the second based upon the choice made in the first. So, the user chooses a manufacturer in the first box, and this narrows the choices available in the second.
Everything works just fine, but when a manufacturer is selected in the first combo, all the 'first' combos change - on each line - to the same setting!
The record is saved in the table correctly, but it will confuse the user...any ideas?
Thanks guys,
Stonward
That's just what happens in a continuous form if you try to use a cascading combo box. Access is unable to display multiple cascaded combo boxes dependent on the record.
You can turn off the limit to list and that will show the value but then it allows free entry and that becomes more of an issue than the user seeing weird data on the screen.
There's not much you can do about it except not use a continuous form.
5 4470
First guess would be that the combo box is not bound to any field. This would definitely cause the a situation like you describe.
That's just what happens in a continuous form if you try to use a cascading combo box. Access is unable to display multiple cascaded combo boxes dependent on the record.
You can turn off the limit to list and that will show the value but then it allows free entry and that becomes more of an issue than the user seeing weird data on the screen.
There's not much you can do about it except not use a continuous form.
zmbd 5,501
Expert Mod 4TB
Just courious:
Open your form
Select your combobox
Open the properties
Data tab
Post back the settings for:
(please enclose your reply for the following in a code block by clicking on the [Code/] format button and enter the data between the inserted tags. - [Control Source] = ?
-
[Record Source] = ?
-
[Record Type] = ?
-
[Bound Column] = ?
The reason I ask is that I V2010, my newest database is using the new navigation form... and all of the forms to the navigation form are "subforms" and I use cascading combo boxes.
Also many of these forms also use cascading comboboxes so I'm courious as to what I'm doing here that make these work where you're having an issue.
Hi Fellas,
Sorry for the delay - no internet!
Zmbd - I have no control source for the first combobox (it's unbound, tho I did try binding it); the RECORD source (for the subform) is a query, but if you mean RowSource it's a simple select statement against a one field table (manufacturers), the type is Table/Query and the bound column is '1' (there is only one. Let me know please if something is different in 2010.
Changing the Limit to List setting made no difference. Binding the combo gives a table relationship type error.
Guess I've reached a wall here? Never mind; got a more interesting problem to throw out soon if I can't crack it!
As always, thanks for your time.
Best regards,,
stonward
To do what (I think) you are trying to do, you have to have the combo box bound to a field. If you got an error, then you bound it to the wrong field. The RowSource should be getting values from a table that just lists the possible values that can be stored in the subform's recordsource. So you need to have the control source be the field in the "main" table, and not the field in the "list" table. Does that make sense? In other words, the foreign key field would be the field that the combo box needs as its control source.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Aravind |
last post by:
Hi folks.
I am doing a library system, and I have a form that diplays the full
history of who has borrowed what book for how long, etc. In that form,
there are 2 unbound combo boxes, "Select...
|
by: Edwinah63 |
last post by:
Hi everyone,
Please let there be someone out there who can help.
I have two BOUND combo boxes on a continuous form, the second being
dependent on the first. I have no problem getting the...
|
by: gedwards |
last post by:
First off, I am a complete newbie to Access. I've used it maybe a half dozen times, all my database knowledge is with Oracle.
I'm building a database/form in Access 2003. I'm trying to get it so...
|
by: wageslave |
last post by:
Hi folks,
I have a question about using consequtive combo boxes on a form.
I am designing a basic library database for a small community organisation which deals with inner city problems and...
|
by: prakashsurya |
last post by:
Hi
i am having a small problem with combo boxes
actually i am preparing a form
in which i have to go through the experience in years
for that i am using 4 combo boxes.
on the first two combo...
|
by: SPOILED36 |
last post by:
I am building a database to track attendance. I have one main form with multiple subforms. Within one of the subforms name sfrDailyAttendance, I also have cascading combo boxes (cboCategory and...
|
by: LLM |
last post by:
I have 2 combo boxes I want to tie together. Right now I have
C1.DisplayMember = "field1"
C1.DisplayValue = "field2
C2.DisplayMember = "field2"
C2.DisplayValue = "field1"
My thoughts were...
|
by: PiCubed |
last post by:
I'm trying to create a form that uses combo boxes to select a table and then from that table I need to create linked combo boxes that searches for information. The first combo selects the table the...
|
by: jerken |
last post by:
Im working in Access 2007 using two Combo boxes to select a category then product type. I am trying to get a couple fields to be displayed based on what the values are in the combo boxes. I have the...
|
by: sarvmardan |
last post by:
how to open a report in access containing filtered data using two combo boxes on form and a button to click.
let i have two fields and other is .
two comboboxes are combo11 and combo9.
plz post...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
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
|
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...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
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...
|
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,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
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: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |