Limit The List In A Combo Box

Dec 4, 2004

I have 2 tables. One is Quotation and the other one is Contacts.

In Quotation Table i use a combo box to select a Customer from Customer Table.
Also in Quotation Table a have a combo box (TO) to select a name from Contacts Table.
The problem is that i want to select contacts only related to Customers and not view the
complete list.

For example Vodafone Company has several contacts.
When i press Vodafone in my quotation form then when i go to (To) combo box i would like to view only the
related contacts.

I tried the SELECT statement WHERE but i can to figure out how i will limit the list depending the Customer Name?
Please help.

View Replies


ADVERTISEMENT

I Don't Want To Limit To List!

Jan 24, 2005

Hi,

I am trying to display data from a table. One of the fields is entered via a combo box. When displaying that data on a form I need to be able to allow items not on the list(created by a select query) to be displayed for this field. The data was created some time ago and it seems that records have been deleted in certain places which has resulted in inconsistent data.

I am happy resticting data entry for new records, but need to allow items not on the list to be displayed for historical data. Data entre and displaying of historical data take place on seperate forms so this is no problem.

My problem is that I am only able to disable limit to list if I make the bounded column anything other than 1 and doing this displays the wrong data!

Am I attempting the imposible or if not, can anyone help?

View 3 Replies View Related

Limit List Form

Apr 7, 2005

I have a form, which lists all reports i have available in my dateabase.
But there is 1 report which i dont want visable to users, how do i restrict access to this 1 form, either by it not showing on the list or password protecting it.
users have to double click the report name to open it from the list.

TY in advance

View 10 Replies View Related

Limit To List Property

Dec 2, 2014

I got 2 forms that are relatively similar. One of them works fine but the other does not. It still lets me enter data into the field even though Limit To List property is turned on. I believe this is a combo box and I gave this field a value list for the user to choose from.

View 2 Replies View Related

Forms :: Limit Number Of Selections In Multiple Value List?

Apr 8, 2013

Is it possible (without using VB) to limit the number of selections a user can make in a multiple value list?

My list is one a form and when in the form field it brings up a total of 15 names with checkboxes, allowing you to "check" each name you want. However, I want to be able to have as many names as I need in the list, but limit the user to selecting only two of them.

View 3 Replies View Related

Forms :: Limit Dropdown List To Specific Record

Mar 24, 2015

I have a list of customers. [ID] on (Form1)

I click_on their name [ID] that opens a dialogue (Form2 )specific to them.

I have a table of several dates with the relevant [ID]

I want a dropdown box on Form2 that only shows the dates for that specific customer[ID]

Ive tried [Form2].[ID] in the criteria of the ID field in the query for the dropdown data source.

View 3 Replies View Related

Queries :: Limit Query To Selected Items In A List Box

Nov 27, 2013

I want to limit the results in a query to the selected items on a list box - how do I do this?

View 4 Replies View Related

Combo Box Limit

Jun 17, 2005

I have a combo box that worked fine. Now it will not show any records after the 65530th record. I can remove a record and it will show the next one down so it appears to be a setting that controls the nuber of records shown. Any suggestions on how to show all the records would be great.

The program is attached to a SQL table.

View 1 Replies View Related

Limit The Value Of A Combo Box

Dec 12, 2004

Order Forms in my database have a combo box Refference from Quotation.
When i select a refference then automatically i create an order.
Is it possible to limit the list on Refference, lets say when i have selected the refference
once do not display it again?

View 3 Replies View Related

Limit The Values On Combo Box

Aug 24, 2005

I have a combo box displaying refference values.
Those refference values when i select them once i do not want to use it again therefore i do not want to be displayed again. Is it possible to do that?
Maybe with After Uptade code i can do that and how?

Please help

View 1 Replies View Related

Combo Box 64k Limit Workaround Examples?

Nov 3, 2006

Hi, I know well that combo box has a 64k limit, and whilst there are obvious work around, does anyone here have any sample code for such a solution?

I'm not an expert ms access programmer, and it would save me a lot of time if I had an example to work with.

Thanks

View 1 Replies View Related

Forms :: Limit Items In A Combo Box?

Aug 12, 2013

I have a combo box in which I wish to show the Person_ID's of every record in the table TBL_Person, except those which are returned by a separate query. Is this possible at all?

View 1 Replies View Related

Forms :: Limit Of Records That Can Be Shown Via A Combo Box?

