Populate Table With Input From Form With Combo Box (multiple Fields)

Feb 21, 2011

I am using Access 2007 and have reviewed many blogs and looked at the Northwind db to try to solve this problem. I would like to create a form that functions in the same manner as the "Order Details" form in the Northwind db. Specifically, I want to create a form that will allow me to input a value and have the form get data from another table and populate the table I need populated.

I would like to populate a table "Outside", field names are Key, Name, term, Value, Date.

The table that contains the data is named "CV" and the filed names are Key, Name.

In the form, I would like to enter a value for Key into a combo box, and have it put the value for Key and for Name into the form, and allow me to enter whatever I want to in the Term, Value and Date field. When I tab out, I would like all this data to be in the table "Outside.

View Replies


ADVERTISEMENT

Forms :: Create A Form Using Combo Box To Populate Multiple Fields And Tables?

May 26, 2013

I'm trying to create a form using a combo box to populate multiple fields and tables.

I've created a text field to display the added information using this format:

=Comboboxname.Column(x)

in the text box control source field, and this works for display purposes.However, I need it to populate this data into a field on a table.

For example:

My combo box looks up data that has 2 columns, Part Number and Description.

The control source for the combo box is "Part Number". And that populates the part number in the "Main" table no problem.

The text box I created using the above format in the control source populates the field in the form, but not the "Main" table.

Is there a way for the other (description) field to also populate the "Main" table as well?

View 5 Replies View Related

Populate Form Fields From A Combo

Jul 30, 2005

Trying to update fields (bound) on a form (built using the wizard) from value selected in a combo box. I can get this to work with unbound text boxes using an After Update event handler and a code query along the lines of:

Me!TxtJobCode1 = Me!CboJobDesc.Column(1)

But this doesn't work where the form field is bound to a table.

So qu is - how do I achieve the same result using table fields instead of text boxes?

I could use text boxes but not sure then how I can save that data as a record in the table if it is not bound to fields.

Any help appreciated

Andy

View 1 Replies View Related

Code To Populate Multiple Fields In One Sub Form From Another

Sep 6, 2006

I am looking to add multiple lines of record to a sub-form via a module activated from another linked sub-form.
As an example of what I want to do:
On identifying a particular type of vehicle servicing (e.g. 6000 mile service, 12000 mile service) on a service event sub-form of a vehicle form, I want to enter a list of required parts (e.g. oil filter, oil, etc) on another sub-form called "parts", that I can then edit before recording in an underlying table.
Can anyone help.
Thanks
Steve
:confused:

View 1 Replies View Related

Using A Table To Populate 3 Form Fields

Mar 17, 2006

Hi

I have a form with 3 combo boxes part No, Description, Cost. I have created a table with this information in I want to be able to select the information from either one of the three drop down boxes and the other two to automatically collect the information from the other colums of the table. Can anyone help please?

View 2 Replies View Related

Forms :: Populate Control In A Form Based Off Of Two Different Fields In One Table

Jun 24, 2013

I am wanting to populate a control in a form based off of two different fields in one table. Is that possible?I have a table called tblEmployeeMaster and it has a LastName column and a FirstName column in which I need to have both first and last name show up in one box on my form?

View 6 Replies View Related

Queries :: Populate Form Fields With Records From A Table Bound To Recordsource

Feb 5, 2014

I would like to populate form fields with records from a table/query so that they are bound to the recordsource and the record to be displayed can be selected from a combobox. I am hoping that in this way, any changes made are propagated to the original table.

I have created a combobox from which the primary key can be selected and added all the fields from the table appearing on this form as values.

In my Change event for the combobox I have this code:

Private Sub cboID_Change()
Me.RecordSource = "SELECT b01_Participants.*FROM b01_Participants WHERE (((b01_Participants.ParticipantID)= " & cboID.Column(1) & "));"
Me.Refresh
End Sub

However, I receive an 3075 error when this code runs which seems to relate to my syntax or an extra ")".

View 14 Replies View Related

Populate 3 Fields From One Combo Box

Mar 27, 2006

I have a combo box on a form that shows 3 columbs from tblparts in the drop down, I wish to select one row from the drop down, that will enter the selected data in three fields on the form.

For example my form has three fields "part code", "Description", "cost".

Part Code = combo box
Description = Text Box
Cost = Text box

I want to select the data from the combo drop down to populate all three boxes.

Can sombody please help, as I have been stuck on this all afternoon. Cheers

View 2 Replies View Related

General :: Dynamically Search Multiple Fields From Combo Box On Form

Mar 21, 2013

[URL] ....I am trying to dynamically search multiple fields from a combo box on a form that includes a subform. I am using code from the above referenced link within this forum.

It works without the "setFocus" for the Listbox except it jumps to a record after the very first character is entered instead of narrowing down as characters are typed. If I leave in the "setFocus" I get run-time error 2110.

View 14 Replies View Related

Auto Populate Fields Based On Combo Box Selection

