Forms :: Make One Combo List Depend On Another

Sep 24, 2014

I have a combo: cmb_TrainingType. The sql is:

Code:
SELECT tblTrainingType.TypeID, tblTrainingType.Type FROM tblTrainingType ORDER BY tblTrainingType.Type;

My second combo (the one that should be filtered based on the Type chosen above) is cmb_Project_Title. The sql I have written (which isn't working) is:

Code:
SELECT tblCourseDetails.CDID, tblCourseDetails.Project_Title FROM tblCourseDetails WHERE (((tblCourseDetails.TypeID)=Forms!frmResourcing.cmb_Training_Type) And ((tblCourseDetails.Type)=Forms!frmResourcing.cmb_Training_Type)) ORDER BY tblCourseDetails.[Project_Title];

Both of the tables that are referenced have the fields TypeID and Type.

View Replies


ADVERTISEMENT

Forms :: List - Values From A Table Depend On Selection From Different Table

Jul 23, 2015

Situation: 3 tables. Manufacturers, Countries & Provinces/States. 1 Form for data entry in Manufacturers.

Countries table contains ID, Country and CountryCode fields. i.e. 47, Great Britain & GB

Provinces/States table contains ID, Province/State and CountryCode. as in 1, Alaska and US.

In the form the country is easily selected from a list refering directly to the Countries table.

Problem: How to make a list in the form from which the user can simply select the province for the country that has previously been selected. And not a list with all teh provinces and states from every country in the world. (This would be a really really long list...)

View 3 Replies View Related

How To Make A Table Lookup Field Depend On Value In Another Column

Sep 20, 2012

I have a table called Locations that lists Countries and Cities:

USA, Detroit
USA, Chicago
USA, New York
UK, London
UK, Liverpool
UK, Birmingham
France, Paris
France, Le Mans

I then have another table for inputing details on people I know. This table would have columns called Country and City. I've figured out how to make the Country column a "lookup column" so that I can only enter USA, UK or France. But how do I make the City column show only the appropriate list of cities relevant to the country that I've selected (e.g. Paris or Le Mans if France is the selected country).

View 5 Replies View Related

Dropdown List To Depend On Other Field

Mar 15, 2008

I'm trying to set up a database of books in a small library - each book has a prefix (Maths, English, Art etc) which I want users to be able to pick from a drop down list - I can do this, but the next field is a sub-category - is there a way of populating the dropdown list for the sub-category field depending on the chosen entry in the prefix field. eg if maths was chosen I would like the user to have the choice of number area, volume etc. but a different choice if the prefix was English.

any help very gratfully received - it seems to be a simple problem but it has me stumped.

View 14 Replies View Related

Howto: Second Combo Depend On Value From Another

Aug 22, 2007

Dear all,

I am trying to do the following on a form:

field "A" is a combobox listing filed from a table (Field= CustomerName, Table=Customers).
filed "B" is a combobox that have to list filed Contact.Name where Ciontct.CompanyName = <companynmae selected at te first combobox>. What is the field name containing the value selected in the first combobox? How to write a SQL that workds?

Thanks for your help.
Itschak.

View 1 Replies View Related

Forms :: Subtract Value From Combobox Depend On Value In Other?

Feb 22, 2014

i want to substract value in combobox, but the source of the other combobox is in other table then Form query shows. How can i do that?

View 3 Replies View Related

Forms :: How To Make Combo Box Remember Previous Value

Jun 30, 2014

Only thing left is a combobox (dropdown) with predefined values. What i want is, as soon you have picked a value from the combobox, save the record and go to the new blank record, the last picked value of that combobox auto appears in the combobox for the new record.

View 1 Replies View Related

Forms :: How To Make Combo Box Visible When Click On Label

Sep 28, 2014

i have a label and a combobox (the combobox is invisibile). in a form.

how do i make the combobox visibile when i click on the label?

View 2 Replies View Related

Forms :: List Combo Box With All Forms Of Access Database?

Sep 5, 2014

Is there any way to list a combo box with all the forms of an Access Database?

View 5 Replies View Related

Forms :: Alternative To Combo Box And List Box?

May 6, 2015

I am trying to avoid to use a Combo Box & a List Box because of the way the records are stored in the table, I only need to verify that the user does not enter a 3 letter code that is not contained in a specific table (I have a table of countries with the 3 letter code example if the user types ESC instead of ESP an error appears) Is it possible to use the after update to verify the contents against a table?

View 4 Replies View Related

Forms :: Filtering (All) From Combo Box Value List?

Jul 19, 2013

I have a combo box on a form which has a row source type of Value List in which I've manually typed in 2 entries: Owned, Leased.

I have a query which filters on the results of the combobox, and works fine for when I select either option Owned or Leased.

Is there an easy way to filter all (both Owned & Leased)? I've tried leaving the combobox blank, and tried entering a * in the value list, but they both return no results.

Code:

SELECT Assets.*
FROM Assets
WHERE (((Assets.Possession)=[Forms]![Home]![Combo56]));

View 4 Replies View Related

Forms :: Popup List Instead Of Combo Box?

Aug 7, 2014

Is there a way to make a popup list open on click of a button (cmdAssign) and the user chooses/selects something from the list, then the popup closes and the textbox (txtAssignmentNo) is filled with the choice?

View 3 Replies View Related

Forms :: VALUE LIST Combo Box - No Duplicates

Aug 29, 2013

I am using a sequence of combo boxes on a 'Continuous' form.

To reduce the possibility of error I am using a 'Value List' combo box where I use AddItem method to add the previously entered string to the combo control so that it is there for use when entering the next record.

This works fine - but what I want to ask is - how to have a routine to check that the string does not already exist in the combo box before I AddItem i.e., I don't want duplicated values in the list.....

View 2 Replies View Related

Forms :: Filter A List Box Using Combo Box

Jul 16, 2014

I have a list box and a combo box on a form based on a query. The list box is a multi-select, with column values of Client, ClientEmail, and Medical.

Medical is a simple yes/no field, and it is what I want the combo box to sort by. I have a Where clause in the query: WHERE (Medical=[forms]![frmOne]![cmbbx]), and the only values in the combo box are Yes and No (1 column). I also have the combo box set to run a requery macro after updating. I've also tried to change the macro to VBA:

Code:
DoCmd.Requery "lstbx"

When I pick a string from the combo box, the list box just goes blank, rather than updating to clients who either do or don't have Medical, and I can't understand why.

View 1 Replies View Related

Forms :: Combo Box Allowing Not In List Items?

Sep 29, 2014

I am using the following code in a textbox (CountryID) to show a country name (CoName) from a table (tblCountry). If the comboBox (cmbCoName) in current form (frmCountry) has no entry then CountryID remains blank, great. If I use the form to add a new entry then CountryID flashes because it does not recognize the entry. Can I use "or" to add another condition in the IIF statement so that it allows the "not in the combobox list" entry?

Code:
=IIf(IsNull([txtCoName]),"",DLookUp("CoName","tblCountry","Country_ID = " & [Forms]![frmCountry]![txtCoName]))

View 2 Replies View Related

Forms :: Combo Box Wants To Show Records Not In List

Apr 4, 2013

I'm sure there is an easy way to do this but I have not clue.

I have three tables:
Students
STUDID (pk)
txtFname
txtLname
etc.

Classes
CLASSID (pk)
txtClassName
txtClassRoom
etc.

Student_Class (join table)
STUD_CLASSID (pk)
fk_StudID
fk_ClassID

On my Class form when assigning students there is a combo box which shows the students names. Once a student is picked in the combo box their name shows up in the subform.

What I would like is a way to NOT show a student in the combo box after they have been selected. Is this possible? Or should I be looking at another way of doing this?

View 13 Replies View Related

Forms :: Remove List Item From Combo Box After Use

Sep 1, 2013

Is it possible to remove an list item from a combo box list after it has been used.

What I am trying to do is use a combo box that has a list of questions, after the user selects a question from the combo box list and answers the question when they reselect the combo box that question will not be seen again till the form is reloaded.

View 2 Replies View Related

Forms :: Combo Box Selecting Beyond Displayed List

Sep 11, 2013

I have a working combo box on a form that displays issue numbers for part number typed into a text box.This all works fine when the list of issue numbers is below the displayed list (16), but when the list is longer than 16 you cannot seem to select anything after item 16.

When the combo box has, say 25 items a scroll bar appears allowing the user to scroll down to item 25, but when you click the mouse the list just reverts back to the first 16 items? The only way to select an item after 16 is to select item 16 which then closes the combo box, then when you reopen it the list now shows items 17 to 25 which you can then select item 25.

This is the same in reverse, when you have item 25 selected, you cannot select item 1. When you click the mouse the list reverts back to items 17 - 25.The combo box is populated in code using the lost focus event on the text box for the part number.

View 7 Replies View Related

Forms :: Chart Not Working From Combo List?

Dec 5, 2013

I have a chart I am trying to create that pulls data from a table. It pulls from a list of about 7 items. The issue I have is when I do this it is showing the ID numbers in the legend and not the actual names>

How do I fix this.

View 1 Replies View Related

Forms :: Changing Combo Box On Form To Allow Entries As Well As The List?

Jun 3, 2014

How do I change a combo box that I have on a form so that it will allow entries as well as edits?

View 1 Replies View Related

Forms :: Manage Lists For Combo And List Boxes?

Aug 15, 2015

During the course of it's development I have created about twenty tables whose sole purpose is to house data for use in combo and list boxes. They have no other purpose.

I am now in the process of creating the maintenance side of this project and how to manage these lists. In the past I have created a form with a multitude of subforms to manage these lists.

View 1 Replies View Related

Forms :: Reset Combo Box To Blank Or Non Selectable Value In List

May 29, 2014

On my unbound form I have a combo box with a record source type set to value list and the record source with two choices in it. I would like the combo box to reset back to either blank or a the phrase "select one" once a record is saved. If it shows "select one" I do not want the user to be able to actually select that. As I said the form is an unbound form and I have used the coding of "insert into" to save the new record to a table. I have been able to clear the text box on this form when the new record is save by resetting it's value to "" but have been unable to reset the combo box to blank.

how do I reset the combo box through code after a save to display nothing - or is there a way to add a non-selectable choice to the list and have it display when the form is refreshed.

View 4 Replies View Related

Forms :: Conditional Formatting - Combo Box To Highlight If Value Is Not On The List

Feb 23, 2015

I want to add a conditional formatting to a combo box to highlight if the value is not on the list.There is a process to read in data from a 3rd party excel sheet that has truck arrival dates and times. My form displays this data and allows the internal users to change it. My form has the "Trucks" field as a limit to list combo box - so basically any data can be read into this field but internal we can only change it to trucks on the list (from the trucks table). I want to highlight where the trucks value is not in our trucks list.

View 2 Replies View Related

Forms :: Adding Key Value Pair In Combo Box Using RowSourceType As Value List

Jun 20, 2013

I am creating a form in access. In the form there is a combobox in which I am adding items using RowSourceType as Value list and Row Source as Male;Female. What I require is whether there is some way so that when I select Male from combo box M is stored in database and with Female F is stored. I know how to achieve this with RowSourceType as Table/Query but not with RowSourceType as Value List.

View 1 Replies View Related

Forms :: Requery List Box In The Form After Combo Box Updated

Jul 11, 2015

How do I requery the list box in the form after the combobox is updated? the name of the combo box is txtFilterClassName.

View 3 Replies View Related

Forms :: How To Reorder Displayed Columns In Combo Box Dropdown List

Jan 10, 2015

I'm a newbie with Access, how to reorder the displaying of the columns in a Combo Box dropdown list of have in my Access 2007 application.

The columns that are being displayed are (in the current order):

Part Name
Unit Price
Parts.Web_Category

I want the order to be the following:

Parts.Web_Category
Part Name
Unit Price

View 13 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved