Displaying Combined the text of three fields on a form...

[Neil]

Hi,

I have three fields on a form, one that's manually entered, and the
other two drop down lists.

A combination of these three is put down on a physical file for quick
referencing. (I am aware this is not a very good database practice, but
nonetheless).

Thus the text on the file will read:

FileNo/Field2/Field3

I need this number to be displayed prominently as soon as the three
fields are filled in. This is how I went about it:

1. Made a text box on the form called "CombinedText".
2. When the field3 is updated, I set focus on the CombinedText text=box
3. Put a command:
combinedtext.text=Fileno+"/"+Field2.text+"/"+field3.text

However, I keep getting a "You can't reference a property or method for
a control unless the control has focus" error.

What do I do?

Thanks in advance,

Neil

[Tommy T-Bag]

yeah, this is a really annoying problem isn't it??

try using the .Value property of the TextBox and ComboBox controls
instead.

Another way...set focus to each of those controls using Field2.SetFocus
before referencing the .Text property. I don't like that as much
because
you run into more problems, such as the .Text property doesn't actually
get set from certain events like OnEnter or OnKeyDown.

The technical explanation is:......Access is a piece of shit.

[Tommy T-Bag]

I also noticed that you used "+" for string concatination...a normal
Access .mdb file would prefer "&".

[Arno R]

"Tommy T-Bag" <th***********@gmail.com> schreef in bericht news:11*********************@z14g2000cwz.googlegro ups.com...

Another way...set focus to each of those controls using Field2.SetFocus
before referencing the .Text property. I don't like that as much
because
you run into more problems, such as the .Text property doesn't actually
get set from certain events like OnEnter or OnKeyDown.

The technical explanation is:......Access is a piece of shit.

Don't judge too fast or someone here will do the same to you ...
If you don't know how to use the tools, then don't give 'technical' explanations like the above.

The OP needs to use the Change-event and use *only* the text-property of the 'current' control like:
Sub Field3_Change()
combinedtext = Fileno & "/" & Field2 & "/" & field3.text
End sub
Sub Fileno_Change()
combinedtext = Fileno.text & "/" & Field2 & "/" & field3
End sub
Same for Field2 ...

Arno R

[Tommy T-Bag]

The explanations I put work. I know how to use the tools just fine.

My objective opinion is that Access is in many, many ways inferior
to certain other Windows platforms. I am sure there are others in
this group who would agree.

My "technical explanation" is an example of something
called sarcasm.