Access Help

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Yula - 29 Jun 2007 16:46 GMT

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.

Reply to this Message

Daniel - 29 Jun 2007 18:18 GMT

I would suggest using cascading combo boxes for your situation.

Look at:
http://office.microsoft.com/en-us/access/HA011730581033.aspx?pid=CH063650361033

Signature

Hope this helps,

Daniel P

> 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
[quoted text clipped - 11 lines]
>
> I appreciate any help.

Reply to this Message

Yula - 11 Jul 2007 19:16 GMT

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 would suggest using cascading combo boxes for your situation.
>
[quoted text clipped - 16 lines]
> >
> > I appreciate any help.

Reply to this Message

Steve - 29 Jun 2007 18:27 GMT

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
resource@pcdatasheet.com

>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
[quoted text clipped - 12 lines]
>
> I appreciate any help.

Reply to this Message

tbl - 31 Jul 2007 19:34 GMT

>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.

Similar situation here...

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

Reply to this Message