"strive4peace" wrote:

Hi F (what is your name?)

"simply shows an empty box"

you must assign the form RecordSource first ... then you will see the
fields in the Recordsource when you drop the combobox for ControlSource

My form has numerous controls each with its own source line but how do I
assign a source to the total form, I tried but seem to have missed that
soemwhere. I am still reading. chaGRIN

smile

~~~

Trim will work -- but any valid equation must start with =

if you use an equation, you cannot change the information, it will be

Me.txtBuildID = Trim(Me.cboAddress.Column(5) & Me.cboAddress.Column(6))

for display only


Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day
*




FBrnstrmr wrote:
You are of course absolutrly correct, but I did so because the down arrow to
which you refer simply shows an empty box and so there is nothing from which
to choose.
(I am reading the form and report design right now, interestings tips there,
but the TRIM (command?) didn't work. I am trying to show a concatenated field
of 2 numbers but there is always a space, even after I left justified the
right hand (or second) number.
I am very grateful for all your help, please don't give up on me. Thanks
very much.
-F