Show Record Count

[mikej2505]

Hello All....I created a database for my organization and have a Menu which contains links to forms for 10 teams within my organization. When you go into the forms, you can see the record navigator at the bottom of the form and it shows number of pending requests within that form.

Is there a way to dispay a small "bubble" or "Count box" outside of the form on the menu that shows all Team Forms so that when a user goes into the form it would show that there are request pending without actually having to go into the form to check?

Here is an example of what I am trying to do:

[burrina]

You can use a DLookup function for this.
Example:

Me.SomeTextBox = DLookUp("[SomeField]","SomeTable")

HTH

[rpeare]

if you want to get fancy you can add something like (x pending) to the button itself to make it more visible likely you won't be using dlookup though but a dcount function with a criteria like:

dcount("*", "tablename", "[Team] = 'Team1' and [Pending] = True")

Assuming all your data is on the same table and the team is indicated somehow on that table and you have a way of defining what a 'pending' record is.