Recent content by bob fitz

Welcome to the forum :)

Such sad news. R I P

Hi Doozer Welcome to the forum :)

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]"