Michael
The easiest way to do this is to use a combo box instead of a text box for both controls. You select a Category from cboCategory (a combo box. That will trigger the AfterUpdate event. With a little code you can filter the second combo box's list to fit the chosen category.
If you go to our Files/Samples folder you will see a sample named CascadeComboBikesSample.zip created by one of our Microsoft MVP members. It shows how to do what I have described.
Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com
--- In MS_Access_Professionals@yahoogroups.com, "Michael K. Davis" <abbsgen@...> wrote:
>
> Hi. I am using Access 2010 on a Windows 7 Ultimate computer. I have a
> inventory table with a Categories field. I would like Access to
> automatically complete another field on the table with certain text
> variables, depending on which Category I have chosen. How would I do this?
> I am a total novice, so the simpler the answer, the better. Thanks!
>
>
>
> Michael
>
>
>
> [Non-text portions of this message have been removed]
>
Tidak ada komentar:
Posting Komentar