Creating A Drop Down Box In A Form

Oct 4, 2006

I am new at access..I am using Access 2003
I have a table with fields for Project #, client, description, etc..

I want a form with a drop down box that shows all of my project #'s when I click on it... I would like to then be able to click on the project number and have all of the information for that record appear..

I have managed to create the form with the drop down box, but when I click on the project number the record information does not change....

Any help would be so much appreciated!!!!
:confused:

View Replies


ADVERTISEMENT

Creating Drop Down Menu In A Form

Aug 6, 2015

In the Lesson 22 tutorial presented here: [URL] .....

They create form where the called Countries toward the end where:

The have a textbox for Government Type. It is a drop down menu of choices that the database creator can choose such a capitalist, socialist, and communist etc.

However, in the form (with the records source as Countries) there is only a space for input no drop down menu. I know this may seem awful elementary to the seasoned database designer, but how does one get it to be a drop down menu?

I have made the input in Countries table to be a look-up which I typed (see above choices) and the is the control source for the Countries Form government type. But there is still no drop down menu with choices on the Countries form. What must I do additionally?

If this is already talked about in one of the MS Access 2010 tutorials earlier lessons then a referral to that source is all that is needed.

View 4 Replies View Related

Forms :: Creating Command Button On Form Containing Drop Down List Of Commands?

Nov 30, 2013

I wish to create a forms that has command button which display a drop down list. The drop down list should contain commands for reports and forms.

Lets assume we have forms named FrmStock, FrmSales and we also have Reports named RptUserLog , RptTurnover.

View 3 Replies View Related

Creating New Ribbon With Drop Down Menu?

Jun 2, 2014

How I can create my own Ribbon which include drop down menus?

View 3 Replies View Related

Creating Dynamic Drop Down List?

Jul 29, 2013

I want to create a drop down list that is dependent on a control button. Drop down menu changes depending on the value entered in another field.

Example:

If ListBox1 = 1

Then ListBox2 drop down menu = a,b,c,d

If ListBox1 = 2

Then ListBox2 drop down menu = x,y,z

If ListBox1 = 3

Then ListBox2 drop down menu = l,m,n,o,p

View 3 Replies View Related

General :: Control Source - Creating Image Based Off Drop Down Result

Feb 3, 2015

I am trying to create a image based off a drop down result. I have had no problem with setting up a image based off a static number. e.g 0456432 in the student id field will bring up students photo in the network share.

What I am having an issue with is the control source will look for a number instead of the name that the drop box displays. this is due to a separate table for the drop box.

what is the expression i need to make in order for the name to appear from the dropbox rather than the source id number?

View 3 Replies View Related

Create A Drop Down List Of Number By Creating A Table And Inserting Combo Box?

Oct 14, 2011

Just fumbling my way around Access 2007, is the only way you can create a drop down list of number by creating a table and inserting a combo box? I am trying to create a list of hours for example:

0.5
1
1.5
2
Etc...

View 1 Replies View Related

Need Help - Creating A "shopping List" From Drop Down Options

Apr 7, 2005

Greetings to all !
Please help if you can.

I am trying to create a form that will allow me to populate a list.
For instance, I could have a drop down box with grocery shopping items in, then by selecting an item and then pressing a button, it would add it to a list I could see on my form. Then I would select another item and add that to my list. Therefore I would be creating a "shopping list" that I could see on my form, from a drop down box on my form.

Please help a foolish old Access user

View 2 Replies View Related

General :: Any Way That Access Could Create A Drop Down Box Within A Drop Down Box?

Jul 24, 2012

Is there anyway that access could create a drop down box within a drop down box? For instance, when a selection is made in a drop down box, it opens another drop down box with choices.And is it possible to link an inserted image from a form to open in MSPaint that when it opens, the image is already there?

View 1 Replies View Related

General :: Drop Down Box Which Effects Another Drop Down Box?

Jun 18, 2013

I have a drop box that has four selections from a table (NORTH, EAST,SOUTH or WEST) I also have a another table that has two fields which is a NAME of a person and either NORTH, EAST,SOUTH,WEST depending on the persons name. What I need to happen (within a form) is that when I select NORTH from a drop down box, I can then select names in another drop down box that correspond to NORTH only. Then only names from the South list if I select SOUTH etc

View 2 Replies View Related

Drop Downs In A Form

May 16, 2006

