Recent content by bob fitz

I've been busy, so I haven't been here much of late, but I don't appear to have any problems :). Yet;).

Perhaps: =DSum("Covers","tbl_Net_RestaurantBookings",MyToday("CheckIn") And ([Status] Is Null))

Hello Alan. Welcome to the forum :):)

Merry Christmas everybody 🎄

Try the following line of code in the After Update event of the combo: DoCmd.GoToControl "[NameOfYourControl]"

I'm using Office Professional 2019 (32 bit)

I have tried the OP's code on a later version of Access, and it works without any issues. Could corruption of the control or form be the cause of the problem?

Are you sure the error code is 348 ? Which line of your code causes the error ?

It would be helpful if you could also post the backend database file.

Perhaps there hasn't been any ;)

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.