Search results for query: *

I got it to work. Someone before me had set the control source to a different field on the combo box so that's why it wasn't working. Plus, it wasn't populating the underlying data table. But I followed your code and got it to work along with several other fields on the form. Thank you so...

Still not populating anything. I am going to try again tomorrow. Thanks for all your help. I know that there is just something off in what I am doing...

Yes, The combo box currently has this code SELECT Clients.[Client#], Clients.[Client Name], Clients.[Payroll Team] FROM Clients ORDER BY [Client#], [Client Name], [Payroll Team]; The 3rd column would be Payroll Team

One more quick question, because I think that will work, however how do I get it to recognize the table name Clients in the After update? Because I don't get the error but nothing happens in the text box named payteam. The field name is Payroll Team. Do I have my syntax wrong... Private Sub...

Thank you for your response. But when I add that to the after Update I get the error message Microsoft Office can't find the macro 'Me![Payoll Team] = Me!coclient#' I just don't understand.....

Okay, so here's my situation, I have created a combo box, where the user selects a client # and then it autopopulates another field. Works great! But now, I have another field that I want to update as well, that is linked to client #. I was trying to do something in the After Update. Here's...

Has anyone had any experience writing jobcosting and detailed transaction reports to import into Quickbooks. Several of our clients use Quickbooks and we want to be able to write reports that are easily uploaded into their program. Any suggestions, tips, tricks, e.t.c. [ponder]