Combo Box And Selection Of Item In That List.

Dec 12, 2006

Hello,

Didnt know where to start or what direction to head in. I have a combo box on one of my forms. It works fine, but would am looking for an added feature.

I am looking to get the following started:

There are 5 items in the list of my combo box. If the user selects the item called "Lost Opportunity", then how do I get an additional combo box to show up underneath it with reasons the sales opportunity was lost.

Then the reasons why would be in the additional box and they would have to select one...my work wants it so that if they lose the sale, they must provide a reason for that loss of business.

Any help in a direction would be appreciated.

Thanks.

View Replies


ADVERTISEMENT

COMBO BOX : Specifying Item Not In List

Jun 22, 2006

Hi everyone,

I have a form with a field named TREATMENT with the following options :-

1 Cryotherapy
2 Radiotherapy
3 Chemotherapy
4 None
5 Other (specify)

If the 5th option (Other) is selected, the user is required to specify what 'Other' represents.

I have created a combo box with the first 4 options and in instances of 'Other' the user can enter specific treatment that is not in the list (1 to 4).

What I would like to do is whenever the user enters a value that is not on the list (1 to 4), I would like to insert the word OTHER in front of the value entered. In other words all values not on the list will be prefixed by 'OTHER'.
E.G. if 'Surgery' is entered, I would like the value 'OTHER : Surgery' to be stored in the Treatment field of the table.

This will help in the generation of statistics from the table.

Any suggestions??

Many thanks in advance.


Will

View 3 Replies View Related

Updating New Item Into A Combo Box List

Aug 24, 2006

Hi,

I am using a combo box in my form. It is a growing combo box allowing new entries to be entered to create a growing list.

When new entries are made to the combo box list they are only displayed when I quit the form and then return to it. Is there any way I could allow the combo box list to grow dynamically rather than having to get the user to quit the form and then return to it?

Many Thanks
Turbojohn

View 6 Replies View Related

Have Combo Box Show First Item On List

Oct 20, 2004

I have made a few cascading combo-boxes that dynamically change based on the data entered into the field above them.. Example:

A SKU is entered, the combo-boxes pull the information for that sku from one or more tables (using SQL Query).

Now... I am having trouble getting these fields to show the first item in the list of possible item specifics. Everything comes in fine, however, I need to form to refresh and repopulate the fields one the SKU loses focus.

Any Ideas?

View 7 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

Using 2 Combo Boxes - 2nd One List Depending On Selection In First

Sep 23, 2005

(pls see end of thread for further clarification)

Hi

I am trying to achieve the following using 2 combo boxes

Box "a" is a list of courses from tbl_training_courses. The user selects the appropriate course.

Box "b" is a list of dates for each course from tbl_course_dates. Thus the user can select which date per course they want to book someone onto, and this value is then stored in tbl_training_record as the date the person is booked onto.

Its not working!!! It either displays blank values, or it starts a parameter query which I didnt want.

In the combo wizard, access refers to "remembering the value selected for later use" - i guess this might be what I need to use, remembering the value from the first and using it to select rows for the 2nd box based on identical courseID - but I can't seem to find this in Help file.

Any ideas anyone?

View 6 Replies View Related

List Box Populated Depending On Combo Box Selection

Feb 1, 2006

I have quite a simple problem I think, but i don't know if I'm able to explain it properly.

I have three tables:

one for contacts
one for the groups contacts are a member of
and a junction table to solve the many to many relationship there.

What I want, is to create a form, with a combo box with a drop down list of groups. When a user selects a group, I'd like all the contacts (including *some* of their fields) to populate the list box below.

So a user can easily view the members of each group.

Does that make sense?

View 6 Replies View Related

Modules & VBA :: List Box Respond To Combo Box Selection

Dec 11, 2014

I am using access 2010

I am trying to get my list box to filter based on the selection of a combo box.

My Combo box cboOrgRole is on my main form and is bound to OrgRoleID - on form - frmOrgEntry

The unbound list box lstRoleList is in a tabbed subform - frmPersonnel

This is my data pull for lstRoleList

Code:
SELECT tbl00PersonRole.PersonRole, tbl01Orgs.OrgRoleID
FROM tbl00PersonRole INNER JOIN tbl01Orgs ON tbl00PersonRole.OrgRoleID = tbl01Orgs.OrgRoleID
WHERE (((tbl01Orgs.OrgRoleID)=[Forms]![frmOrgEntry]![OrgRoleID]));

