Jeff,

May I ask for your input on another item?

I been working on an application for some time now that involves several
Forms.

I would like to reduce the amount of clicking that the User has to do inside
of these forms. The Forms currently require the User to make selections and
then the data blows into a text field automatically because of a little VB
Code the I've written in an Event Procedure.

What I would like to do is have the Form automatically get and place most of
the  information onto the forms for the User and have the appropriate field
automatically update in the Data Table.

I've been able to get the data to automatically display through a List Box
buy using an SQL Statement in  "Row Source".

But My problems are these:

I can't make the List Box Word Wrap.

And I can't get the Form to write the displayed info back to my Table
without doing some kind of event that has to be imitated  by the User.

I've tried putting some VB stuff into "Before Update", and After Update, and
that works but you still got to click something on the form before it
actually writes back to the table.

I've tried putting some VB in the "On Open" Event for the Form but got
nowhere with that.

I've tried using a List Box and then pointing a Text Box tot he List Box
with the Text Box pointing back to the Table - That works as long as you
click the List Box.

I must be over thinking this problem.  Can you point me in the right
direction?

Thanks.
Larry