I am building a customer order database for a client and have this problem: I would like to be able to display a form that shows all a customer's order information ( pretty standard stuff, first name, last name, address, phone, etc.) but then would also like to display what they ordered as a drop down. Many of the customers are repeat customers, and so they will have multiple order records in the datatbase, but I would like to somehow display them in the customer profile form all in one form.

Any help on how to go about this appreicated.

thanks in advance

johnmr

View 2 Replies View Related

FORM HELP!! With Drop Down List

Sep 8, 2006

I'm pretty much a noob to visual basic, I've only taken C++ so I dont really know VB language. ok here is my question... I have a form and I added a drop down list through a table. What I want it to do is output into another text box within the same form when an item in the drop down list is selected. I think I have to make an event procedure for the "On Click" or "On Got Focus" selection. please help me out !!

View 5 Replies View Related

Form Drop Down / Edit Box

Apr 26, 2007

I have a form with a combo box drop down, next to it I have an edit button. If the agent is not in the drop down list, I would like to press the edit button and add a new agent. This works but it does not show up in the list unless I do the edit before I hit the arrow on the drop down box.

I have a macro on the edit button to OpenForm and Requery.

I would like to be able to press the edit button, make the change/addition, when I close this go back to the dropdown and have the new/or changed value seen in the drop down.

Is this possible? If so, how do I make this happen?

View 12 Replies View Related

Drop Down List In A Query Form...

May 31, 2006

I'll admit from the start that I'm a newbie at Access 2003 and I've tried looking in the help file and internet searches. But I've become stumped on how to create what I'm looking for.

I would like to create a form that performs a query that has drop down menus with info from each specific column in a table. That way I don't have to necessarily need to know off the top of my head what data is entered in that column, but can click the drop down menu and get all of the data listed in that particular column. Once have a particular set of info selected, then have a button like "submit" and then the query results appear in a form and click through each page or results.

Is this possible?

View 1 Replies View Related

Drop Down Boxes In Form Linked?

Jan 28, 2005

I have a form ive created as part of my database used for data input.

Someone opens the form , enters their project number, and then enters what country it is in, what region it is in, and what sub region it is in. They are all dropdown menus with the information coming from a table via a lookup wizard.

What i want is when someone choses england in the country field, i want the region field to only displays the regions in england, and then in the sub region field i want only the sub regions that are in the regions displayed in the drop down list.

Anyone know how i can achieve this please?

I have attached a copy of the forms and tables

View 2 Replies View Related

Drag & Drop In Continuous Form

Mar 31, 2005

Hello ppl,

I have a database for selling items.

In my opinion there are actualy 3 solutions to fix this. As i will explain later on.
But first i will try to describe the database first.

there is a reciept part and a "offerte" (<--in dutch) part. I cant remember the word anymore.

Everything is working fine. But i have got just one problem. I have a continuous subform with records in it. When adding records they get added at the end of the record set. Ok fine.... thats still no problem.

But if some item is forgotten. They will need to add it. But it will be added at the end of the list. and for example it needs to be between record 2 and 3.

So this is the problem. Is it posible to have it moved. For example with 2 buttons "Move Up" "Move Down" or drag and drop. I actualy don't care how this will hapen. but the items need to have the posibility to be reordered.

I found a interesting example database. with a listbox with the records in it. and drag and drop possibilities. But i cant figure out how to update this recordset order to the continuous form (it is the same query they pik). Or maybe to send the recordset in the listbox directly to an report would do the job either.

I would appriciate some help here. I am looking for a solution for 2 weeks already. and you ppl are my last hope.

Bye


Lon3,

View 3 Replies View Related

Open A Form From Drop Down Menu

Nov 15, 2006

I have an MS Access problem I need some help with. I am trying open a form for input from selection in a drop down menu in an access database. Any ideas on how I should do this??:confused:

View 3 Replies View Related

Drag And Drop Images Into Form?

Nov 4, 2012

We want a catalog - style report but the boss is going to want drag and drop. The tables are based on a link to an image.

View 7 Replies View Related

Subform Within Form Containing Drop Down List

Apr 5, 2014

I've been trying to create a subform within a form with the subform having a drop down list. Once I have that figured out I will be adding another level (another subform with drop down list within the subform already mentioned).

I am able to create the subform with the form but I'm having trouble with the drop down list. I will explain what I am after with an example.

