Auto fill a field from a drop down

N

newelljenn

I have a dropdown that has 3 columns
ID
Description
TaxRate

On the Afterupdate event of that drop down I want Access to take what is in
the TaxRate Column and put it in afield on the form called [ItemTaxRate]

So I put the following code on the After Update Event...

Me![ItemTaxRate] = Me![Set-UpCategoryID].Column(2)

When I click the drop down and choose a description, I get the following
Error

RunTime Error 438
Object doesn't support this property or method

Any suggestions on what to do?

Thanks,
Jenn~
 

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

How to make repeating drop-down lists? 2
Word VBA - Auto Populate Text on Dependent Drop Down Exit 1
Set Column choice to a variable from a Drop Down 4
Advanced Drop Down List Option 0
Linking drop down boxes 3
How can I get Sales Tax Rate in underlying Subform table. - Revisited 2
Linking Excel drop down lists 2
If then in an SQL clause - to filter drop down list 3

Top