Access Help

Y

Yula

I am a completly new user to Access and I have been asked to create a
database for a big project we are working on. I am creating a form where a
user would have to select a catagory and after they select a drop down box,
below the radio button, would show a list associated with the selection. I
have no idea how to do this. can some one help me please??

Ex. Categories
A.
B.
C.
D.

When you click on A, a list shows up with job names.

I appreciate any help.
 
S

Steve

To be sure your tables are correct, you need:
TblJobCategory
JobCategoryID
JobCategory

TblJob
JobID
JobCategoryID
JobName
<Other job fields as needed>

I will presume the name of your form is FrmJob. Name your combobox
JobCategory. Create a query named QryJobList based on TblJob. Include JobID,
JobCategoryID and JobName in that order. Put the following expression in the
JobCategoryID field:
Forms!FrmJob!JobCategory
Create a listbox named JobList and set the rowsource to QryJobList. Set the
bound column to 1, column count to 3 and column width to 0;0;2. Add the
listbox to FrmJob.
Put the following code in the AfterUpdate event of your combobox:
Me!JobList.Requery

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
[email protected]
 
Y

Yula

Thank you Daniel, that was helpful. After a few tries I got it to work. I
Have another question, maybe you can help?

I have all the correct jobs showing when I select the category in the first
combobox,
how do I make the second combo box show all jobs associated with the
category All categories. In my query, I have a categoryID assocaited with all
jobs, but I can't have another ID for all the jobs to represent the All
category.

Thanks,
Yula
 
T

tbl

I am a completly new user to Access and I have been asked to create a
database for a big project we are working on.
Click to expand...


Similar situation here...

I have no construction experience, but I've been asked to
build a shopping center...
 
Top