This is the code I have on cboOrgRole AfterUpdate

Private Sub cboOrgRole_AfterUpdate()
Me.frmPersonnel.lstRoleList.Requery
End Sub

I have also tried Recalc - both throw a Compile error: Method or data member not found

My goal is to be able to select the role of the organization, (General Contractor, Architect, Engineer, or Client) and have it list the available titles for the specific organization type.

My "00" tables are library tables

View 12 Replies View Related

COMBO Box Selection Filters Out A List Of Contacts?

Jun 30, 2015

I'm trying to set up my own form for my customer contacts.

I have TABLE A that lists general customer information.

I have TABLE B that lists customer branches (each customer has multiple branches).

I have a combo list set up so that if I select a customer name, the rest of the form populates with the customer general information.

Is there any way I can filter out a list depending on what customer is selected?

I only want to see the branches of the customer I've selected on the COMBO box.

View 2 Replies View Related

Forms :: Filtering List Box Using A Date Rage And Combo Selection

Jan 5, 2014

I am using this code to filter a List Box based on a Date range and a Combo Box selection:

Code:
Private Sub Combo139_AfterUpdate()
Dim StrgSQL As String
StrgSQL = "SELECT [User Name], [Date Of Request], [Description of Problem], Status, Sub_Job FROM QRY_SearchAll " & _
"WHERE [Date of request] BETWEEN #" & CDate(Me.txtStartDate) & _
"# AND #" & CDate(Me.txtEndDate) & "#;"
StrgSQL = StrgSQL & " WHERE Sub_Job = Combo139"
Me.SearchResults.RowSource = StrgSQL
Me.SearchResults.Requery
End Sub

However, It is not working. when I click the Combo box the List Box comes up blank.

View 13 Replies View Related

Created List Box With One Column - Display All Characters Of List Item

Jan 2, 2014

I have created listbox with one column (contains one column only), now i would like to display all the characters of list item (want scroll bar to listbox).

How do i display all text of list item, I have already fixed Column Widths to max length (22";0.1"). However when scrolling to right, it is going to next blank column of list box, which is created only to change Column Widths property.

View 12 Replies View Related

Forms :: Nomination Form - Combobox Selection List Not Updating After Each Selection

Oct 27, 2014

I am designing a nomination form (web database so no vba macros can be used).

The form has 3 combo boxes: cboStaffName, cboLevel, cboNominee.

The form is bound to the tblSubmit table where the submissions are populated.

I used a select statement:SELECT Staff_List.Staff_Name FROM Staff_List; to populate the combo box for the Staff Name selection.

This is the select statement to populate the job level combobox:

SELECT Staff_List.Level, Staff_List.Staff_Name FROM Staff_List WHERE (((Staff_List.Staff_Name)=[forms]![frmtest]![cboStaffName]));

The select statement to populate the combobox for the nominee combobox:

SELECT Staff_List.Staff_Name FROM Staff_List WHERE (((Staff_List.Level)=[forms]![frmtest]![cboLevel]));

The problem is that the staff_name in the first combobox is still found in the nominee combobox which should not be because a staff cannot nominate self. There is a field in the Staff_List called YesNo that should be activated for each staff that is selected so that the select statement on the nominee combobox can be updated accordingly to remove items with the field "Active"

How to get the checkbox selected for each corresponding staff.

Sample of the database has been attached.

View 4 Replies View Related

How To Transfer Multiple Select Item In List Box To Another List Box

Jun 2, 2012

How To Transfer MultipleSelect Item In Listbox to another Listbox ?

View 7 Replies View Related

Drop Down Selection - Once Item Is Selected - Populate Field To Right

Apr 14, 2014

I am trying to do the following. I understand how to create relationships.However, when I create a field with a drop down selection (in this example Phone Number and Email) once that list item is selected I would like the column to the right to populate that information.So when Phone # is selected, the field to the right will populate a number for this individual.

View 2 Replies View Related

Forms :: List Box - Selection - Populates Next List Box

May 20, 2013

I am wanting to preempt data in list boxes

listbox1
Fruit
Vegetable

listbox2 (If Fruit Is Selected)
Apple
Banana
Orange

listbox2 (If Vegetable Is Selected)
Potato
Peas
Carrot

If Fruit is selected in Listbox1 - Then Listbox2 should have the options
Apple
Banana
Orange

If Vegetable is selected in Listbox1 - Then Listbox2 should have the options
Potato
Peas
Carrot

View 12 Replies View Related

Selecting An Item In List Box

