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 Replies


ADVERTISEMENT

Forms :: Using One Dropdown List Box To Display A Selecting In Another Dropdown List Box?

Aug 4, 2014

I have a form where I have two drop down list box.The first list box is called Transaction_Type. It contains three values: Created, Allocated and Sold

The second list box is called Product_Status. It contains 6 items: Allocated, Produced, Reworked, Shipped, To Be Produced, Unallocated.

I have a products form. When a user created more inventory they will selected in the drop down list create, then a quantity. Then I would like the status of the product to update to "Unallocated".

When the user placed an order but doesn't finish it they will choose the status of the inventory to be allocated so I would like the product status to be updated to allocated automatically.

They other status the user will choose them self and do not need to be linked to each other.

In my vba code I have tried with the OnClick and AfterUpdate sub procedures with the following code.

If Me.Transaction_Type.Value = "Created" Then
Me.Product_Status.Value = "Unallocated"
End If
If Me.Transaction_Type.Value = "Allocated" Then
Me.Product_Status.Value = "Allocated"
End If

Yes when i select "created" from the drop down list it does not change product_status to say "unallocated"

(in using access 2007)

View 14 Replies View Related

Display Specific Records In A Subform Using A Dropdown List

Apr 12, 2005

Hi to all,
I developed a database where I keep all the problems that I face and their solutions along with its category.

Now I want to have a form that when I choose each category, I should have all its records.

I heard that I should implement this by using a subform but I couldn't manage. With a search at the topics I've seen that I should use a macro but I don't know how to implement it.

Possibly after the lookup field I should have an After Update function but how can I connect it with the subform?

ex. at category "hardware: floppy" i have 2 records and i want to see only these, and when i choose category "hardware: hard disk" to have other 5 records of that category

Help plz?

View 9 Replies View Related

General :: Dropdown List Dependent On Another Dropdown List

Jun 11, 2012

I must create a database for the company that I work for that covers the maintenance history of our stone crusher plant. In this database I have two dropdown lists. The first one is for the equipment and the second one is for the different types of parts that has to be replaced or fixed.

Not all of the equipment uses all of the listed parts, but some parts are used on more than one type of equipment.

I have already created a database that lists all the equipment and another one that lists all the parts.

What I want to do now is create a Yes/No box for each type of equipment so I can mark which parts is used by which equipment.

Then you must be able to select the type of equipment from a dropdown list and then select from a dropdown list that only has the parts that is used by the piece of equipment.

I am using Access 2007

View 4 Replies View Related

Forms :: Click Button To Open Dropdown To Open Record The Filters By Dropdown

Jul 28, 2014

I currently have a button that opens a report. the report pulls from a query that has parameters set to "fromdate" and "todate". instead of using dates and parameters that pop up as blank text boxes, I would like to click the button, have a form pop up with a combo box to select all of the options available (currently 23 options) and then click a button to make a report that only displays the record (1-23) selected. I do not need any time constraints because as the databases get updated with more records, there would be more than 23 options to choose from.

View 1 Replies View Related

Forms :: Combo Box - Can Auto Dropdown To A Specific Row From Hidden ID

Apr 23, 2013

I have a combo box that I normally type the start of a Surname and it auto drops down from underlying database ID is now show in col count, only 1st two.

Surname Name ID
jones/k kelly 33333
smith/m max 12345
smith/m monty 98765
white/t tom 55555

smith/m will short list to the two above, I can mouse click or arrow down to the 2nd one Press enter & its knowa the corresponding ID (= surname.Column(2)) and goes to the correct record.

What I am trying to do, is from another part of my program, eg an incoming email with the corresponding Surname, Name & ID Automatically go to this main booking form, auto enter surname "smith/m" - which is fine, the list shortens but It goes to the first matching on the list, ie max.

Is there a way to get it to go to monty using the ID 98765 which is unique.

Perhaps an odd request but actually nice to book each time through this same main form, I actually also want it to do the same from incoming phone calls, It can get the unique ID ok but can see a way for the combo box to jump to the correct & only row from underlying register.

Bit worried about trying to change the underlying select statement that the combo seems to be based on, perhaps this is the way forward but not sure how to do this & don;t want to risk messing the most important & already functioning well normal entry style.

View 1 Replies View Related

Can Limit A Specific Value From Lookup Field To Only ONE Record At A Time?

Aug 2, 2012

Any way I can set a table up with an intrinsic limit, specifically that only ONE record at a time (this will vary) can possibly have value X selected from a lookup field containing assigned values X, Y and Z. Is this possible? If so, how do I do this?

View 2 Replies View Related

Dropdown List Boxes In Forms

Feb 8, 2005

I am trying to put a DROPDOWN LIST BOX in a access 2003 form, NOT a combo box. I only need this so I can disallow users from manually entering data into the combo box by typing it in. I want them only to be able to choose it from a list. I think that a LISTBOX is the only way to do this, other that using a straight list box, which would use too much room. However I cannot find any way to add this to a form. Any thoughts?

Thanks,
Todd

View 1 Replies View Related

Forms :: Setting Default Value In Dropdown List

Apr 11, 2015

I have a drop-down list that when a person's first name is selected then it will fill in the person's middle and last name. Is it possible to use a name that is frequently used as the default so that it is always filled in on the form? More specifically, how will it work so that the other fields (middle name and last name) will also be filled in with the default first name? Or is this not possible to do?

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

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

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 :: Update Dropdown Box For Current Record Set?

Jan 23, 2014

i have a database

two tables: Addresses, Instructions
One form_one subform: User form

