Stop Drop Down From Displaying On A Combo

May 4, 2006

Hi all,

I was wondering if it is possible to prevent the drop down list from displaying on a combo box, and even better, to hide the drop down button. I know this just sounds like using change to and changing the combo to a text. However, as the text box doesn't have the same properties, it won't display the correct information and explaining how the combo box get its information is a little complicated. If there isn't a way, I'll try to explain in a reply. :)

Cheers,

Matt

View Replies


ADVERTISEMENT

Forms :: Displaying Initials In Combo Box When Option Selected From Drop Down

Oct 2, 2013

I have a Combo Box bound which gets its values from a table (T_Users).

The Combo Box displays the Users 'Initials' [Column 1], but the Bound Column [Column 2] is that of the Users 'ID' (which is used when a record is edited or a new record added).

What I want to be able to do is when the user clicks the Combo Box, and the drop down list 'drops down' the options, I want them to not only see the 'Initials' but also selected other columns - BUT - when the option is selected I just want the 'Initials' to be displayed in the Combo Box.

Code:
So, Normal > | ABC |

Dropped Down > | ABC |
--------------------------------------------
| ABC (Annabel Carcus, Big Company Ltd.) |
| JB (Joe Bloggs, Medium Company Ltd.) |
| FS (Fred Smith, Little Company Ltd.) |

Select JB, and > | JB |

View 6 Replies View Related

Forms :: Change ComboBox Drop Down Menu From Displaying Checkboxes For Multiple Values

Oct 14, 2013

I have an issue with a couple of my combo boxes. When in form mode the drop down menu displays a list of options (taken from my source table), this is fine, but the problem is that it allows the user to select more than one of the options in the form of checkboxes. This is not what I intended.

I've attached to pictures to demonstrate the problem. The first is ComboBoxQuery (the one with the problem) and the second is ComboBoxQueryWorkign (the one without a problem).

I'm not sure why this is happening and I've tried comparing all the properties of both these combo boxes and changing some of them to see if I can eliminate the problem without any joy.

I use a very standard SELECT statement to pull the data for the combo box:

SELECT CountryID, CountryName FROM tblCountryInfo ORDER By CountryName

View 7 Replies View Related

Stop Combo Box Refreshing

Oct 6, 2004

I have a form with a combo box on it, used to select staff members.

When I select a staff member it displays a list of tasks assigned to this staff member in a sub-form.

This is all working as I want - however, when another user (on another computer) selects a different staff member from the combo box, after a short time, that second staff member is displayed on my screen and consequently the second users tasks are aslo displayed.

How can I stop this combo box updating every time someone else selects a value?

Thanks,

Brad

View 8 Replies View Related

Combo Boxes Stop Working After Returning To Form

Dec 1, 2005

Hello all,

I have combo boxes populated with all values in a particular field, then shunt the form onto that record (standard combo box for selecting records from a list in other words).

Problem is, these boxes seem to stop working if I leave the form for another and then return to it.

Here's the code Access puts behind:

-----------
Set SerialRS = Me.Recordset.Clone
SerialRS.FindFirst "[Serial Number] = '" & Me![Combo60] & "'"
If Not SerialRS.EOF Then Me.Bookmark = SerialRS.Bookmark
-----------

The form may be opened and closed via other processes (although never unloaded), but when I come back to it these combo boxes always stop working! Why?

View 3 Replies View Related

Combo Box Drop Down

Jul 25, 2005

When I get focus of a combo box I do an automatic dropdown but when I select an item from the list the dropdown doesn't close so it covers my other fields until I click randomly anywhere on the form. How can I get the dropdown to close as soon as I make my selection from the list?
Thanks

View 3 Replies View Related

Auto Drop Down In A Combo Box

Jun 1, 2006

Hi

I remember seeing it. i just don't remember if i need code for this or not. I would like to the combo box to open and show the full menu upon entry.

thanks,

sam

View 2 Replies View Related

How Can You Use Drop Down Combo Box In Forms

Jul 4, 2005