Oct 29, 2013

In the form frmOrders of my database i have a combobox where i can choose a ClientID and the dropdown list shows me all the clients in upgoing order with their related orders in descent order.But the drop down list doesn't show all available clients. The two hundred heighest clientnumbers aren shown. However if i type one of these clientnumbers in the textbox of the combobox, the client is found.If i go to the property sheet of the combobox and activate the query that serves as the recordsource of the combobox, all clients are shown!!!I control of the records of these clients in the table Orders, doesn't show any difference with all the other records.What can be the reason for these behaviour. Is it a question of a limit of records that can be shown via a combo box?

View 4 Replies View Related

Forms :: Limit Data Entry To One Of Four Available Combo Boxes

Apr 29, 2015

I have a form with four combo boxes on it, the four boxes all open the same form and return a record based on the selection from a different column from the same query.

To make it work smoothly I think I need to make it so it is only possible to enter data in one combo box at a time. I could also do with some error handling.

View 2 Replies View Related

Forms :: Limit Values Of Combo Box Based On Value Of Another Field

Aug 25, 2014

Field B is a combo with the options of : 100% Availability, 75% Availability, 50% Availability, 25% Availability, OR Not Available

If I choose "Present" in Field A, I want the "Not Available" value to disappear as an option.

View 2 Replies View Related

Tables :: Limit Combo Box Results Based On Secondary Table

Dec 4, 2013

I have a DB with 4 tables:

Property (used for look-up values)
Service Type (used for look-up values)
Rate Table (uses the Property Table and Service Type Table and is used as a rate look-up table for the daily service table noted below)
Daily Service

Using the Daily Service table, I need to choose a property, choose a service type that is limited to the property (100's of service types, but a property may only have a limited number), and enter a quantity, and have the Rate Table return the specific cost of the service. I didn't think this was too hard in Access (2013), but I seem to be hitting a wall and spending too much time figuring it out. Now I am behind in my project.

I have been trying to do this in a table format, but have been unsuccessful in limiting the results of the Service Type combo box based on the property chosen.

View 2 Replies View Related

List Box Vs. Combo Box

Feb 6, 2005

I have a form where I select a vendor name out of a combo box.

The rest of the vendor information then defaults into combo boxes below. I want these to actually be list boxes so that the user does not have to select the rest of the vendor information. The only problem is that when I turn them into list boxes the data does not save into the underlying table. How do I get the list box information to save??

View 3 Replies View Related

Combo Box Or List Box?

Feb 14, 2006

Hi Newbie here -
Both to the forum and MS Access!! - I'm trying to build a db at work that allows us to track our residents activities on a daily basis and then report monthly, etc. What I want to do is to able to use either a list box or a combo box to highlight more than one resident and more than one activity (our residents go out on group activities, so it would be ideal if we could assign a resident to several activities or an activity to several residents) and then add the records to the relevant tables.
I've looked at multiselect in list boxes but that will only allow me to add one single record at a time which would make the job v-e-r-y laborious. Combo box will only allow me to add one record at a time. Any suggestions? Thanks in advance.

Ady:)

View 1 Replies View Related

List Box - Combo Box

Oct 27, 2006

Hi, i'll try my best to explain what i would like to do.

