Form record updated from combo selection

[robmkimmons]

I have searched high and low on this site for the answer to this. I know it's a simple syntax that i'm just not getting. I have a bound form with a subquery which also has three additional unbound combo boxes on the side which refer to the same table as the bound form does for the employee information.

My idea is that once you open the form you can enter new information in the bound fields (ie. a new employee) OR select the unbound combo box [cboSearchNameL] of the employee's last names which are already in the tables and add additional information in the bound fields. I know that i need to trigger an AfterUpdate Event from the [cboSearchNameL] combo box but what i can't get is the syntax.

I have tried several coding options but nothing seems to work.

unbound combo box = [cboSearchNameL]
bound text box = [NameL]


(or is there just a much easier way to do the form layout?)
MUCH THANKS! ~Rob

If we expect the unexpected, does that make the unexpected... well, expected?

 

[WildHare]

Rob , you're on the right track. Check out the combo box wizard that does a "find a record on my form based on a selection I make in a combo box" guy - it builds a combo with selected fields and the KEY field, and then sticks it on your form. It uses RecordsetClone and bookmarks to find and position to a record. Very simple. Exactly what you want. "Remember, you're unique - just like everyone else"
Feel free to visit another free Access forum:

http://www.forumco.com/jmhare

or my site,

http://www.jmhare.com

 

[robmkimmons]

Muchos Gracias! (i like making things more difficult i guess) P ~Rob

If we expect the unexpected, does that make the unexpected... well, expected?