Oct 30, 2005

Hi
I have placed a Listbox in MS Access form. I use VBA. I have saved the item selected in the List box in a database. While retrieving the item from database, I want the listbox selected i.e the item should show as highlighted in the list box. Is this possible ?

View 3 Replies View Related

List Box Move Item Up / Down

Sep 10, 2012

I have a listbox named list0. How to move item up/down in listbox by using command button.

View 9 Replies View Related

Changing The Colour Of An Item In A List Box

Sep 13, 2006

HI all, the objective is to grey out an item within a listbox, where the id number is the same in another sub form. The sub form is called contacts and the list is called list15. the unique id that is linking the two is SWD.

HELP...:confused:

View 1 Replies View Related

Is It Possible To Select The Same Item Twice Using A MultiSelect List Box

Jun 29, 2007

I would like to be able to create a recipe (saved in its own table) by pulling items from a multiselect list box (from the raw materials table) but which allows me to add the same ingredient more than once.

I work for a chemical manufacturing company and we need to track the cost of goods by recipe (final product), by linking the ingredients (where the cost of the raws are associated) to the final prodcut. Several of our products need to have chemicals added in the beginning, but then again at the end of the procedure unlike normal kitchen recipes.

(I sure hope I don't have to learn VBA . . . I'm totally new at Access!)

Thanks in advance for your help.

View 3 Replies View Related

Forms :: How To Select Item In A List Box Using VBA

Dec 30, 2014

I want to select an item in a listbox that has a specified value when I open the form that contains this listbox. Most I've found describes selecting records based on their index value but I want to select an item according to the actual value that's displayed in the listbox. For example, the first number below is the index value, the 2nd is the number I'm interested in and the 3rd is another column in the listbox:

0 1 12345
1 2 33256
2 4 36280

I'm using the OpenArgs property to pass the value (a long integer primary key) to the opening form but I don't know the syntax or correct terminology for ensuring the specified row is selected in the listbox. At present, using the above example, if I want to select the row with the value 2, it's selecting the 3rd row rather than the 2nd.

View 8 Replies View Related

Forms :: Adding New Item To List Box

Apr 14, 2013

I have a list box on a form and I would like the user to have the possibility to add another item not from the list into the table using a command button. How can I do that?

View 11 Replies View Related

Modules & VBA :: Save Item In List Box To A Table

Jul 11, 2014

Save Item in listbox (Row source type : Value list) to a table in a database .

View 3 Replies View Related

Forms :: Clearing Item List From 2nd Form

Feb 26, 2014

My main form has a list box - user selects an item in the list box for editing. The selected item displays in a text box on the subform where the editing is to be done. User than makes corrections to the text box and clicks a button to save the changes. I have all of this working. But I can't figure out how to update the main form on this save button.

What is happening right now is the main form is not updating at all and the original selection in the list box is still highlighted. If I click within the list box, the list box updates with the correct entry.

What I need to happen is when the save button is clicked, that the listbox updates and the selection in the list box is deselected and then set focus on another text box that is on the main form.

(I was doing this as 2 separate forms and the edit form opened after the user selected the item and clicked a button (kept the first form open but not visible and based the text box on the list box) This worked but again when the user saved and returned to the first form even though I was able to setfocus to the text box, the list box kept the selection highlighted.)

View 3 Replies View Related

General :: Drop Down List With New Entry Item

Aug 7, 2012

Drop down list equipped with new item input provided. My application now use a drop down list to access/display a form with certain item selected, but I want to entry new item using drop down list which equipped with "entry new item" then I hope the form can be accessed belongs to new item.

View 1 Replies View Related

Automatically Inserting A Date When A Item Out Of A List Box Is Selected

Aug 28, 2003

I have a MS Access database, which contains three main tables. With these I have a completed table, which holds either Yes/No within it.

One of the tables, I have linked to the Completed table as a list box, which when a job has been completed, either yes or no can be selected.

But, what I want to happen, is, when the Yes is selected, I want Access to insert the date the 'Yes' was selected, so that the employee cannot lie about the date the job was completed.

Hope I have explained this in a good enough fashion.

I don't have a clue how to go about it, could anyone help.

View 6 Replies View Related

Forms :: Combobox Defaults To 1st Item On Dropdown List

Sep 16, 2013

My combobox is not working correctly. When I select one of the dropdown items in the combobox it always defaults to the 1st item on the list. I want to be able to select any of the dropdown items on the list.

View 3 Replies View Related







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