Forms :: Using Combo Box To Fetch Information On A Form
Aug 13, 2013
I have a form that is used for data entry; from there I want to create a new form where I can select a field from a combo box which would generate the amount associated.
Example on the first form it has a Carpenter that has a calculated output of $1000, on the second form I would want to click on the combo box and pick carpenter and I would like the calculated field to be shown next to it.
I tried making an if statement on an unbound box but I found it difficult
=IIf([Combo2]=Building Service Engineer, =[Forms]![Estimate]![Text787],IIf([Combo2]=Carpenter,
=[Forms]![Estimate]![Text788],IIf([Combo2]=Custodian,
=[Forms]![Estimate]![Text789],IIf([Combo2]=Custodian - Shift Pay (5am - 6am) ,
=[Forms]![Estimate]![Text790],IIf([Combo2]=Drafting Technician,
[Code] ......
[Text787]-[Text805] are fields from the first form, these are calculated fields that multiplies wages quantity etc.
Also [Combo2] wont let me pick any data that I typed in.
View Replies
ADVERTISEMENT
Jun 24, 2013
I have a Columnar Sub form for for a Sales order for capturing the item details.
I have setup a combox for item code for which the respective item description data has to be fetche from item master table and populated in itemdesc table.
I am written a after update code in the combo but after selecting each row the item being fetched and updated in all rows is of the last row.
*********
Private Sub itemcode_AfterUpdate()
Me.itemdesc.Value = DLookup("[Description]", "itemMaster", "[code]='" & [Forms]![frm_invtmpDetails]![itemcode] & "'")
End Sub
*********
View 7 Replies
View Related
Jan 23, 2012
I Created three tables: 1. students, 2. subjects, 3. Marks. The Students table have a unique code for each student, with field name as StudentID, so the Students table contains fields:
a) StudentID a unique code for each student.
FirstName
Address
Phone
b) The Subjects table will have fields:
SubjectID a unique code for each subject.
Subject full title of the subject
c) The Grades table have just three fields:
StudentID a code that ties this entry to a student in the Students table
SubjectID a code that ties this entry to a subject in the Subjects table
Grade the mark this student achieved in this subject.
After creating the three tables, Margaret needs to create a link between them. In Access 2007 and 2010,
Relationships is on the Database Tools ribbon. In Access 95 - 2003, Relationships is on the Tools menu (or the Edit menu in Access 1 -2.) "Grades" will be the "related table" in relationships with both the other tables.
Now I could enter all the students in the Students table, with the unique StudentID for each. I enter all the subjects in the Subjects table, each with a SubjectID. Then at the end of term when the marks are ready, I could enter them in the Grades table.
To enter marks, I created a form, using the "Form/Subform" wizard: "Subjects" is the source for the main form, and "Grades" is the source for the subform. Now with the appropriate subject in the main form, and adds each StudentID and Grade in the subform.
The grades were entered by subject, However to view them by student. I created another form/subform, with the main form reading its data from the Students table, and the subform from the Grades table. Since I used StudentID when entering grades in the previous form, Access linked this code to the one in the new main form, and automatically displays all the subjects and grades for the student in the main form.
Now I would like to create a combo search field in the Header or anywhere in the main form to find the record based on StudentID in the Subform.
View 3 Replies
View Related
Oct 7, 2013
Our software was purchased with a volume license, so I want to make a combo box with all of our volume license purchases and when the person selects the volume license number all of the PCs that have software purchased with that volume license are displayed.Below is my code
Private Sub cboVolumeLicensing_AfterUpdate()
'Moves to Volume Licensing field and
'finds records where "Volume Licensing" matches whatever is selected in the combo box
DoCmd.ShowAllRecords
Me!cboVolumeLicensing.SetFocus
DoCmd.FindRecord Me!cboVolumeLicensing
'Set value of combo box equal to an empty string
End Sub
The Query is Volume License Query and it is composed of Main Table and Volume Licensing Table connected by serial number on the main table and volume license on the volume licensing table..The combo box is volumeLicensing .And the form I am trying to do this in is called Volume License Form
View 2 Replies
View Related
Dec 27, 2013
I have a database I'm creating for DVD/blu-ray sales. I currently have a order system in place in a subform, which uses a combo box to find the customer and fills in all the information in the rest of the subform. One piece of information is the date of sale.
I need to be able to have the ability to change the price of the DVDs and have a history of sales with the right price. The easiest way to do this seemed to be by Date of sale. So the price is linked to the date of sale, when the price changes, all orders before that change use the old price, after use the current price.
I was wondering if there is anyway to have a second subform on the same page and us the date of sale from subform1 and have it display the price in the second subform?
View 7 Replies
View Related
Apr 24, 2013
I have a sales form that contains a combo box lookup to tblCUSTOMERS. It allows me to select a previous customer if that person is already entered into the system. If the person is NOT in the system, a form pops up to add the customer into the table.
What I need to know is, if the person IS already in the table BUT their address etc. has changed, what is the best way to get to that record to edit it? I'm THINKING a button with a command to go to that customer's profile.
What is the code to open a form to the customer selected in the drop down.
the customer name field is CUSTID
View 6 Replies
View Related
Sep 4, 2014
Creating a form against a table with the following fields
EC
Project
Originator
Title
Full description
Effectivity
Etc....
Easy enough to create the Project combo box, problem comes with trying to systematically assign the next EC number.
When I select a Project from a combo box I want an EC assigned with format ECXXXX-### where XXXX is the project number from the combo box and ### is a sequential number. ECs should start at -001 for all projects.
Do I need to add an EC suffix field to hold just the ###? Then what?
View 6 Replies
View Related
Jan 4, 2007
Hi,
I have a form that has several text boxes that correspond to a cell in a row. One of the columns contains just numbers 1-300. Now what I need is a combo box that contains the numbers 1-300 and when one of those numbers is selected I need it to import all the information from the same row into the correct text boxes.
For example when the number 3 is selected it will take the row with the number 3 in it, take all of the cells and import them into the right text box.
Thanks a bunch!
View 5 Replies
View Related
Mar 24, 2014
I have a form which works good enough. In this form, there is a text box that counts and calculates records from a subform. The name of this text box is "text1" ...
Can I fetch this "text1" field in a report ?
View 10 Replies
View Related
Aug 29, 2012
I'm working with Access 2007 and am trying to make a form with multiple tabs that will update when a certain business name is selected in the combo box at the top of the form. I have tried looking up different codes to make the combo box update correctly but can't find anything. Right now I have this code in my After Update:
Private Sub cboBusinessName_AfterUpdate()
On Error GoTo myError
Dim rst As Object
Set rst = Me.RecordsetClone
rst.FindFirst "[GrowerID] = " & Me.cboBusinessName
Me.Bookmark = rst.Bookmark
leave:
If Not rst Is Nothing Then Set rst = Nothing
Exit Sub
myError:
MsgBox "Record Not Found"
Resume leave
End Sub
Here is a picture of the tabs and combo box.
View 3 Replies
View Related
Apr 11, 2013
New to the navigation form: I need several forms in the navigation form to all relate to the same client ID field. I have this information on the main form but the form with in the navigation form will not pick it up.
I have tried =[Forms]![Frm Client Information Navigation Panel]![ClientID] But just cant get it to pick up that information...
I would like to have something like the master link fields and, child link fields but when I add a form to the navigation form this option in not available.
View 1 Replies
View Related
Sep 25, 2013
I have 2 tables
Main table called Site Details
and another table called expense codes
On the form I want to use a combo to look at the expense Number 52, 53, 54 ect
the in the next field to show the description of the code it relates to
How do I do this?
View 1 Replies
View Related
Mar 20, 2014
What I would like to do is create a list box that will only display the information from another form that is related to the current form.So I have a form call Equipment Catalog and that form is related to Equipment features 1 to M relationship and the Equipment Features is related to a Features form M to 1.
So what I want to do is display all the related equipment features in a listbox that is related to the current PK of that form.So if there is only one feature on one form the list box will only display that one item however is there is 6 features on another it will display all 6.I have been trying SQL and Queries but I still can't get it to work.
View 1 Replies
View Related
Feb 3, 2014
I've established a many to many relationship using a junction table.
So I have 3 tables (A for "materials", B for "batches", and J for "junction")
Form A is linked to table A, and contains a subtable linked to a query from table J. This allows me to input materials into table A and then list all of the batches it may be used in that are in table B. I successfully got this to input all the batches and materials combinations in table J.
Now on form B, which is linked to table B, displays the batch information, with the subtable J.
My problem, is that only the materials primary key is showing, not the other information that should be linked from table A.
View 14 Replies
View Related
May 19, 2013
I have a unique "CustomerID" that is an auto number (this is how I link tables, forms, etc.), and "CustomerNumber", "CustomerName", "CustomerSubNumber" that could be null and could have duplicate values.
The first form I have is a Contact Info form where users will enter the contact information such as customer numbers, names, addresses, phone numbers, etc. This then links to an order form. My order form has a place to carry over the "CustomerNumber", "CustomerName", "CustomerSubNumber" values from the ContactInfo table. I would like these fields to automatically populate based on the CustomerID unique number as well as only show the information for that customer ID (including listing out any previous orders).
View 2 Replies
View Related
Jan 30, 2014
I have a database of experimental products. The database allows test technicians to input test information as well as product information (obviously in separate tables). Therefore before a tech logs test information, they have to first make sure the test product is in the database. They can do this by looking up the products that are in the database, and if the current one isn't they can input its information. In the lookup section you can also click on an individual product and lookup its test history.
What I am looking to do is add a button in the product information screen that allows the tech to open the test information input form with the test product information already loaded into the form. The product information portion of the test input form, is two combo boxes, one indicates the test products group and the other is the product number.
Looking up information on Google looks like i might need to use the OpenArgs function, however I have never used that before.
View 3 Replies
View Related
Jul 1, 2014
The database I have created is to produce product description sheets. From the switchboard, the user clicks a button that opens a form on which they can enter about 5 bits of information , then select the product they wish to produce the product sheet for and when they click a button, the product sheet is produced. The product sheet is a report with a subreport. The information entered on the form is included with more information from the database on the main report and the subreport is based on a union query which combines information from 2 tables to list the items included in this product. (the information the user inputs into the form is information that changes depending on the situation and is not stored in the database.
Now comes the next step in this process. Just as the information input into the form is temporary information, there is also one bit of information that needs to be input on a temporary bases for the items that are listed on the subreport. Each of the items on this subreport needs an assignment of AAA or BBB that needs to appear in the subreport on the line with that particular item. There can be one item in an product, or there can be many and the listing of AAA or BBB can be different from one item to the next or they could all be the same. The assignment needs to be made on an item basis.
My thoughts on this were to have a subform appear once the user selects the product on the form which would list all of the items and allow them to select either AAA or BBB in a column on this form. Then when the click to open the report, those assignments would carry through to the report.I have been able to create a continuous form displaying all of the items based on the union query but that's as far as I can get. Not even sure if that is the way to go.
Is there a way to reference the AAA and BBB input on the subform I described so that it displays in the report.
View 7 Replies
View Related
Dec 8, 2014
Trying to pull information from a text box on double click to populate a combobox on another form...
keeps coming up "type mismatch"
I call lngAccount as recognised on mouseover... ("Business Account" is the value I want)
I can't get it to work!
For info, the form I'm calling from is a subform located FrmMainMenu/FrmAccountsMainMenu and the control source is [Account]
the form I wish to populate in on FrmTransactions (it is a main form only) and the combobox is cboaccountselect - **I've seen the obvious mistake with no reference to this whatsoever, corrected it, and still not working**
View 5 Replies
View Related
Jul 6, 2013
I am attempting to create a patient tracking database for a clinic I work in and I am stuck at one small but major part.
I have a parent form called frm_Patient_index. On this form you can enter patient details such as personal details, observations ect. I need to create a lab request form for certain tests to be performed.
I want so that a button on the frm_patient_index form opens a subform where the relevent tests can be requested via tick boxes. Now here is my problem I have managed to create all of that except for the information to be entered into the frm_lab_request automatically and get SAVED to its corresponding table. It will not save for me.
I can get the information such as Badge Number, First Name, Surname and DOB to all enter into the fields automatically but getting them to save to the table is not happening.
View 3 Replies
View Related
Mar 25, 2013
When entering information into a blank form, I would like to be able to continue entering information to another additional blank form after my last entry. Is there a way to continue to a blank form after entering information into the previous blank form? I would just like to continue without having to close the entire form and then reopening another form.
View 7 Replies
View Related
Mar 31, 2014
I have a form that currently uses a "catch all" table for listing available equipment to choose from for an equipment field. I call it tblEquipment. What I want to do is to make it so when I type a name in (1 of 35) in one field of the current record, the record source for the equipment field immediately looks at a different table that has equipment available only for that name. To do this I plan on making 35 different tables with limited data originally found in tblEquipment. I would call these tblEquipment1, tblEquipment2, etc. I do not use a sub form, nor do I want to.
So my questions are:
1) can this be done
2)If it can be done, how can I do it?
View 3 Replies
View Related
Oct 24, 2004
Dear Friends,
I have a query
I want to fetch all the database column name in a table in MS access 2000. Pls can anyone help
View 1 Replies
View Related
Apr 27, 2013
I have a Suppliers database which contains a form that will allow me to place orders with Suppliers.The Main form has a combo box that allows me to select the supplier. The combo box is called SupplierID with the following:
Row source: SELECT Suppliers.SupplierID, Suppliers.CompanyName FROM Suppliers ORDER BY Suppliers.CompanyName;
The subform is called Stock Subform witha combo box called ProductID with the following:
Row source: SELECT DISTINCT Products.ProductID, Products.ProductName, Suppliers.CompanyName, Products.Discontinued FROM Suppliers INNER JOIN Products ON Suppliers.SupplierID=Products.SupplierID WHERE (((Products.Discontinued)=0)) ORDER BY Products.ProductName;
Event Procedure - AfterUpdate: Private Sub ProductID_AfterUpdate()
On Error GoTo Err_ProductID_AfterUpdate
Dim strFilter As String
' Evaluate filter before it's passed to DLookup function.
strFilter = "ProductID = " & Me!ProductID
[code]..
The Link fields are done on the Purchase Order ID (PONoID).What I want to achieve is to select the supplier from the combo box (SupplierID) on the main form and then the combo box (ProductID) on the subform to filter to only show products directly supplied by the Supplier selected on the Main Form.
View 11 Replies
View Related
Mar 6, 2014
I have 2 tables
1. stocklist
2 product details
I created a form called " product details "
Using a combo box in the form "product details" I select a "part number " of which the part number and the associated description of the part comes into a fields called "part number " and "part description "
The part number selected then goes into a table called product details
Is it possible that when I select the part number , both the part number and the part description go into the table called product details.
View 1 Replies
View Related
Oct 28, 2013
I am facing issue with DLOOKUP,
Actually the program flow is like i have a table of 25 fields, ID as PK and item name, item code and remaining is the date as field name,
Below mentioned is the Table headings,
"ID" "Item Name" "Item Code" "10/29/2013" "11/5/2013" "11/12/2013"
Problem is that when im doing dlookup on date getting wrong result...
This is what I am using in my codes.
DLookup("11/12/2013" , "tbl_Name", "ID = " & rs.Fields("TRANSID") & "")
View 4 Replies
View Related
Dec 24, 2013
How can we store the first and last letter of the username using vba.
E.g. my name is "Daniel Rawlings" then it should display "DR".
View 1 Replies
View Related
