Recent content by brucemc777

I responded to a political post and was rejected. i tried to localize and extract the offending words. I simply write "Agreed" and i am rejected. Both post and i am censored. This is a privately run board and i support that you have every right but Isn't that a bit overboard? i can’t...

@The_Doc_Man, CheekyBuddha and Gasman: OK, i finally got to taking a look at the ".Form." confusion i had, and man, do i feel stupid. Thank you very much to directing me to have a look at what the construct was. When i clicked on the container border or the actual form corner, plain as day was...

Uhg. Thank you, once again, "Doc", cheekybuddah, and Yes SIr Glasman! I am starting to get a feel for the model you are describing (i model things in my head to try to understand structure, order and how to manipulate, but i could do so a lot better when i was younger). I am going to read...

Thank you, i apologize for my lack of clarity! I try both ways when i run into any error, omitting .Form. and putting it in. I am absolutely clueless as to when it is proper to use it other than if either including it or omitting it solves a problem. I know that is pretty lame, but i am not sure...

And now i am honored to be able to thank everyone! Properly placing the portion (too many words starting with a "p") of Form.Recordset.RecordCount in the Load event of the Parent form returns a viable value (with modification, actually for two subforms present) that gave me a working solution!!!

Well, i have put the initial verbiage into an image so we can see if that helps: Edit: I had to delete the link you had in your post that was copied over to my response... No, that didn't. I will try deleting part of that which you wrote... Private Sub AmountCharged_Exit(Cancel As Integer)...

So .Form. only comes after a control? As i honestly have no clue, i've just been sticking it in here and there and alternating whether or not i include it by if the compiler or runtime complain!

I turned on my house front monitoring cameras to watch for moving person. Takes up a screen though, but at least i still have another...

Well Hi there The_Doc_Man! Do you do this 24/7??? Parent: frmOrderCreate Child: frmOrderAddEquip Control (textbox that relies upon a record): GrossEquipmentCost other control in child form being used to test: EquipmentRowCount That last one should be renamed EquipmentRecordCount (It's only since...

Many thanks! I have to break away for a while - moving company about to be here to give an estimate (here is some hate speech: I HATE the process of moving), but very much looking forward to working with the info you folks have graciously provided!

OK! So how do i test for that? I was trying to overcome this possibility by including a textbox that would display the record count, but i find that not only if there are no records it, or at least my implementation of it, also is blank and generates the same error. As the Control Sourse for...

Many thanks! Unfortunately btdt. Also throws the "no data" error!

This is correct in that at this point there is no data in the subform, only labels and the like, but how do i test if there is no data? Since other methods throw errors i would expect that IsError would result in True, but it comes back False. I might be implementing wrong as i predominantly...

CECo is declared as Long Yes, we have a parent-child relationship. The parent is frmOrderCreate. The child is frmOrderAddEquip. GrossEquipmentCost is a field in a continuous form that is showing as a record with empty fields because it is the first record to be input for the account. I also...

I have the following assignment in VBA though the Assignment itself probably doesn't matter (GECo is a declared variable. Trying to assign it the value in the textbox GrossEquipmentCost when that value exists) : GECo = Forms!frmOrderCreate!frmOrderAddEquip.Form.GrossEquipmentCost The issue is...