Access Help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
(e-mail address removed)
 
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
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help With MS Access 4
filtering records 4
Newbee help with forms 3
Filtering Queries for Forms 2
How to create a bubble chart with more than 2 variables 0
'Go to Record' button - simple task but can't get it to work 1
Basing One Combo Box on Another - How to add an All Category? 5
VBA - retrieve data on last create named range from previous inserted named range 0

Back
Top