Tables :: Look Up Combo Box

Oct 28, 2014

have a combo box that looks up a product number form another field but i also have a combo box in the next field that has product name. It would be much better if once you select a product code that the product name comes up automatically.

View Replies


ADVERTISEMENT

Combo Box Selection Triggering 2nd Combo Box Tables

Oct 26, 2004

I'm trying to get one combo box control what tables are available from another combo box. Example, combo box (a) includes numbers 1-5. Selecting (1) makes the data in combo box (b) specific to that selection. Selecting (2) makes the data in combo box (b) something different (pulls data from a different table).

Can anyone help me with this? Thanks!

View 1 Replies View Related

1 Combo Box 2 Tables

Mar 31, 2005

Hello everyone, I have the following tables, tblEmployees, tblDependents & tblMedicalInsurance. My tblMedicalInsurance contains the following fields;


MedicalNo
PlanName
Insured
EligibilityDate
CoverageDate
TerminationDate

In my Medical Insurance form the Insured field will be a combo box and I want this combo box to display both the employees and dependents names. Does anybody know if this can be done.


Thank you for your help.

View 1 Replies View Related

Allow Combo To Read From 2 Tables

Apr 8, 2006

Ok, what i have is a form on which a user has an Option Group for selection on which records are shown (consumable and Non-consumable), also on the form is a combo box which reads from Table Asset Categories. However what i want to do is allow this combo box to read from another table depending on which option is selected in the Option Group. ie change its Table and row source, but i can't figure this out. I thought something in the region of:

If Me.OptionGroup = 0 then recordsource = "Asset Categories"
Else RecordSource = "Consumable Categories"
End IF

Any Help Please

View 3 Replies View Related

Combo Boxes And Looking Up Tables

Dec 5, 2004

Hello All,

I am a new Access user, and I am trying to create a database that will store and track print music.

I want to be able to track data by a text box called "Item Number". The item number is obtained automatically when the user inputs data from two different Combo Boxes.

"cmboInstrument" and "cmboMusicType"

Both these combo boxes look up separate tables which have in them two columns each
1. Instrument (Eg. Bass Guitar)
2. Code Number (Eg.0012)

The combo boxes look up the tables fine.

My problem is, that I want the txt box to display the data from both combo boxes (Eg: an eight digit number 01002111). I then also want the text box to generate a Item number starting from 0000.
So all in all the Item Number after selections have been made will display 010110000000 (an ID number example).

The numbers generated need to be displayed in the table under Item Number so that they can be associated with the product, therefore I assume they need to be bound and I am currently using the code

"Private Sub cmboMusicType_AfterUpdate()
Me.txtItemNumber.Value = Me.cmboMusicType.Column(1)
End Sub"

Though this only works for one combo box, if I put it in another combo box - the numbers will not join together.

Please Help!!!!

View 3 Replies View Related

Recall - Combo Box From 3 Tables

Jan 22, 2005

I want to create a combobox from 3 tables. The tables are like this:

Table / Field

TblSource / Source

TblAdverts / AdRef

Tbljobcentre / JobCentre

I now want a combo box listing everything from these fields in the 3 tables. Can this be done through VB or will I have to create a series of queries to append etc (which I think tends to run slower than code)?

I also want everything in the tbladvert table to be prefixed by PR and everything in the TblJobCentre table to be prefixed with JC.

Help on the first one would be great, but even jufirst part would be a big help.

Cheers,
Recall.

View 1 Replies View Related

Allow Combo To Read From Two Tables

Apr 8, 2006

Ok, what i have is a form on which a user has an Option Group for selection on which records are shown (consumable and Non-consumable), also on the form is a combo box which reads from Table Asset Categories. However what i want to do is allow this combo box to read from another table depending on which option is selected in the Option Group. ie change its Table and row source, but i can't figure this out. I thought something in the region of:

If Me.OptionGroup = 0 then recordsource = "Asset Categories"
Else RecordSource = "Consumable Categories"
End IF

Any Help Please

View 3 Replies View Related

Tables :: Combo Box Displays ID Only?

Dec 10, 2012

I have been designing a database and finally was making good headway. I have a junction table that references 2 tables (1-m) and the junction table creates an autonumber primary key that many tables will reference. I realized that the junction table could have duplicates. I did not want to use a composite primary key, but found that I could create an index that contained the unique combination of my foreign keys. No more duplicates. I thought things were looking up. I found out that it is a bad idea to use a combo box in dataset view to have look-ups to other tables. If it is a bad idea why have the option? It does make data entry easier. Anyway not my question. The other tables that refer to my junction table no longer show the values of the foreign keys, but displays an id number for my 2 columns.

Using MS Access 2010 32 bit Win XP.

View 5 Replies View Related

Combo Box Values Being Stored In Tables As 1 And 2 Etc..

Feb 12, 2008

Hi,

