Text Box not reflecting Label.caption

[southboy]

I have a text box that shows the forms list box record count using this code in the text box control source.
=Count(*) & " " & "Total Records"
and the text box shows "76 Total Records"

I also have a label box at the top of the form telling you the name of the current table you are looking at. There are several tables you can access and this forms label.caption changes to the table name and the form displays all the associated records in the list box for that table.

I would like the labels caption to show at the end of the text box code so it would look like this
76 Total Records for Notes Table.

76 being the forms list box record count and "Notes" being the forms label box caption.
I have tried several ways to get the label.caption at the end of the textbox record count but can't make it work.

Can someone help please.

 

[Shirley]

Why did you not concatenate the table in the same text box that you are using. For Example#

=Count(*) & " " & "Total Records from"&" " &[TableName]

This way you would not need a label.

 

[TheAceMan1]

How are ya southboy . . .

[blue]I have a text box that shows the forms list box record count using this code in the text box control source.
[purple]=Count(*) & " " & "Total Records"[/purple][/blue]

See Ya! . . . . . .

 

[southboy]

Shirley,
Thanks for responding so quickly. I did a bad job of explaining the table thing, and I apologize for that. There is actually only one table with 25 keywords attached to over 1200 notes. Think of the table like windows explorer with folders and files all in one table. "Notes" is the name of one of the table "folders" and all it's "files" are what is listed in the list box of the form and the name "Notes" (the name of the "folder") is what the label.caption is displaying.

On a menu form combo list box, I click which "folder" I want to display and another form opens with a list box displaying all the "files" associated with just that one "folder". And at the top of this form is a label stating which "folder" is being displayed. The "folder" name is what I want to also show after the record count.

So the text box counts the number of files listed in the list box for the folder and I would like to display the folder name with the count like "76 Total Records for Notes".
I hope I’ve explained myself better.
Any Suggestions?

 

[TheAceMan1]

southboy . . .

You may not think its necessary, but have a look at the following at your leisure!

Fundamentals of Relational Database Design

Normalizing Tables

Table Relationships

To be sure . . . these links are the heart & soul of ad DB and determine how easy/hard programming will be!

Your Thoughts? . . .

See Ya! . . . . . .

 

[southboy]

Thank you TheAceMan1 for the articles and I agree that this database could be designed better. It started out a few years ago as a simple way to keep my work notes and has grown into a repository of information, notes and my thoughts.
But it works great for what I created it for and when It gets too big and cumbersome I will definitely redesign it with more architectural structure and flow process.
Keep up the great work that you and all the Tek-tipsters do! This forum has helped me tremendously so far!
But I still need help with this one problem.
Any suggestions?

 

[randy700]

And at the top of this form is a label stating which "folder" is being displayed.

So, what is the code that you use to display the folder name here? Why not utilize the same code to...
1. Concatenate to the end of the text box as suggested by Shirley.
2. Display in a separate list box as you suggested.


Randy