Hi! It works but I do have a slight problem - more of a display issue...I have two forms in Navigation Form: supply request and order. Supply Request is the main form and order is a subform (a subform within a subform which I know is pretty rare...) There are two combo boxes: category and item. Item is dependent on category, if I add another record then the other row for item disappeared. If I click on it, it "repopulates" if that makes sense?
Hi eric! Is it possible to have cascading combo boxes on a subform in relation to a form? For example there's two combo boxes, category and product. Category is in the main form whereas the product is in the subform. So when I click a desired category in the combo box in the main form, the list of items in the product combo box in the subform will only be related to the selected category in the main form.
After several tries, I got it! I just have to declare that the combo box from the subform be related on the main form. I may have other queries, I'll just ask them here. 😊
Hi Eric... Just found your video. I'm basically self taught in access, so writing code is a struggle. I was hoping maybe you could help me an issue I can't get passed. I have a main form (named Primary Form) and a subform (named service request). I finally figured out cascading combo boxes (if I choose PH in one combo box, I see cardiology, endocrinology, etc.) in the next combo box; if I choose BH, I see psychology, psychiatry, etc.). The combo boxes are located on the service request form. My primary form contains the agency name, contact name, email and auto ID. When I dropped my subform into the main form, it will not allow me to add new agencies. I'm sure the issue is in writing the code in the primary form. Do you have any ideas why these two forms aren't in sync?
@@LoeblComServices Hi! Thanks for getting back with me. Yes, the PK is ProviderID; I'm not sure I have a FK connected. The relationships between the tables are enforced referential integrity between ProviderID in the ProviderJoinT (the table that contains agency name, contact name, etc.) and the ServiceRequest table.
Not being able to add data is normally a result of bad data relationships. If you want, you can send me a copy of your database, and I can possibly help out a bit more. erik [at] loeblcomservices.com
@LoeblComServices Thank you! Your video has been very helpful. I like to do a concartenation of two values in the select statment. But I have not fond how. Example: strSQL = "SELECT Id, Name & ", " & Value AS Attribute, Configuration FROM parties_Attribute WHERE Configuration = " Me.Configuration. Its the Name & ", " & Value AS Attribute part that I didnt solve. Is there solution to make this kind of concartenation in the SQL-statment?
Hi, depending on what you are trying to do, here is some example syntax, that hasn't been tested, but may help: strSQL = "SELECT Id, [" & Table.FieldName & "], '" & Table.FieldValue & "' AS Attribute, Configuration FROM parties_Attribute WHERE Configuration = " & Me.Configuration
This works, and if it doesn't work for you, you probably did something wrong. Send me a sample at erik [at] loeblcomservices [.] com, and I'll help you out.
Let me know if you have any questions in the comments below.
Hi! It works but I do have a slight problem - more of a display issue...I have two forms in Navigation Form: supply request and order. Supply Request is the main form and order is a subform (a subform within a subform which I know is pretty rare...) There are two combo boxes: category and item. Item is dependent on category, if I add another record then the other row for item disappeared. If I click on it, it "repopulates" if that makes sense?
@@kristapann6728 Krista Pann Hi Krista, sounds like design issue. Is there any way I could get some sample data?
@@LoeblComServices hello! where would you like me to send you the sample db?
@@kristapann6728 You can send it to erik [at] loeblcomservices [dot] com
Hi eric! Is it possible to have cascading combo boxes on a subform in relation to a form? For example there's two combo boxes, category and product. Category is in the main form whereas the product is in the subform. So when I click a desired category in the combo box in the main form, the list of items in the product combo box in the subform will only be related to the selected category in the main form.
After several tries, I got it! I just have to declare that the combo box from the subform be related on the main form. I may have other queries, I'll just ask them here. 😊
Hi Ian, sure that's possible, just have a main form/subform setup
Hi Eric... Just found your video. I'm basically self taught in access, so writing code is a struggle. I was hoping maybe you could help me an issue I can't get passed. I have a main form (named Primary Form) and a subform (named service request). I finally figured out cascading combo boxes (if I choose PH in one combo box, I see cardiology, endocrinology, etc.) in the next combo box; if I choose BH, I see psychology, psychiatry, etc.). The combo boxes are located on the service request form. My primary form contains the agency name, contact name, email and auto ID. When I dropped my subform into the main form, it will not allow me to add new agencies. I'm sure the issue is in writing the code in the primary form. Do you have any ideas why these two forms aren't in sync?
Hi Amanda, does your subform contain a related key to your main form? (PK and FK)
@@LoeblComServices Hi! Thanks for getting back with me. Yes, the PK is ProviderID; I'm not sure I have a FK connected. The relationships between the tables are enforced referential integrity between ProviderID in the ProviderJoinT (the table that contains agency name, contact name, etc.) and the ServiceRequest table.
Not being able to add data is normally a result of bad data relationships. If you want, you can send me a copy of your database, and I can possibly help out a bit more. erik [at] loeblcomservices.com
@LoeblComServices Thank you! Your video has been very helpful.
I like to do a concartenation of two values in the select statment. But I have not fond how.
Example: strSQL = "SELECT Id, Name & ", " & Value AS Attribute, Configuration FROM parties_Attribute WHERE Configuration = " Me.Configuration.
Its the
Name & ", " & Value AS Attribute
part that I didnt solve.
Is there solution to make this kind of concartenation in the SQL-statment?
Hi, depending on what you are trying to do, here is some example syntax, that hasn't been tested, but may help:
strSQL = "SELECT Id, [" & Table.FieldName & "], '" & Table.FieldValue & "' AS Attribute, Configuration FROM parties_Attribute WHERE Configuration = " & Me.Configuration
@@LoeblComServices Thank you much appreciated. :)
Thanks
Glad to help
How to do add cascading comboboxes to a subform in FORM view?
So the subform has a default view of a form? Could you send me a picture of the form? erik at loeblcomservices dot com
This works, and if it doesn't work for you, you probably did something wrong. Send me a sample at erik [at] loeblcomservices [.] com, and I'll help you out.