I have combo boxes on a form which are pulling values from a one table and being stored in another table. However they are being stored as '1' or '2' in the other table once selected on the form, as instead of being stored as their literal values ie 'car' or 'van'. Is there any way of making this happen, as it makes reporting a nightmare! Thanks in advance...

View 2 Replies View Related

Urgent Help Please With Combo Box And Populating Tables

Oct 31, 2004

I am trying to create a database which will act as a timesheet and management system.

I have several tables set up. some are:
01-Staff details containing Staff ID, Names, etc
11-Timesheets containing Timesheet ID, Staff ID, Timesheet Period ID
17-Timesheet Periods containing Timesheet Period IDs, Start Date and End Date.
13-Hours containing Hours ID, Timehseet ID, Project ID, Hours
etc.

I want to set up a Combo that lists Names from Table 01-Staff Details, and when the user selects their name, enters the Staff ID on a new row in the tabll 11-Timehseets.

I am able to create the Combo to list the names from 01-Staff Details, but am not able to get the selected name to jump into 11-Timesheets. The field is not available in the Control Source.

Could you please assist? I am not an Access expert, nor have I done any programming, so a step-by-step solution would be greatly appreciated!!

Many thanks in advance

Sunil

p.s. I would then like to ensure that users can't edit data in certain tables (eg. they shouldn't be able to create a new Staff ID/name, etc)

My next task will be to create a sub-form (which I am able to do) where the user can select a project from a combo-box and enter the hours worked on it. I would like the project and hours to be entered on a new row under the table 13-Hours

I look forward to your reply!

Many thanks

View 4 Replies View Related

Combo Box Values Being Stored In Tables As 1 And 2 Etc..

Feb 12, 2008

Hi,

I have combo boxes on a form which are pulling values from a one table and being stored in another table. However they are being stored as '1' or '2' in the other table once selected on the form, as instead of being stored as their literal values ie 'car' or 'van'. Is there any way of making this happen, as it makes reporting a nightmare! Thanks in advance...

View 1 Replies View Related

Tables :: Combo Box Not Showing New Number

Oct 5, 2014

I have a form (frmHourEnter) with a combo box (cmbJob) and if the number entered into the combobox is not in the list then another form (frmJob) is opened and a new number is entered. On closing this form I run:

Code:
Me.Form!frmHourEnter!cmbJob.Requery

The combo box (cmbJob) does not show the new number unless I close the form (frmHourEnter) and re-opened it. If I add the following code to the one above:

Code:
DoCmd.Requery "Form!frmHourEnter!cmbJob"

Then click out of, and then back into cmbJob the number is in the list! What can I do so that the number is in the list when the second form is closed?

View 11 Replies View Related

Tables :: Cascading Combo Box Setup?

Sep 17, 2012

I have been reading about how to set the table up for cascading combo boxes. Some recommend breaking down into several tables, others say keep it to one table.

Mine is broken down to 5 tables (and work) but if you go to the form (split form) and make a change in design view - even something as simple as changing the width of a field - then the split table looses 2 fields information (the middle fields) but the information is still saved in the main (studentcourse) record table.

My question is how do i make it more stable so that the split form table section does not lose the information?

View 5 Replies View Related

Forms :: Getting Data For A Combo Box From 2 Different Tables

May 13, 2015

I have form with a combo box that displays error messages from Table A. These error messages are linked to Table B via an ID. The other table also contains an error message. I can obviously display the error message and ID from Table A in the drop down box.

What I want to be able to do is display the error message from TableA and also the error message from Table B.

Is this possible and if so how?

The control is bound to a further table but the ROW source is via a select statement. Is it as simple as changing the select to some query? If so how do I select the fields to display or are all the fields in the query displayed?

View 6 Replies View Related

General :: Combo Box - Multiple Tables

Jun 26, 2014

I have
tblProducts - Where is my inventory list and
tblServices - where are my services

Also I have made an invoice form and a datasheet subform (orderDetails) where I enter/choose (using combo box) said services/products but I know only how to do it for one table ex. tblProducts. My question is can I make a drop down list for two tables? One column - ServiceName / ProductName
So I can choose a service or a product in the same order line.Or do I have to join my services and products in the same table?

View 4 Replies View Related

Tables :: How To Add Fields Not Listed In A Combo Box

Oct 5, 2012

I have a list box with 5 items and need to design an option for a user to add a value that is not listed. how will the new fields be added to the table?

View 1 Replies View Related

Tables :: Column Display With Combo Box

Oct 28, 2013

i have a table of 3 columns Named as C_Name, C_City and C_PIN..i have a combo box with All Value (All,C_Name,C_City and C_PIN)...i want to display All columns ,when i select All in Combo box and when i select Column C_Name, only display C_Name Column).

View 6 Replies View Related

Tables :: Combo Box - How To Get Description To Appear In The Table

