Search results

Hmm. Unfortunately, I am still as confused about your table structure as I was at the beginning of this thread. Perhaps it would help if you explained what the purpose of the DB is and then gave some explanation of what each table's data is about. I suspect that the tables have been altered...

I still don't see the need for two Material tables. One table with a column/field for the "Type". Also, why do you have a column/field for the Dealers Name and another for the Product Name? I still feel that the DB needs to be normalized correctly. Could you post a copy of the DB, or at least...

I suspect that your db is not normalized correctly. I would recommend that you sort that out first. Why do you have two tables for Material?

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.

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