Search results

Leif As you liked the example query, I've attached a copy of the db with an example of how it might be done on a form (frmPickMedisMain)

As I've already said, I don't think you should be keeping the same data in more than one table, but rather use a query to retrieve the relevant data. Take a look at "qryPickMedia" in the attached. You could use a similar query as the Record Source of a form and use a combo on that form to...

Can you at least tell us which form we need to look at.

Have you tried to "Zip" the file

Not sure that it would be a good idea to have the media data in both tables. I'd have thought that you could use a query to tell you in which media you have a particular song. Can you post a copy of the db for us to play with.

I believe the calculations are achieved by using expressions in the Control Source property of the controls (text boxes).

Welcome to the forum :) Can you post a copy of the db and tell us something about its purpose.

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]