Sep 9, 2013

I have a combo box in a form that is used to populate one of the columns in a table. How do I get the description to appear in the table instead of the primary key?

View 3 Replies View Related

Combo Boxes To Filter N Show Tables

Oct 25, 2005

Im kinda new to Access and only been using the "Access 2003 for Dummies" for learning and making small databases. So far I can find out how to do the things I want, but recently got stuck with a combo box feature. What im trying to do is select entries in my combo box so that it will filter the table and show all its contents based on that filter. Im not sure how to link the combo boxes the right way and it seems some VB coding is needed which I dont normally use. If anyone has any idea how to do it, tell me how! Thanks. BTW im using Access 97.

View 7 Replies View Related

Choosing Subform From Multiple Tables With Combo Box

Sep 6, 2005

Hi guys,

I've run into a little problem while working on a electronics component database:

My plan was to use one specific table for each kind of components, i.e. resistors, capacitors, transistors etc as the specific data of each type is quite different from the other types (resistance/capacitance etc). I also thought I'd use a main form with a drop box allowing the user to choose which component to look for and then a component type specific subform to let the user make a more detailed search.

The thing is that I'm not quite sure how to call different subforms based on the drop box selection (I guess I need a subform for each type of component)? Or can I call a table with each component's specific data types and generate a subform based on this table? (I'd prefer the latter...)

To find a specific resistor you might want to specify the resistance, the type of resistive material, size and tolerance whereas an integrated circuit requires information on type of circuit, package, size etc.

All similar questions I've found relates to the use of a single, main, table only, I can't really see how to do that here...

View 1 Replies View Related

Tables :: How Safe Using Combo Box To Input Foreign Key

Aug 12, 2013

In a Related Tables, you need to enter a FK to link to the other table.You either key in the FG from memory..The standard procedure is to design the field as combo box AND use SQL to select the field that will input the ID of the other table. So, if you want to input foreign key 3 , the combo box will display what 3 is then when you selected Access will insert 3 for you.

My question is since I can later on, edit the table and change the the value to another value, and mess the whole thing up!!! HOW can I lock my first choice so it will stay unedited ? My second question is: Is this the only way to input the FK if you do not remember the exact ID number or there are thousands of records in the related table.?

View 8 Replies View Related

Tables :: Combo Box - Record Tagged With Two Items

Jan 16, 2014

So I've been reviewing cascading combo boxes and I am finding some good stuff. But here is a preliminary step I need. I need to tag each record with something like what month are they assigned in, and what products. Then I need the combo box to display what that month is that they are tagged in, and then populate the second combo box. It is the second combo box that will show the record on the form. Its possible that there will be two items they are tagged with.

View 7 Replies View Related

Tables :: Corresponding Data In Combo Boxes And Subforms?

Sep 27, 2013

I have a field showing who equipment is being distributed to pulling data from my US Employee table. If I make it to only the last name from my lookup

(SELECT [US Employees].[Last Name], [US Employees].[First Name], [US Employees].[Dept] FROM [US Employees] ORDER BY [Last Name], [First Name], [Dept])

I can also view the equipment listed under the individual it is assigned to on a subform on my US Employee table. If I try to have the first and last name displayed on my Equipment table, however,

(SELECT [US Employees].[Last Name]&", "& [US Employees].[First Name], [US Employees].[Dept] FROM [US Employees] ORDER BY [Last Name], [First Name], [Dept]; )

it will not display under the individual on the US Employee table. Is there a way around this without having to combine the fields on the employee table or separate them on the equipment table?

View 8 Replies View Related

Tables :: Combo Box And Check Box Showing As Textboxes

Aug 22, 2013

Today and yesterday I added new fields to a table and they are showing wrong when everything is right. I added yes/no fields and a combo box look up and when I drag them over to my forms they are just showing as textboxes and not a checkbox or combo box. When I look at the backend and look at the fields it clearly says it should be a checkbox or combo box. Iv done it the same way I always have and this time its just wrong.

View 5 Replies View Related

Tables :: Exporting Combo Boxes To Excel

Jul 3, 2014

I have a subform with a combo box selection field among other fields. Can I export the data showing on the subform together with the drop down combo box data for each record and all its choices so that it appears as the same combo box on the worksheet. The user will then update combo box selections as required and the results would be imported back into access in the correct boxes for inclusion in a report, is that easily achievable for a moderate access user?

View 2 Replies View Related

Combo Box To Find Records From Multiple Tables

Jul 30, 2013

I have a main form that has fields from different tables. This is a research study, so each form enters data into different tables. Well, each record is a person's data. Instead of scrolling through each record, I need an option on the main form that allows me to search for a specific person and have their data populate into the form.So far I am able to make a combo box that pulls up the record from one table. Well, HOW do i do it from ALL the tables!?? Do I have to make a query?

View 3 Replies View Related







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