Jan 23, 2013

I have three tables with the following columns:

MoldReq
Mold_NoPart_NamePart_NoMaterialDateWork_Ord(Pri Key)
MoldLog
Log_IDMold_No(Pri Key)Part_NameLog_DateTime_InTime_OutHours
Molds
Mold_No(Pri Key)Part_NamePart_No

I am trying to build a form in the MoldReq section so when the user selects the mold number(combo box) it will auto populate the Part_Name and Part_No fields by pulling the data from the Molds table.

I have tried following this video where I create a change event:

Code:
Private Sub cboCombo31_Change()
Me.txtPart_Name.Value = Me.cboMold_No.Column(3)
Me.txtPart_No.Value = Me.cboMold_No.Column(4)
End Sub

View 14 Replies View Related

Forms :: Unbound Combo Box Populate Fields Linked Tables

Jul 18, 2014

I have form with an unbound combo box which is populated from a query

It should populate a field in a table which is related to another - however it only works when i query by id number (primary key) and not the text value i want - is it possible to query both so it returns say 1,option 1 - then when selected it will place a 1 in the table - which is related to option 1 in another table instead of just having to select '1' which will mean nothing to a user?

View 5 Replies View Related

Modules & VBA :: Make Selection From A Combo Box Populate That Number Of Metals Fields?

May 27, 2015

My database will be creating quotes based on employees entries. Each quote will be unique because of the part. Each part has the potential to have Precious Metals, and Base Metals included. The employee must select the number Precious Metals and Base Metals that a particular part has. The problem lies with what happens after this selection is made. There are three fields that need to be defined pertaining to each metal. I need the number selected to determine how many fields to make available. If there are two precious metals, I need to make the three fields available twice; one for both metals. I have the possibility for up to 5 Precious Metals and 10 Base Metals per part. How can I make the selection from a combo box populate that number of Metals Fields?

View 14 Replies View Related

One Table, One Form, Multiple Fields

Feb 9, 2006

Hello everyone,

I was working on a database several months ago and I came across this forum while troubleshooting. I had to abandon the incomplete project for some time now, but I am back and ready to get this thing up and running!

My database used to be comprised of lookup tables and other things for each of the fields in my main table, but I have recently scratched that idea for simply using list boxes.

My main problem, I believe, is with my form. I am trying to have two combo boxes, a beginning date and end date, and a keyword text box, all used as criteria in a query.

Seems pretty simple, and I actually got the keyword text box to work, but the combo boxes and between dates critiria return all records.

Can someone double-check my work? I'm sure it's just a simple error, but I will attach a stripped-down database for anyone to look through.

Thanks ahead of time for anyones help, it is greatly appreciated!

View 3 Replies View Related

Summing Multiple Fields From One Table In A Form

Apr 1, 2014

