Calculated field not showing up after filtering

[Guest]

On the second of two tabbed forms I'm redisplaying the name by concatenating
data from two fields from the first form. It works fine until I use a filter.
After applying a filter, I must click on that field or tab to it to get it to
begin displaying that data. Moving to a second record will also start the
display in that field, and then I can move back to the first record to view
the data.

I've tried several things incluidng a macro that moves the focus to that
control "TabToNext", but nothing seems to work. It's like it doesn't
"calculate" until you give it a physical nudge. Any fixes come to mind?
Thanks in advance

 

[BruceM]

It's hard to know what to suggest without knowing how you are going about
this (for instance, how are you applying the filter, and how are you
concatenating, and are there two tables involved here), but I have a few
thoughts. You could try concatenating the fields in the form's Current
event, or at the end of the code you use to apply the filter (assuming you
use code rather than the toolbar buttons to filter the records). Requerying
may do the trick; I'm not quite sure about that, but it is easy enough to
try. Also, if you are using a query as the form's record source you could
concatenate in a blank column in query design view:
NewField: [Field1] & [Field2]

 

[Guest]

Thanks for your thoughts, Bruce. The concatenation takes place within the
tabbed form. I've set two special toolbars in place. One to do sorting and
search, the other to do filtering (hiding all other toolbars to keep a clean
screen), and the filter is applied by form by clicking on check boxes. The
toolbar has all that is needed.

Your suggestion about doing the concatenation in the query might work. I'll
check that out. Thanks very much.
--
Norm Shimmel
Butler, PA

It's hard to know what to suggest without knowing how you are going about
this (for instance, how are you applying the filter, and how are you
concatenating, and are there two tables involved here), but I have a few
thoughts. You could try concatenating the fields in the form's Current
event, or at the end of the code you use to apply the filter (assuming you
use code rather than the toolbar buttons to filter the records). Requerying
may do the trick; I'm not quite sure about that, but it is easy enough to
try. Also, if you are using a query as the form's record source you could
concatenate in a blank column in query design view:
NewField: [Field1] & [Field2]

 

[BruceM]

I'm not sure how you are using the check boxes (are you checking relevant
boxes, then clicking a command button, or are you using the check box After
Update event, or what), but in any case you should be able to concatenate in
the function or event that is being used to apply the filter.

Thanks for your thoughts, Bruce. The concatenation takes place within the
tabbed form. I've set two special toolbars in place. One to do sorting and
search, the other to do filtering (hiding all other toolbars to keep a
clean
screen), and the filter is applied by form by clicking on check boxes. The
toolbar has all that is needed.

Your suggestion about doing the concatenation in the query might work.
I'll
check that out. Thanks very much.
--
Norm Shimmel
Butler, PA

It's hard to know what to suggest without knowing how you are going about
this (for instance, how are you applying the filter, and how are you
concatenating, and are there two tables involved here), but I have a few
thoughts. You could try concatenating the fields in the form's Current
event, or at the end of the code you use to apply the filter (assuming
you
use code rather than the toolbar buttons to filter the records).
Requerying
may do the trick; I'm not quite sure about that, but it is easy enough to
try. Also, if you are using a query as the form's record source you
could
concatenate in a blank column in query design view:
NewField: [Field1] & [Field2]

On the second of two tabbed forms I'm redisplaying the name by
concatenating
data from two fields from the first form. It works fine until I use a
filter.
After applying a filter, I must click on that field or tab to it to get
it
to
begin displaying that data. Moving to a second record will also start
the
display in that field, and then I can move back to the first record to
view
the data.

I've tried several things incluidng a macro that moves the focus to
that
control "TabToNext", but nothing seems to work. It's like it doesn't
"calculate" until you give it a physical nudge. Any fixes come to mind?
Thanks in advance

 

[Guest]

The checkboxes are part of the data entry form and are used to categorze
personnel by status (Director, Staff, Volunteer, etc.) and form links with
them and the departments with which they are associated. There is
considerable crossover among them.