Hi I'm a beginner using access and I was wondering if it's possible to choose a value from a combo box in a form (like a customer #) and when chosen the rest of the fields would get the corresponding values from table CUSTOMER. I have made the customer info a sub-form in my main form called ORDER your help will be greatly appreciated

View 2 Replies View Related

Forms :: Displaying Combo Box Value

Jun 7, 2013

I have a DVD movie table and a lookup table for the movie genre. One selects the movie genre by opening a combo box which has the values. (Movie typeID which is a number and MovieType which is a text.The records are being displayed in a Access 2010 split form with the datasheet on the left. Any editing can be done on the right or the single record side.I would like to only display the genre for that movie as opposed to the combo box which can be edited and next to it have a command button to open a form in order to change or select the genre for the existing or new DVD.So, I guess what I'm asking is how do I display the genre fo that particular movie?

View 6 Replies View Related

Refresh Combo Box (Drop Down List)

May 16, 2007

Hi,

I have a combo box in which it's value changes according to user input. It is working but it is annoying to have to click the combo box for it's list to refresh. How to make it seemless?

Thank you

View 6 Replies View Related

How To Hide The Drop-down Arrow On A Combo Box

Oct 4, 2005

Is there a method you can use to hide the drop-down arrow on a combo box until the combo box is selected?

View 5 Replies View Related

Enabling Drop Down Menu On Combo Box

Jan 26, 2005

Hi all,

This is a simple question i think, but how do i enable my drop down menu to work for a combo box. I have a search query bound to a form and the combo box bound to a field of that query. At present my query just display the first record for any search result from my query on the combo box.

Thanks in advance,

M-.

View 10 Replies View Related

Forms :: Combo Box Drop Down Search

Jun 27, 2013

As an example lets say I have a table listing some cars:

Car Make Car Model
Ford Fiesta
Ford Focus
Ford GT
Mercades C Class
Mercades E Class
Mercades A Class

I am making a form with two combo drop downs with the ability to select car make or model.

Car Model is Unique so if the car model is entered, I will force the car Make into the other combo box

however, If i select "Mercades" for example in the car make, I would like the combo box of Car model to only be filled with the possible models that Mercades make.

Is this possible? (to search for the values available in Car Model based on the value entered in Car Make?)

View 1 Replies View Related

Displaying Records Dependant On Combo Box

Jun 8, 2006

Hi

Any ideas on how to autofill the rest of a form when i select from a combo box?

ie when i choose a name from the list i want the rest of the form to populate with the rest of the data relevant to the selection.

Cheers

View 2 Replies View Related

Displaying Columns In Combo Box Question

Nov 28, 2004

Hi, I have a combo with the following columns listed:

ProjectID
Project Number
Project Name

The width of the bound column (column 1) is 0, and Project Number and Project Name list properly in the combo box. However, on selection, only Project Number (Column 2) jumps into the box. Is there any way of getting the third column (Project Name) to also display after the selection has been made?

Many thanks

View 5 Replies View Related

Forms :: Displaying 2nd Column In A Combo Box

Mar 26, 2013

I've created a form with a combo box to allow users to set the Manager of an employee. I've set the control source for the combo box to the Managers table that contains a primary key and the manager's name.

I've set the bound column to 1, the column count to 2, the column widths to 1;2 (I want to show both columns in the drop down because users can identify managers by either their name or Manager ID).After updating the combo box, the Manager ID shows rather than the Manager Name. Is there a way to have the Manager name show instead of the Manager ID without setting the column widths to 0;2?

View 5 Replies View Related

Forms :: Combo Box With 3 Items Not Displaying

May 7, 2013

I have two synchronised combo boxes that are working brilliantly except for 1 thing.

The two boxes are Site and Building. I find a site from the Site box dropdown and only the buildings for that site are shown in the Buildings box dropdown. Perfect!

However, I have got 3 fields showing in my Buildings dropdown.

Private Sub cboSite_AfterUpdate()
Me.cboBuilding.RowSource = "SELECT BuildingName, BuildingCode, Status FROM " & _
"BuildingT WHERE SiteID = " & _
Me.cboSite & _
" ORDER BY BuildingName"
Me.cboBuilding = Me.cboBuilding.ItemData(0)
End Sub

that is BuildingName, BuildingCode and Status.

All three show in the dropdown
BUT
only BuildingName shows in the actual Building Box and I would like all 3 to be visible once I have decided on the building name I need!!

Can this be done by changing

Me.cboBuilding = Me.cboBuilding.ItemData(0) (as above)
to
Me.cboBuilding = Me.cboBuilding.ItemData(0), Me.cboBuilding.ItemData(1), Me.cboBuilding.ItemData(2)
or something similar??

Or do I need to create 2 new boxes to return the other values?? I am so close to achieving what I want with this form!!

View 3 Replies View Related

Forms :: Align Combo Box Drop Down Text?

Mar 20, 2013

it possible to align the row source values of a combo box? i want to align it to the right instead of the left

View 2 Replies View Related

Forms :: Displaying X Combo Boxes And Positioning Them

Mar 30, 2014

I'm making a database of (electronics) chips in Access 2010. These have varying amounts of pins - 6, 8, 14, 16, 18, 20, 24, 28, 32 or 40.

On a datasheet, they are drawn as per the following image:

[URL]....

As you can see, the pin numbers run down the left hand side, then up the right hand side.

I have a table, tblPinouts. This has a text field called PinoutName and 40 number fields - Pin01 etc. It also has another number field - PinCount.

On a form - frmPinouts - the pin fields will be entered via combo boxes, which get their data from a table - tlkpSignals. However, I want the form to be visual, as per the picture. I've managed to draw a chip using boxes (as this seems preferable to using pictures), like this:

However, I want to adjust the 'drawing' accordingly for each chip. This means doing several things:
Extending the main rectangle downwards
Ensuring there are x small rectangles around the main rectangle at set points
Ensuring there are x labels inside the main rectangle at set points
Ensuring there are x combo boxes around the 'drawing' at set points

How can I ensure that only the first x combo boxes and small rectangles (x=PinCount) are present when a record is loaded, and that they are arranged correctly?

View 6 Replies View Related

Forms :: Cascading Combo Box Not Displaying Properly

Nov 18, 2013

I have a cascading combo box on a work order form that pulls the contacts from the customer selected in the main box.

It's working fine, values are printing fine on the reports, etc. however on the form itself - when you change from one record to another....the value is not displayed even though it's there if you click the report.

View 5 Replies View Related

Displaying Text Field Data For The Corresponding Combo Box Selction.

Nov 29, 2005

I am designing a database for my Bank.
But I have a problem, please give solution If you can help me.

I have a Table name "BranchName",purpose for entering Branches of Bank.
Fields are as below.
SrNo. (Auto Number)
BrName (Text)
BrCode (Number)
Region (Text)

Now I had made a Form "Branch".
On this there is one Combo box in which all "BrName" are shown.I made that.
Now I made another Text Field where I want to show the corresponding "Region" automatically appears for the selected "BrName" .

Now how I make this.Any Query or Code Builder Event ??????

View 1 Replies View Related

Forms :: Multiple Column Combo Box - Displaying Values?

Mar 4, 2015

I have a multiple column combo box on my form, that is correctly populating. When I make a selection, it displays the result from the first column. Bound column seems correct, as my table is being populated correctly.

1 - Can I display the values from both columns after the selection has been made?

2 - If not, can I choose to display the second column (not the first) after the user has made a selection?

View 3 Replies View Related

Forms :: How To Filter Reports By Date Types In A Drop Down Or Combo Box

Jun 26, 2013

filter reports by specific date types in a drop down or combo box I would like the dates to be

Today
Tomorrow
The next 3 days and the next 7 days

i don't want a date picker or between dates I have tried searching but cannot seem to find an answer They are for my engineers, they want to know what callouts they have today or tomorrow or the next 3 days or this week.

View 3 Replies View Related

Displaying Data From Combo And Text Boxes In A Single List

Feb 6, 2005

I have several combo boxes and textboxes showing quanity,productname,
size, and price. How can I pass all of this info in a single row that also calculates
the quanity and price. Also, multiple selections can be added, so several items can
can added in other rows. THe ability to cancel each row would be required as well.
Thanks

View 2 Replies View Related

General :: Access 2010 / Combo Box Not Displaying The Correct Item?

Apr 28, 2013

Using ms access 2010, I created a table called all items contains the ID, item name, item code, item price.

Second table I created called orders, contains item1,Q1=quantity,Tot1=calculated field.

Then a form to fill the orders table with a combo box for Q1 (gets the value from a table called numbers), second combo box for item1 (gets the value item code and item price from the table all items), and a text box to calculate the total of the Q1-item1(item price) All working perfect except the combo box for item1 ends up displaying a different item code that's only if the items were at the same price, for example, I choose latte from the combo box gives me correct item price but the code is cappuccino, only happening with items with the same price.

If I set the property of the combo box Bound Column to 1, I get correct item code but calculation error, Bound Column to 2, I get correct calculations but wrong item code. how to get the combo box to display the correct item code?

View 1 Replies View Related

Ignoring Duplicates In Table Field Values That Is For A Combo Box Drop Down List

Apr 13, 2014

I'm trying to create a combo box that takes its values from a field in a table, the thing is that this field has duplicates because:

* The table is a qualification look up table
* It has 3 fields: QualificationID (autonumber), Qualification(e.g. Bachelor), Programme (e.g. Science)
* E.g of duplicate values (this is not a problem as it is necessary) Bachelor of Science, Diploma of Science, Certificate of Science

What I'm trying to do is create 2 single-columned combo boxes that are a parameter for a query and it's working except the combo boxes show duplicated valuesIs there a way to get the query that is the row source for the combo box to eliminate duplicates?

View 2 Replies View Related







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