Recent content by bob fitz

Try this:

I would change the name of Text25 to something that has some meaning E.g. txtInvTotal

try: =[CreditInvoices_Subform].[Form]![Text25]

Perhaps the same expression that you have used in the Footer would work in the Header =Sum([BillAmount])

I remember there was once a British Prime Minister who tried to negotiate with a person who, IMHO, had similar traits to those of Putin. He returned, waving a piece of paper declaring "Peace in our time". Have the most powerful people in the world learnt nothing from history? God help us all.

Welcome to the forum Nelson:)

Hopefully, the OP will let us know ;)

Not sure that I've understood the requirement correctly but perhaps: MsgBox Len(Me.ActiveControl.Text) in the On Change event of a textbox control.

Thread Tools, top right of thread. Mark as Solved

I'm glad that you have a satisfactory answer to your enquiry. Please flag the thread as Solved.

Have you considered using the DCount() function in an IF/Else/Then and only doing the requery IF DCount returns >0 Untested: If DCount("TitleName","FullList2","TitleName Like "*" & Me.Text74 & "*")>0 Then DoCmd.Requery EndIf

Davebert Can you post a copy of what you have so far and perhaps tell us something about the database you want to create.

Sorry, I didn't notice that the question was in the Excel forum :sleep:

Set the Indexed property of column A to: Yes (No Duplicates) in the table properties.

The combo boxes from which you choose players' names need to be bound to a Recordsource so that the selection is saved somewhere. I've noticed a few of other things that you should perhaps look at; Some of your tables have no PK You have Lookups in tables. You have repeating data in tables e.g...