A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Populate Combo Box based on multiple text fields



 
 
Thread Tools Display Modes
  #1  
Old March 27th, 2010, 04:41 AM posted to microsoft.public.access.forms
Mani
external usenet poster
 
Posts: 54
Default Populate Combo Box based on multiple text fields

First of... can someone please help me??? I have posted more than 3 questions
over 2 months and no one has helped me. Does this website still active??
Ok, here goes the question. I have five differtent Tables (titled: 9th
Grade Courses, 10th Grade Courses, 11th Grade Courses, 12th Grade Courses,
and Rigorous Curriculum). 9th-12th Grade Courses Table are text fields and
Rigorous Curriculum Table is combo box consisted of State Scholars
Initiative, Advanced Placement, IB, and Scholars Curriculum.
Alirght so, this is what I want to happen: I want to select data from the
combo box based on the courses entered in the text fields from the four
tables. . How do we go about doing this?? Please help me??? Thanks in
advance!!
  #2  
Old March 27th, 2010, 06:06 AM posted to microsoft.public.access.forms
Tom van Stiphout[_2_]
external usenet poster
 
Posts: 1,653
Default Populate Combo Box based on multiple text fields

On Fri, 26 Mar 2010 20:41:01 -0700, Mani
wrote:

In this particular forum 10-20 questions get answered with 1 - 4
answers. If yours is not among them, here are some guidelines about
asking good questions: http://www.mvps.org/access/netiquette.htm

When I read your current question I'm thinking you have a COMPLETELY
WRONG database design, with tables per course. That in itself might
turn me off in answering the question. But what turns me off more is
that you ask a question without putting yourself in the position of
someone who has never met you and has never seen your application. For
example " I want to select data from the combo box based on the
courses entered in the text fields from the four tables" is a
statement I cannot understand at all. So I move to the next post.

Would it be better to ask your question in your primary language
(.it?) forum?

-Tom.
Microsoft Access MVP


First of... can someone please help me??? I have posted more than 3 questions
over 2 months and no one has helped me. Does this website still active??
Ok, here goes the question. I have five differtent Tables (titled: 9th
Grade Courses, 10th Grade Courses, 11th Grade Courses, 12th Grade Courses,
and Rigorous Curriculum). 9th-12th Grade Courses Table are text fields and
Rigorous Curriculum Table is combo box consisted of State Scholars
Initiative, Advanced Placement, IB, and Scholars Curriculum.
Alirght so, this is what I want to happen: I want to select data from the
combo box based on the courses entered in the text fields from the four
tables. . How do we go about doing this?? Please help me??? Thanks in
advance!!

  #3  
Old March 27th, 2010, 06:15 AM posted to microsoft.public.access.forms
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Populate Combo Box based on multiple text fields

On Fri, 26 Mar 2010 20:41:01 -0700, Mani
wrote:

First of... can someone please help me??? I have posted more than 3 questions
over 2 months and no one has helped me. Does this website still active??
Ok, here goes the question. I have five differtent Tables (titled: 9th
Grade Courses, 10th Grade Courses, 11th Grade Courses, 12th Grade Courses,
and Rigorous Curriculum). 9th-12th Grade Courses Table are text fields and
Rigorous Curriculum Table is combo box consisted of State Scholars
Initiative, Advanced Placement, IB, and Scholars Curriculum.
Alirght so, this is what I want to happen: I want to select data from the
combo box based on the courses entered in the text fields from the four
tables. . How do we go about doing this?? Please help me??? Thanks in
advance!!


STOP.

Your database is incorrectly designed.

You should not have multiple tables of courses. You should instead have ONE
table of courses, with a unique CourseID as the primary key, a Grade field,
and other fields about the course.

A field cannot be "a combo box". A combo box is not data; it's a *tool for
displaying data*.

Read up about "normalization" and database design; these resources might help,
particularly the tutorials toward the end:

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/acc...resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

Roger Carlson's tutorials, samples and tips:
http://www.rogersaccesslibrary.com/

A free tutorial written by Crystal:
http://allenbrowne.com/casu-22.html

A video how-to series by Crystal:
http://www.YouTube.com/user/LearnAccessByCrystal

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

If you would like more help, please post back with a description of your
tables in the form

Tablename
Fieldname - datatype
Fieldname - datatype

and indicate which field (if any) is the Primary Key of each table, and how
(if at all) the tables are related.
--

John W. Vinson [MVP]
  #4  
Old March 28th, 2010, 06:16 AM posted to microsoft.public.access.forms
mani
external usenet poster
 
Posts: 1
Default Populate Combo Box based on multiple text fields

Ok.. thanks for the info you've given me, which made me adjust the design I had earlier. I looked this over and over again, so this is what I came up with and hopefully this will simplify what I have in mind. So I will have a form which will be consisted of text fields that will be added. So now, based on what courses I have in the field, I want to add another field which will be automatically filled based on the courses that were entered in the text fields. I hope this makes sense. Please, can someone help me out??

---
frmsrcurl: http://msgroups.net/microsoft.public...le-text-fields
  #5  
Old March 28th, 2010, 04:47 PM posted to microsoft.public.access.forms
Arvin Meyer [MVP][_2_]
external usenet poster
 
Posts: 2,310
Default Populate Combo Box based on multiple text fields

This uses List Boxes, but the priciple is the same:

http://accessmvp.com/Arvin/Combo.zip
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access


"mani" / wrote in message
...
Ok.. thanks for the info you've given me, which made me adjust the design
I had earlier. I looked this over and over again, so this is what I came
up with and hopefully this will simplify what I have in mind. So I will
have a form which will be consisted of text fields that will be added. So
now, based on what courses I have in the field, I want to add another
field which will be automatically filled based on the courses that were
entered in the text fields. I hope this makes sense. Please, can someone
help me out??

---
frmsrcurl:
http://msgroups.net/microsoft.public...le-text-fields



  #6  
Old March 28th, 2010, 09:07 PM posted to microsoft.public.access.forms
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Populate Combo Box based on multiple text fields

On Sat, 27 Mar 2010 22:16:24 -0700, mani / wrote:

this is what I came up with


"this" being....?

You didn't post any description of your current table structure or form.

--

John W. Vinson [MVP]
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:49 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.