Forms :: Populate Combo2 While Combo1 Is Selected With Any Value
Apr 17, 2013
I have two comboboxes in access form. what i want is if i select "A" from combo1, I want to have one value to combo2 could it be "x" or "y" or "z" but of my choice.. After combo1 is selected "A", I want automatically pop, lets say, "y" or any value i want may be "z" at combo2 of the form. Combo2 also has list of values (x,y,z) fetched from table.
Please note that both combos are fetched from tables that contains two columns (ID, name) and combos are fetched by binding first column and assigned column count 2; so that it shows the values rather than numbers. Moreover, the combos are allowed to store multiple values (defined in master table).
View Replies
ADVERTISEMENT
Jul 15, 2013
I'm using a sub form to display data form a table. The users wanted it display like a spread sheet. In order to get all the data to display on the same page I am trying to break some of the longer feilds out (i.e. comment field) and display them in a list/text box and not in the table with the smaller fields.
Basically what will happen is when a record is selected in the sub form the comment field tied to each record will be displayed below. I've tried a few things but I keep getting errors displayed in my list/text box (#Name?)
View 14 Replies
View Related
Mar 12, 2013
I have built a form that holds details of training records. What I want is when a drop down is selected in the main form, that it will populate some of the fields in the subform. I have this working at the moment, that for example, when a certain course is selected, that their modules will appear in the subform. Where my problem arises is that I have a relationship between two tables that I want to appear on the subform, so that details can be filled in on the subform against the list of modules that automatically appear.
View 2 Replies
View Related
Aug 5, 2013
I have several comboboxes (6) on my form.How to populate these comboboxes with values depending on selected value in previous combobox.
Example.Lets say that you select value "Audi" in combobox 1, then available values in combobox 2 should be "A4","A6","TT" etc. and if you selected "BMW" in combobox 1, then available values in combobox 2 should be "3-series", "5-series" etc...
View 1 Replies
View Related
Jan 23, 2014
I have been tasked with creating a databse that contains multiple test records. Within a single test record, there is a field named 'bits' in which there are 10 different bits (0 - 9) each with a different value and description. I would like to set up the database such that a user can view a single test record and select a particular bit field from a drop down box and when the bit is selected, the descriptive information for that particular bit is automatically displayed to the user.
For example:
- User selects 'test record A'.
- Within 'test record A' there is a 'bits' dropdown box.
- From the 'bits' dropdown box, the user selects bit '0'.
- When bit '0' is selected, another field named 'bit description' automatically fills in the bit description for bit '0'.
View 1 Replies
View Related
Oct 28, 2005
hi
when a value is selected in a combo box then values shud be set to the textboxes in the same form
plz let me know hw to do it.
Please reply ASAP
thnx
View 2 Replies
View Related
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
Dec 11, 2013
Any way to have a column in a table that can generate how many times a particular row has been selected yes active (yes/no data type) .
Example.
*Row*
1. Yes
2. No
3. Yes
4. Yes
5. Yes
6. Yes
7. Yes
8. No
The column would report
1. 1
2. 0
3. 1
4. 1
5. 1
6. 1
7. 1
8. 0
The next week I come and change the data to
1. No
2. Yes
3. Yes
4. No
5. No
6. Yes
7. Yes
8. No
The column would update to report (original + new active status)
1. 1
2. 1
3. 2
4. 1
5. 1
6. 2
7. 1
8. 0
View 5 Replies
View Related
Aug 14, 2015
List box named: lstEvents
and 2 forms
Main 1: frmEvents
2nd 1: frmEventsEdit1
I have the codeing from here URL....Now, the problem im having is, that for the shows I have this code:
Code:
ShowNames: ([ShowName] & " " & Format([StartDate],"mm-yyyy"))
That is so that each show has the month and year attached to the name, so its easier to find out when they were, from just looking at them in the list box.But, if I use the search that John (The OP of that link) then if I were to search for 2015, and try to open a show, it just opens to a blank frmEventsEdit1. Even though I currently just tell it:
Code:
DoCmd.OpenForm "frmEventsEdit1", , , "EventID = " & Me.lstShows
I would like two things.Either, to figure out why that isn't working, or 2, to get this If sentence im working on that goes like this:
Code:
If "EventID" = " " Then MsgBox "Error, please try again" Else DoCmd.OpenForm "frmEventsEdit1", , , "EventID = " & Me.lstShows
View 13 Replies
View Related
Feb 12, 2006
Dear All
I have a form with memo field as [acLetter]. Now whenever I open the form the text in the memo forms are all selected/highlighted in all the records. Is there any settings required to disable this feature or have I missed out something, so that the text should not be selected at the time of opening the form.
Thanks
View 1 Replies
View Related
Nov 1, 2014
i have 2 tables (clients, frequencies) where in table "clients" i have a column to store ID of "frequencies" table (id, description).
in my form "FClient" i display data stored in table "clients" and i have a combobox that should display the "frequencies" descriptions, but with a frequency selected by default...in fact the one that has its ID stored in table "clients". i'm able to display all frequencies descriptions but i don't know how to easily select and then display, as default, the frequency stored in table "client"
View 3 Replies
View Related
Dec 16, 2013
Move Selected Items Between Listbox1 (listEmp) and listbox2 (listAllocated). the items moved from listEmp must be removed from listEmp when moved to list allocated and vice versa.
Overview:
listEmp is my first listbox and currently has the query in it's rowsource
SELECT e.* FROM qryEmp AS e;
it has 7 columns but only 6 are showing (Column 1 is hidden)
and it is currently bound to 1
listAllocated has only 4 columns (can be changed) i only need the first 4 columns from the first list.
currently it has no row source and the row source type is set to Value
it is also bound to 1
I did find some code that does not do what I need but is closer than anything that I have found so far. It seems like it is copying the Selected Items from Column 1 and pasting it in the second listbox. but it is pasting them all in a row and not in individual columns below is the code. I will post a screen shot in 2 posts time.
Code:
Private Sub cmdCopyItem_Click()
CopySelected Me
End Sub
[Code].....
View 7 Replies
View Related
Apr 22, 2014
I want make a date control compulsory if a value is selected from a combo list on the same form.
I have Combo List, status, which can be 25%, 50%, 75%, WON or Lost. If the value is WON or LOST I want the date control, Date Project Closed, to be compulsory. I cant set it to insert today's date as it may have been closed up to a week before.
If 25%, 50% or 75% are selected then the date should not be compulsory.
View 9 Replies
View Related
Mar 7, 2013
Access 2010
I have a bound form (splitform view) with the code
"DoCmd.GoToRecord , , acLast"
on the Form_Open event. When I open the form it does go to the last record and shows all the data that are in (some of the) fields. I cannot however manipulate the record until I click on the navigation buttons in the bottom of the form. It also doesn't show which record ("34 of 34" for example) is selected.
How I can get it to open the last record and let me manipulate it directly on open?
View 4 Replies
View Related
Mar 11, 2014
I have a form (PostProductionForm) which is used to input data about finished goods which come off a production line. There are three possible outcomes which can occur after the production: Passed, Reprocessed, Failed and the numbers for these are entered in 3 text boxes on the form (QtyReprocessedTxt, QtyFailedTxt, QtyPassedTxt).
These text boxes are auto populated with a 0 from the table (PostProductionTbl) so there aren't blanks.
What I am trying to do is use an IF function (I think) which says that if Quantity Reprocessed is equal to zero when the submit button is pressed, the "Reason for reprocessing" combo (RPReasonCombo) must have something selected (i.e. can't be blank) or it won't go to a new record.
View 5 Replies
View Related
Jun 29, 2015
I've got a form with a drop down combo box with two columns. When you hit the down arrow it shows both columns, but when you click a choice, it only shows the data in the first column. How do I make it show both columns after it has been chosen? First col is First Name, second col is Last Name.
View 3 Replies
View Related
Dec 22, 2014
I would like to export selected records (from list box) to .xls file, also populate the same value to all selected records. The value will be entered on the form once.
I'm attaching a small sample DB, so you can see what I have so far.
The Export function, or the update record functions.
View 8 Replies
View Related
Feb 6, 2014
I'm new to access and am currently building a simple db customers table and jobs table, I have a setup a relationship between the 2 and have the jobs bt las a sub form of the customer, but only showing a small amount of the job data.
What I would like to do is be able to click on a specific job within the job subform and navigate to that record in the job form where I can see all the data about that job.
View 4 Replies
View Related
Mar 30, 2015
How can I remove an item after being selected from a combobox ?
View 2 Replies
View Related
Nov 11, 2014
I have an unbound listbox with 3 columns. Call it PeopleBx. How can I address the item in the first row and first column. How can I address the first column in the selected row and how can I address the item in row 3 and column 2. I tried with
Code:
Me.PeopleBx.Selected
and other possible variations but failed.
View 9 Replies
View Related
Dec 11, 2013
I have 2 Listboxes the first list is based on a query I need to select items from this box or part of each item and move to another listbox. the items in the second listbox will be used in a report. I have previously posted on another forum with no real luck fyi. the query is put straight in the RowSource.
View 3 Replies
View Related
Mar 20, 2014
I am putting together a simple database to do with monitoring maintenace of buildings. I was the building number to automatcially populate when the building name is select.
I have got the the point where I have building name and number in the building name combo box but i'm stuck with the after update code builer part.
I currently have:
Me.Building_NameControl = Me.Building_Number.Column(2)
But doesn't seem to work.I don't really understand syntax!
View 12 Replies
View Related
Jan 16, 2014
i have employee form to insert employee information one of its text box on click another form open of schools name where i can select the school work how can i pass selected school name to the main form
View 2 Replies
View Related
Feb 16, 2015
I have over 100 queries of weather data, for each month, and would like to display certain or filtered information for a selected month.
I have been playing around with a combo box to select a month from a given year, and was hoping that maybe an 'After Update' would do what I want. The problem I have is that I don't know how to do this, as the month picked and displayed in the combo box is variable , and so a sort of wildcard might do the job, if I knew how.
View 14 Replies
View Related
Aug 8, 2013
I'm developing a database where people basically can fill in an order form and then the database can track if the order has been placed, when it came in etc.I have a form called frm_Suppliers to be Ordered that runs off a query. The tables that relate to the query are called tbl_Products, with a primary key called ID and tbl_Suppliers, with a primary key called Supplier ID.
The form called frm_Suppliers to be Ordered, shows a list of suppliers that have open orders. Each supplier may have several orders open. I want to be able to click a button after each supplier name and bring up a continuous form that relates to all the records from that supplier that have open orders.
I have tried using the code found in the thread called "open a form based on the record that is selected in current form" from 06-08-2011, however it will only work when my form lists each open order separately, not when they are grouped by supplier.
View 2 Replies
View Related
Jul 24, 2013
How do I remove multiple selected items from listbox.
Noticed it is a table/query listbox, not value list.
Remove selected.zip
View 1 Replies
View Related