Form - contains models of vehicles (Jetta, GTI, Golf, Passat, Touareg, Tiguan, etc...)
Subform 1 - contains tranmission type (automatic, manual, tiptronic, paddle)
Subform 2 - contains vehicle color (red, white, black, blue, green)

I would like to use the form described as a way to input all the vehicle variations as they are needed. Then it would be desirable to use that information on an another form.

Another form, an Order form would then use the vehicle variations. The user would select the model of vehicle and in the drop down for transmission type would only see the available selections based based on the variations built above. Likewise, once transmission type is selected, the colors available would be shown in a drop down list, but only the colours available for that particular vehicle and transmission combination.

The above is a simplified example. The real application for this method will be a product line that will contain over 150 styles, with variations in appearance and colour.

View 14 Replies View Related

Hiding Drop Down Arrows In A Printable Form

Aug 23, 2006

Hi

I am compiling a database of my fire system 'engineers reports' by creating a form that is identical to the one that I print and give to the customer.
I used combo boxes to look up system type details, from another table, after inputting the serial number. As these combo boxes can only produce one value I hid the arrows behind background coloured rectangles.

When I print the form the arrows disappear, the combo boxes expand by the width of the arrow and the last 2 digits of right-aligned numbers disappear behind my rectangles.

This form has over 200 controls (systems types, parts used numbers and quantities etc) and I need to print it on a single sheet of paper. I cannot afford to leave extra space between my controls.
The only thing I can think of is setting the visible property of my rectangles to screen only, which is not ideal.

Any suggestions would be greatly appreciated.
Thanks

View 4 Replies View Related

Form / Subform Access Using Drop Down Field

Dec 2, 2004

I have a form and a sub form. How can I create a dropdown/lookup field on the main form, which will find the customer details from the customer table, and then access the correct subform for their spend details?

I hope someone can help. Thanks in advance.

Regards

Peter

View 7 Replies View Related

Forms :: Drop Down Box In A Form To Call A Query

Mar 14, 2013

I want to track which user has which phone and track issues with them.

I have all the relationships set up right.

I have tables:

DeviceStatus - for the drop down box, contains IT Stock, Faulty, With User and Retired
DeviceTypes - Contains model numbers for devices
Assets - Contains a link to DeviceTypes, a link to DeviceStatus and the serial number of a phone.

I have a query:

StockStatus - shows Assets.ID, DeviceStatus.Status, DeviceTypes.description and Assets.SerialNumber

What I want as an end result is a form with a drop down box that shows DeviceStatus.Status (which I have working at the moment) with a go button next to it which will call the query that only shows what was selected in that drop down box.

View 5 Replies View Related

Move Or Copy Email By Drag & Drop On Form

Sep 27, 2006

Hi all,

Is there a way that I can move or copy emails directly from Outlook to a form by using drag & drop?

I know how to do for the files in explorer, but can't figure out how to do from outlook.

Thanks,
Jatz

View 1 Replies View Related

Move Or Copy Email By Drag & Drop On Form

Sep 27, 2006

Hi all,

Is there a way that I can move or copy emails directly from Outlook to a form by using drag & drop?

I know how to do for the files in explorer, but can't figure out how to do from outlook.

Thanks,
Jatz

View 1 Replies View Related

Forms :: Opening New Form With Specific Item In Drop Down Box

May 31, 2013

I have a master form for lack of a better phrase and 3 other forms that represent specific items in the original drop down box. In the master drop down box, I have all 50 states, and the 3 forms are for 3 specific states. Here's the code I have so far but when I save, it says "The 'OpenForm' macro action has an invalid value for the 'Where Condition' agrument."

Option Compare Database
Option Explicit
Private Sub State_AfterUpdate()
Select Case Me.State
Case "CA"
DoCmd.OpenForm "Auditor Form (CA)"

[code]....

View 14 Replies View Related

Forms :: Created A Form That Has A Drop Down Menu To Select A Name

Mar 25, 2015

I created a form that has a drop down menu to select a name. I attempted to set it up so that once a name is selected, another form is opened with that person's information. I was able to get it set up so that the first form closes and the second form comes up, but I can't get it to filter the name. I tried using SetTempVar and then SearchForRecord, but got nothing. I tried using OpenForm and Where Condition equals the search, but just got the automation error. It is currently set up using SetTempVer, OpenForm, SearchForRecord.

View 3 Replies View Related







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