[AR&R Hours]+[PTO # of Hours]+[Meeting/Calls # of Hours]+[System Issues # of Hours]+[BAU Training # of Hours]+[Exception Processing Hours]+[AIG Related Activities]+[Admin Work Hours]+[Migration Hours]+[Project Hours]

Need the fastest and easiest way to auto calculate the above in a field on a form. i can get it to calculate in a query but need it to do in the form as well.

View 14 Replies View Related

Search Multiple Text Fields In A Table From A Form

Aug 8, 2006

Please bare with me as I am an Absolute Access VB code novice . I have a Form in my Access DB and I found the Following code on this site and placed it behind my search button :

Private Sub SearchButton_Click()
DoCmd.OpenReport "All users", acViewPreview, , "[AUP].[First Name] = '" & Me.[Text34] & "'"

End Sub

The Search works great but only searches on the 1 Field "First Name" . How would I expand the VB code to include another 2 fields within my table . ( the other 2 fields I want to serach appear on the Form ) .

View 4 Replies View Related

General :: Populate Combo Box From Table

Nov 9, 2013

So the information that I had to start with was

Colours

Silver
Black

Material

Metal
Plastic
Rubber
Digital

Component

Screen
Keyboard
Mouse Pad
Case
Hinge

So I've created 3 tables - one for each information group arranged like so. However my problems are - I don't know how to make it so that as soon as all the info for one set of parts is filled another set automatically appears? And in the Design section of the Form I have the following error because I wasn't too sure what to use apart from a text box-

View 7 Replies View Related

General :: Search Fields From Table B And Populate Into Table A

Jul 23, 2013

I have a table called BID with the following fields

bidder, seller, iid, starttime, bidtime, and bidprice

bidder is an id number that is reference to uid of table USER

the USER table have the following fields,

uid, uname, city, and state

I created a BID form for the user to enter data into the BID table. What I am trying to do but is having trouble with is have the user search for their name that may already be store in the uname field in the user table, and what ever they choose base on their search, the uid of this uname gets store into the bidder field of the bid table.

I still have a second step where the user in the bid form can search the iid but shows the itemname from the item table, and the value of seller, iid, and starttime from the auction table gets populated into the bid table.

iid from the auction table is reference to the itemtype and the following fields exist in the itemtype table.

iid, itemname, description

View 14 Replies View Related

Cascading Combo Boxes - Open A Form And Add Multiple Items To A Table

Mar 12, 2011

I have been trying to modify a sample database to suit what I want to do but I am getting stuck on the very first part cascading combo boxes i want to open a form and add multiple items to a table - first i want to select, from a combo box a department - then select a supplier from all the suppliers/manufacturers related to that department then select a stock item based on the description from all the items available from that supplier

I have attached the database I am using to modify and my database.

View 5 Replies View Related

Forms :: Lookup Table To Populate Combo Box?

Sep 2, 2014

I'm using a lookup table to populated a combo box on my form. I use a provided list of input strings (hundreds) in my combo box and the list is provided in all caps. How can I convert these provided words (strings) to first cap from either the quarry level or form level.

View 1 Replies View Related

Populate Subform/table With Multiple Records

Aug 5, 2005

I have the following tables:
tblProjects
ProjectsID (Primary key - exclusive)
ClientProjects
tblProjectsDetails
ProjectsDetailsID (Primary key)
ClientProjectsDetails (Secondary key)
tblQuotes
QuotesID (Primary key - exclusive)
ClientQuotes
Service
Rate
tblQuotesDetails
QuotesDetailsID (Primary key)
ClientQuotes (Secondary key)
Service
Rate

I have the following forms:
fmProjects
fmProjectsDetails (parent/child)
fmQuote
fmQuotesDetails (parent/child)


When I add a project I need to have data from the tblQuotes and tblQuotesDetails to populate tblProjects and tblProjectsDetails respectively.

It is very easy to populate tblProjects from tblQuotes since it is a single record. Therefore I use:
Me.ClientProjects = Me.ClientQuotes

:confused:
The question is: how to match the data of the 2 subforms? Since there will be more than one record per subform?

Any help is really appreciated.

View 2 Replies View Related

Select From Drop Down To Populate Three Fields In A Table?

Nov 6, 2012

I would like to be able to select a value from a drop-down and by doing so be able to populate three fields in a table.

View 12 Replies View Related

How To Populate A Form From A Combo Box

Oct 5, 2006

I'm creating a form that will have a combo box and several other fields on it. From the combo box, I want to be able to select a line from the combo box, click on the line and then have the form's other fields get populated.

I know I have to have the combo box and fields tied to either a table or to an underlying query, but what might be my best way to get the form populated?

Should I, in code tied to the form, run some coded SQL based on what I select and use the SQL results, or should I use something like recordsetclone, of which I have no experince?

Thanks inadvance to thoe who respond!! I reallyappreciate your help!!

View 13 Replies View Related

Populate Textbox With A Field From Another Combo Box's Row/source Table

Jul 18, 2005

I've designed a data entry form based on a table. I use a few combo boxes, (linked via SQL statements for their row/source) to fill most of the fields in the table.

What I want to do is populate one textbox on the form with the contents of a field in one of the combo box's row/source tables. The field I want isn't shown in the combo box.

Basically, what I want is that when I choose a PART NUMBER from a combo box, I want the OEM_ID from the same table to jump into the textbox below it.

I think I may have tied myself in knots though to the point where what I want can't be done. Any ideas? I know this is probably going to take a couple of goes at explaining. :P

View 11 Replies View Related

Forms :: Populate Text Box From Table Based On Combo Box Value

Apr 17, 2015

I am trying to populate the text boxes in a form with data from a table based on the selection a user has made in a combobox. I am trying to do this through a DLOOKUP in the text boxes Control Source using the following:

Code:
=DLookUp("[upMobile]","tblRepName","[tblRepName].[repContactMobile] = " & Str([upRepName].[Text]))

in the form when viewing the data.

View 8 Replies View Related

How Do I Read Input Values From Fields In Another Table?

Dec 10, 2007

Hi,

I have a query which uses manual input on two fields. I would like to automate this query by pulling the input values from another table.

How do I read the input values from the other table instead of having the users type them in ?

Al

View 1 Replies View Related

Forms :: Sum On A Tab From A Table (Fields With Number Input)

Feb 28, 2014

I have a table that has fields for number input

On my form I have in a TAB form 3 fields to input a figure, in the table these are set up as a Text NOT a Number. If i set it as a Number it keeps rounding up? even after i enforce 2 decimal places it still keeps rounding up.

Field 1 - 42988.62
Field 2 - 0.00
Field 3 - -14330.84

I then created a unbound txtbox so I can add these up

=[ResBF]+[ResRefReC]+[ResSurDef]

what i get in return is this :- 42988.620.00-14330.84

I also tried =Sum([ResBF]+[ResRefReC]+[ResSurDef])

and that just comes up with #Error

I even tried in the table directly to have a calculated field and still having the same problems.

View 3 Replies View Related







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