My form has has an option group with 5 options (Manufacturer, Category, Sub Category, Product Family and Special) an unbound combo box which values is coming from different sources (see Relationship attached) depending on the selection made on the option group (e.g. if option 1 is selected...
It seems that sub form will not work for me. What I am trying to do is show/filter all records based on the value of the combo box. The "value" in combo box could appear in any of the fields of the table. I guess I did not state this clearly before. Thanks.
May2000
I need to filter records based on the the text value of a combo box and as the value in combo box changes, the filtered records need to be updated accordingly. Can somebody share ideas on how to proceed and perhaphs give a sample codes for me to work on.
Your help is very much appreciated...
I have an MSAccess database and an Microsoft SQL Server, I want to share the database to multiple users (no MSAccess). What is the best thing to do so that I can utilize The SQL Server and share the database without purchasing additional MSAccess licence?
Thanks,
May
Hi,
Need some help here. I am creating a Form with an Option Group (values 1, 2 & 3), A combo box wherein the row source changes (from Table1, Table2 & Table3) depending on the value of the Option Group. The selected text on the Combo box will the be used to filter the records on the Form.
Cna...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.