please some more expierenced users help

[maxxximaniac]

Hey Everyone.. I appreciate the help in advance..

in my DB the main form is 'checksreceived'
the form is bound to a table "checksreceived", I added a combo box thats bound to another table "employees"

I set the relationshop with the 2 tables but my problem is trying to get the employee's name to write to "checksreceived"

If you look at the attached DB, the combobox is called "employeepick"
then theres a box on the left named Text84 the control source is employee pick
then I have another box Text86 above it, the default value is set to Text84 and the control source is the employee field in checksreceived..

My problem is that The employee name only populates on text 86 AFTER a record is inputted. I need the employees name to populate upon selection.

Any thoughts?

Again, any help would be most appreciated
Thank you!

EDIT* Link would probably be helpful...ha!
http://www.zaiderman.com/Payment Window Customers.mdb

 

[pbaldy]

Why not just have the combo bound to the appropriate field in checksreceived? It can have a row source from employees, but a control source in checksreceived.

 

[ansentry]

The following will work:-

Open your form in design view and select EmployeePick, enter Employee in the control source. That will fix all you problems, you can now delete Text 86 and Text84.

May I also suggest that you name you combo box as cboEmployeePick it makes it easier to identify.

 

[maxxximaniac]

Ha I dont believe I missed that, you guys had the same idea....
sometimes its just the easiest things that seem so difficult
It works for me.. Thanks a lot guys!