Recent content by DirtDiverKF

yeah thats what i did, just added lines to it, worked ok, thanks again for your help. I will be posting another question tonight i believe, about how to take my equipment list and my donated equipment list and do a report / query that tells me which equipment i have here not donated yet, so if...

found in another forum to add a go to control macro and go to another field on my form, then do a set value on the combo box to "", seems to work, anyone know if this will create issues or not, thanks again.

well maybe not, problem is on change, the stupid thing clears out everytime i try to type in it hehehe, i guess i need to build a macro to set the value to 0, any tips on how to do this, thanks.

nevermind, i found it, onChange will do it, thanks again

on the combo box, it has a macro built in to it, where do you add the me.cmb = "" code? I cant add it to the after update cause of the macro, so where else can i put that to work? Thank you again

Thank you for the quick reply, what do you mean current event? How do i apply current event to the combo box? Blanking it is fine to, would you just do a me!ComboBox"" or something in vba for the combo?

Same issue i am having except not with sql on line, just in access

Hi guys, I have a form whose record set is a query. On the form i have a unbound combo box that drives the record for the form. This all works well except after i edit the record and save it, if i hit refresh the record goes to the first record in the table and the combo stays where its at...

actually in the macro under data mode if you change it to add it clears the form, sweet. thanks man, this was a huge help. Ill post any other issues i come across as I go, thank you a million times over.

Forms!FormName!ComboBoxName.Requery Worked like a charm on that, on the open form, whats the simple vba code to open a form, etc. Right now im just using a macro button and I do not see how to tell that macro to do a empty record. Thanks a ton for the help, that requery worked like a charm.

Hi everyone, I have ran into a couple of issues that I could use some help with. First is easy, second maybe not so. I hope this attachment works! The zip above contains 3 images to help show the issue I am having. The database I am working on is for holding local gaming tournaments on...

Hi everyone, my name is Donnie Walker, I am the Director of a new charity that involves the gaming industry and helping childrens hospitals and foster homes. I will not post links here as I do not want everyone to feel I am here to promote our site. If interested in learning just message me...