Automatically Update Form Fields from Combo Box Selection

[nikik]

I am using Access 2007 and would like my subform to fill in the remaining text boxes in my form once I choose an item from the drop down combo box. Meaning if my table has "Fred, accounting, 555-5555". In the form, I'd like to be able to choose Fred from the drop down box and his department and phone number fill in automatically.

I've tried Me!TextBoxName=Me!ComboBoxName.Column(#) to no avail.

It seems like this would be easy to do and it DOES fill in the text boxes the very first time I choose something, but then the next thing I choose, it sends the data already there back to my table and screws up all my info. Perhaps I should be using a report or filter?

Any help would be greatly appreciated - Thanks!

 

[boblarson]

When I try to select Microsoft DOA 3.6 Object Library it says:

"Name conflicts with existing module, project or object library"

I'm not sure why the second mulitiple lookup option isn't working. Everything is going along fine and then at the end when I change my drop down selection nothing happens.

You didn't read my response carefully did you? I said -

DAO in Access 2007 IS NOT NAMED DAO. It is named:

Microsoft Office 12.0 Access Database Engine Object Library

THAT is the reference that needs to be checked in order to use DAO in Access 2007, NOT the Microsoft DAO 3.6 Object Library. You have to use the right one. So, does that make it a bit more clear?

 

[nikik]

OMG - I don't know why it worked, Alan, but I tried both methods again today and they're working great! Thanks so much!

Now, I'm off to try and figure out if I can have more than 1 recordset clone per form for the same table...yikes.

Thanks again and have a great weekend!