select code

[AlreadyLost]

I have a form with that display the name of the Attendee and their information. I also created a command button that is call ClassTaken. Not all the attendee have taken a class. So, on the form view, if I click on the Classtaken, i want it to take me to another form that list the class that this active attendee had taken. If the active attendee did not take any class then I want it to say "No class had taken"..

I have three simple table..
Table A (Attendee Information)is the AttendeeID, and all his/her information,

Table B (ClassTaken information)is the ClassID, AttendeeID, AutoID, YearTaken

Table C is the Class information (all class), contain ClassID, and location, time, date, type.

New with Access and need help. Thanks

 

[TheAceMan1]

How are ya AlreadyLost . . .

Have a look at the [blue]DoCmd.OpenForm[/blue] 3rd & 4th arguements!

See Ya! . . . . . .