The user form contains set of instructions for each company that we take care off, the sub-form has all of the addresses for the company, these come from the "Address" table, the two are linked via a field called "companyID" so the subform only displays the addresses for the current company being viewed on the form.

The problem is, on the subform there is a dropdown box called "administrator" and this is used to select the person who is looking after the company. Some of the companies have hundreds of addresses, so when i click the next record button on the subform I have to fill in the administrator again for every address for the same company. Is there a way using vba or a simple function to auto update all of the "administrator" dropdown boxes for that company based on the administrator I select for the first address.

ps access 2010

View 5 Replies View Related

Forms :: How To Hyperlink From Query To Specific Record In A Specific Form

Jul 23, 2013

I want to hyperlink from a query direct to the relevant record in a specific form. I have a hyperlink field in the form which shows up in the query. When clicked in the query, this hyperlinks to the form but I cannot make it select the correct record in the form.How do I get it to select the correct record?

View 3 Replies View Related

Forms :: Data From Multiple Fields In Same Record In Combo Box Dropdown

Mar 12, 2013

Access 2010

I have a form bound to a table which has 20 (name)fields and 1 date per record. A user fills in this form first to indicate which people are present this day. I know it would be better to use 1 name per record but that would in this case not work since the form must show all names for that day before saving and closing.

I have a different form where I use 4 combo boxes and a date field. The values that can be selected in the combo boxes should come from the 20 names on the first form and with the same date as the other form. So only 4 people of the 20 indicated as present on that day can be selected to have performed some task.

I know how to select with a combo box from different records, but how would I do it from different fields in the same record? And then also for a particular date?

View 1 Replies View Related

Dropdown List

Jan 23, 2006

Hi all,

I am very new to Microsoft Access, and hope somebody can help me. Apologies for what I am sure is an easy subject - but I dont know what keywords to search on!

Basically, I need to have a drop list of say 5 different products. Now depending on the product will lead to different field boxes (say each product has 15 fields, 10 which are the same, but 5 which are unique to each product). I basically want the form to change dependent upon the product type. As I say I am very sketchy on this, so feel free to treat my like an idiot! If anyone could give me a hint as to what help topic this relates to, or give me a brief overview of what to do, that would be very much appreciated. The information will be downloaded from an ODBC if that makes any difference.

Many thanks in advance

Mike

View 2 Replies View Related

Dropdown List

Dec 3, 2006

Hi,

I create a dropdown list, which has 3 columns with column heads.

Can we set Bold format on the column heads?

Thanks.

View 1 Replies View Related

Dropdown List

Jun 26, 2007

Hi,

I want to create the dropdown list on the form, the dropdownlist will have 5 values, I want to give out description of each value when the user move the mouse on the value. Does the dropdownlist control have this option?

View 1 Replies View Related

Forms :: Copy Specific Fields From Selected Record To Specific Fields In Subform?

Jul 9, 2015

I am new to access i have a problem which is i have made a form which contains a subform and a read only subreport, what i want is the ability to select a record in read only subreport as in the picture attached and make a button that when i press on it, it should copy the values of the itemsID field, Packing field, ContainerNo field and origin field from the selected record and then paste them in the subform below.

Also i want to add more then one item, so the when i press on another record it should paste the values below the first record.

View 12 Replies View Related

Getting Values Related To Dropdown List?

Feb 7, 2007

Hi!
I have a tables.
One is called: products => prdouctID,productName, ProductPrice

I created a dropdown list.
To read in the values of productName.

I wanted to have a textbox / label which will update the productPrice.
If i select productName as "Pirates", the textbox/label will show $50.00
If i select productName as "Who let them out?", the textbox/label will show $80.00

I have managed to do the dropdown list but cant seem to figure out the label / textbox.

Please advice?
Cheers!
Darence

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

Using A Dropdown List To Change Criteria

May 5, 2006

Good afternoon,

I need to use a selection from a drop down list to change the criteria in a query as opposed to typing text in a parameter box. This is to allow the user to choose from a list and then click on a command button to move to the next query. There are 20,000 records in the table. The series of queries will take the user to 1 or 2 records in 3 or 4 mouse clicks.

Thanks

View 2 Replies View Related

General :: Combo Box Dropdown List

Nov 15, 2012

With Access 2000, for the On Focus event, typing Me!MyCombobox.Dropdown displays the entries in the drop down list. With 2007 the list appears momentarily and then disappears. Is there a way to keep the list from disappearing

View 7 Replies View Related

Select Multiple Items From Dropdown List

Mar 24, 2006

Hi,

I would like to be able to select multiple items from a dropdown list like we often see on web forms. The kind where you hold down the control key to select up to 5 items. Is this possible on an access form? If so, how would do we implement, and how is such data be stored?

Thanks!
~Bruce

View 12 Replies View Related

How To Create A Table That Change According To Dropdown List

Oct 11, 2011

Refer to the image below:

I want to make a form with the following criteria:-

Has one dropdown list. (like in the picture) Has one table. (like in the picture) When I select an item (for example: Syarikat A Sdn. Bhd.), the table below it (yellow circled), will automatically change data according to the corresponding selected list so that user can edit/add/delete the data in the table.

The issue: I already made the dropdown list and table, but how can I make the number 3 condition.

View 2 Replies View Related

Data Access Page Dropdown List Blank?

Sep 27, 2006

I have a DAP that many users have access to.When opened the Dropdown is blank on some peoples and populated on others. Is there some setting that can cause this. I have checked to make sure that they have the allow ActiveX Controls to run files on this computer checked. Any other setting that may cause this? Thanks.

View 4 Replies View Related







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