Selecting "filter by form" and then clicking on one or more grayed-out check
boxes, thereby anointing them as part of the filter is the method I'm using.
Thereupon clicking the "apply filter" icon gets me what I want (everything
but money <G>). The problem was that after doing this, and also after
removing the filter, the concatenated field had to be tabbed to (first tabbed
field) or clicked in to get it to
display properly.

I solved the problem by using a macro I had created for another DB. It's
nothing more than "SendKeys" {Tab} and it works fine. I just wasn't applying
it properly. The macro is applied in the Forms Properties box at the "On
Apply Filter" liine. It's now working.

Thanks very much for your attention to the problem.

BTW, how can I get my forms to close by hitting the ESC key?

--
Norm Shimmel
Butler, PA

I'm not sure how you are using the check boxes (are you checking relevant
boxes, then clicking a command button, or are you using the check box After
Update event, or what), but in any case you should be able to concatenate in
the function or event that is being used to apply the filter.

Thanks for your thoughts, Bruce. The concatenation takes place within the
tabbed form. I've set two special toolbars in place. One to do sorting and
search, the other to do filtering (hiding all other toolbars to keep a
clean
screen), and the filter is applied by form by clicking on check boxes. The
toolbar has all that is needed.

Your suggestion about doing the concatenation in the query might work.
I'll
check that out. Thanks very much.
--
Norm Shimmel
Butler, PA

It's hard to know what to suggest without knowing how you are going about
this (for instance, how are you applying the filter, and how are you
concatenating, and are there two tables involved here), but I have a few
thoughts. You could try concatenating the fields in the form's Current
event, or at the end of the code you use to apply the filter (assuming
you
use code rather than the toolbar buttons to filter the records).
Requerying
may do the trick; I'm not quite sure about that, but it is easy enough to
try. Also, if you are using a query as the form's record source you
could
concatenate in a blank column in query design view:
NewField: [Field1] & [Field2]

On the second of two tabbed forms I'm redisplaying the name by
concatenating
data from two fields from the first form. It works fine until I use a
filter.
After applying a filter, I must click on that field or tab to it to get
it
to
begin displaying that data. Moving to a second record will also start
the
display in that field, and then I can move back to the first record to
view
the data.

I've tried several things incluidng a macro that moves the focus to
that
control "TabToNext", but nothing seems to work. It's like it doesn't
"calculate" until you give it a physical nudge. Any fixes come to mind?
Thanks in advance

 

[Guest]

Bruce, Please ignore the last question on the other reply to your message.
I've discovered how to close the forms using the ESC key. Thanks again for
your help.
--
Norm Shimmel
Butler, PA

I'm not sure how you are using the check boxes (are you checking relevant
boxes, then clicking a command button, or are you using the check box After
Update event, or what), but in any case you should be able to concatenate in
the function or event that is being used to apply the filter.

Thanks for your thoughts, Bruce. The concatenation takes place within the
tabbed form. I've set two special toolbars in place. One to do sorting and
search, the other to do filtering (hiding all other toolbars to keep a
clean
screen), and the filter is applied by form by clicking on check boxes. The
toolbar has all that is needed.

Your suggestion about doing the concatenation in the query might work.
I'll
check that out. Thanks very much.
--
Norm Shimmel
Butler, PA

It's hard to know what to suggest without knowing how you are going about
this (for instance, how are you applying the filter, and how are you
concatenating, and are there two tables involved here), but I have a few
thoughts. You could try concatenating the fields in the form's Current
event, or at the end of the code you use to apply the filter (assuming
you
use code rather than the toolbar buttons to filter the records).
Requerying
may do the trick; I'm not quite sure about that, but it is easy enough to
try. Also, if you are using a query as the form's record source you
could
concatenate in a blank column in query design view:
NewField: [Field1] & [Field2]

On the second of two tabbed forms I'm redisplaying the name by
concatenating
data from two fields from the first form. It works fine until I use a
filter.
After applying a filter, I must click on that field or tab to it to get
it
to
begin displaying that data. Moving to a second record will also start
the
display in that field, and then I can move back to the first record to
view
the data.

I've tried several things incluidng a macro that moves the focus to
that
control "TabToNext", but nothing seems to work. It's like it doesn't
"calculate" until you give it a physical nudge. Any fixes come to mind?
Thanks in advance