Recent content by boomslanger

Thanks for keeping up on this. Yes I got it working using this simple solution as the Control Source: =DCount("*","tbl_Assets","[Asset]='" & [Asset] & "'") Have another requirement I was going to raise later but might as well give a heads up now. Each Asset in the Asset Management Form can...

=DCount("*","tbl_Assets","[Asset]='" & [Asset] & "'") That code did working perfectly for just one afternoon. I had saved the form and did nothing else but close Access for the day. I come in this morning to start work, open the database and get the Name? error in the control box for that...

Thanks datAdrenaline, that was perfect.

Thanks, I'll try that next week. As luck would have it just when I get to play with the database I have to go on the road for a bit. I'll let you all know how I go when I get back from my road trip.

Thanks Core for pointing me to khawar's solution. I'll now try to stumble my way through how to do it. I know next to nothing on vba and am just starting to find my way around Access after not using it for more than a decade. This will be a good learning start point.

Access 2007 (12.0.6423.1000) MSO (12.0.6425.1000) Can anybody help with what must be a simple thing to implement and maybe in common use? I have a database that tracks a whole bunch of different company assets under management. What I need in the form is the total for any one asset type when...

Thanks John, I'm on the case I think. Not that clued-up on Access and was hoping it wouldn't become as complicated as it has. Also haven't got that much more time to spend on this as management are already making noises about the time I'm spending on it whilst other things are pending. I'll...

Not making any difference, except the WHERE clause gets changed to: WHERE [Asset]=Forms!frm_AssetsUnderMan!Asset The square brackets are removed for some reason.

Thanks for persisting with this jj. The SQL is: SELECT * FROM tbl_Assets WHERE ((([Forms]![frm_AssetsUnderMan]![Asset])=[Asset])) ORDER BY tbl_Assets.Asset DESC; I do notice the control box briefly blink every now and again as though an update is taking place, but unless the focus is on the...

Really appreciate your help so far, and I continue to experiment. Ta John.

Ok no errors but the same problem. Unless that box has the focus then the total is not displayed when you move onto the next record.

Access 2007 OK but there is no OnCurrent event under that tab for the control though there is an On Current under the event tab for the Form property sheet. I tried it there and got an error.

Sorry for my ignorance. I cannot find where to do that. The name of the form is frm_AssetsUnderMan The name of the control (unbound text box) is cmd_TotalAsset Where do I put in the Me!myControl.Recalc?

I have this straightforward DCount control in Control Source that shows the number of Assets. =DCount("Asset","AssetListFilter") AssetListFilter is a Query. Problem I'm having on the form is the count is not shown until I click on the control, then when I move to to then next record it goes...

Thanks heaps, I think that is what I want. I looked at the Where clause but was uncertain as to how to implement it. Category, which is one of the user selections, is a combobox but I think I have enough to work it out now. Regards.