Lookup Wizard Confusion

[akafrog18]

In my database, the first table that I use has several fields. In the first field, I have a lookup setup to select which kind of change I am making to the employee (i.e. Demotion, Pay Rate Change, and Termination). The next field I need it to check the first field for the type of change and then list the correct set of reasons why. I am a novice at Access but I am able to follow directions quickly. If anyone could help me, I would much appreciate it.

 

[Remou]

It is generally not a good idea to use look-up fields, see

http://www.mvps.org/access/lookupfields.htm

for the reasons. If you create a form based on your table, you can use Cascading Comboboxes to achieve what you want. Have a look at:
Combo Box - dependant on another Combo Box
faq702-4289

This thread would fit well in
Microsoft: Access Forms Forum
forum702
Where you will find a lot of posts on Cascading Combos.

Good luck with your project.

 

[akafrog18]

The Combo box option is great and works quite nicely. Now the only thing is how do I get the form to save the entered data back to a table for reporting?

 

[Remou]

You need to bind the table to a form. The best bet is usually the Form Wizard, however, you can also set the Record Source of the form to a table or query (use the Property Sheet). Similarly, the combo boxes need to be bound to fields in a table or query, for this, you need to set the Control Source (see Property Sheet) of the combo boxes to fields in the table. You can get quite far with wizards, but a bit of reading is going to be necessary.