I have a form (based on a Table "Tbl_AOG_Demands" which has a combo box called "Combo30" Using this give users access to all request details "regardless of status"

I also have a list box "List21" which does nothing other than shows ONLY open requests. (also based on Tbl_AOG_Demands) but filtered through SQL.

As there are many requests in the combo box (historic data) i would like to make things easier for the user by the following.

When a user clicks on a request in the list box, it will populate the rest of the form with the corresponding data. (and also the combo box "if this is possible)

I hope this makes sence.

View 2 Replies View Related

How To Add New Values In Combo Box List

Mar 1, 2006

need help., have a form, have put a combo box to display values from another table, works ok, but when a type a new value, it displays 'not in list', so how to add the value to the table without opening the other table or any other suggestion, should i select values in combo box from a query...
:eek:

View 3 Replies View Related

Add Record And Combo List

Apr 4, 2006

I have an add record command button that will bring up a blank record where the user can fill in the information. My question is how do I get this record to be added to the combo list that will bring up the record i just filled out? I hope that makes sense. thanks

View 2 Replies View Related

List All The Years In A Combo Box

May 20, 2006

I hope someone will be able to help....

I have minimum year and maximum year value (for example 2006 is minimum & 2009 is maximum. How could I get a combo box to display all the years within the range of the minimum and maximum year (in this case, it should give me an option of 2006, 2007, 2008, 2009).

FYI - This database is used to track projects and each project has a commencement date and an estimated completion date. the minimum year is derived from the commencement date and the maximum date is derived from the estimated completion date. I am building a search form whereby the year selected in the combo box should display all the projects commencing, continuing, and ending that year.

Pls help...

Thanks in advance.
jan :confused:

View 8 Replies View Related

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

Combo Box Versus List Box?

Sep 9, 2006

This might be a silly question - I appologize in advance if it is. - let me know! :) I have searched a bit and found nothing quite along the same lines.

I have realized that I only use Combo boxes, avoiding List boxes entirely. I had some early difficulties with List Boxes that I can't recall now, yet a lot of my combo boxes are limited to list. Most posts I read on this forum seem to mention Combo rather than List boxes (I may have a bias here?).

It looks like a combo box that is limited to list is pretty much a list box. If this is right, is there ever any advantage to using a list box that I am missing out on?

From Access help:
List boxes: What they are and how they work
In many cases, it's quicker and easier to select a value from a list than to remember a value to type. A list of choices also helps to ensure that the value that's entered in a field is correct.

The list in a list box consists of rows of data. In a form, a list box can have one or more columns, which can appear with or without headings. If a multiple-column list box is bound, Microsoft Access stores the values from one of the columns. In a data access page, a list box has one column without a heading.

You can use an unbound list box to store a value that you can use with another control. For example, you could use an unbound list box to limit the values in another list box or in a custom dialog box. You could also use an unbound list box to find a record based on the value you select in the list box.

On a form, you can use a combo box instead of a list box; it takes up less room, and you can type new values in it, as well as select values from a list. Learn about combo boxes on forms.

On a data access page, you can use a drop-down list box instead of a list box; it takes up less room; however, you can't type new values in it. Learn about drop down list boxes on data access pages.


Combo boxes: What they are and how they work
In many cases, it's quicker and easier to select a value from a list than to remember a value to type. With a combo box, you can do either without using too much space on a form. A combo box is like a text box and a list box combined.

When you enter text or select a value in a combo box, if the combo box is bound, the entered or selected value is inserted into the field that the combo box is bound to.



The list in a combo box consists of rows of data. Rows can have one or more columns, which can appear with or without headings. If a multiple-column combo box is bound, Microsoft Access stores the values from one of the columns.

You can use an unbound combo box to store a value that you can use with another control. For example, you could use an unbound combo box to limit the values in another combo box or in a custom dialog box. You could also use an unbound combo box to find a record based on the value you select in the combo box.

Combo boxes have a LimitToList property that you can use to control whether any value can be entered in the list, or only text that matches one of the values in the list can be entered.

If you have room on your form and you want a list to appear at all times, or if you always want to limit data entries to values in the list, you might want to use a list box instead of a combo box. For more information on list boxes, click .

Is the last para from above:
If you have room on your form and you want a list to appear at all times, or if you always want to limit data entries to values in the list, you might want to use a list box instead of a combo box. For more information on list boxes, click the only advantage?

View 3 Replies View Related

Update Combo List

Sep 26, 2006

ok i have three tables..

Booking_Table
Booking_ID
Job_Date
Company_ID
Booker
Passenger

Company_Table
Company_ID
Company_Name
Address
Phone_No

Company_Staff_Table
Company_Staff_ID
Company_ID
Full_Name
Phone_No


each booking will only ever involve one company at a time

company 'A' will have several staff

person 'A' from company 'A' may book a job for themselves

person 'A' from company 'A' may also book a job for person 'B' from company 'A'


i have created a booking form

i have added a combo list displaying all the company names..(control="comp_combo")

i have also added a combo list displaying all staff names from all companies (control="staff_combo")


when the user selects company 'A' from the first combo.. i would like the staff combo to update and only display staff members for that company

how do i do this.

View 1 Replies View Related

Combo Box Updating A List Box

Dec 8, 2006

Hello,

I'm a beginner in the Access world.. had a two day crash course.

I am trying to populate my list box when I make a select in my combo box.

eg: Combo box-select vendor, which then would populate my Product Name box.

Can someone take a look at this datebase and give me some advice? I don't have a huge understanding of code..so please bare with me.

Thanks
:o

View 5 Replies View Related







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