Search results

Not to hard to do, in the Got Focus event of the control add: Me.YourControlName.Requery If you don't want to store the results of the query, use a unbound control. hth.

Don't get me wrong Pat, I appreciate the help and I think I understand what you are saying. I do have to running now and almost exactly what I was trying to do, but doing it in two different events for two different forms. I was only tring to understand the why for my own education. I kind of...

I think I got it working now. Changed where it ran in the subform to GotFocus of the next control. Appears to work fairly well there. I would like to know why it works great on the main form in the OnExit, but not in the subform? That is nuts, I would assume that it would work the same in...

I don't mind giving you a copy of the whole thing, there is nothing sensitive in it it is a QC dbase. The problem is it is large, from code, about 5.12 Kb compressed, and it has ODBC connections to our sever and our business system. It acts flacky when I delete them. Please advise if you...

I tried a dozen different times and ways with the form's BeforeUpDate event, I tried with Me and with Forms.FormName.ControlName. I tried from a function also and always got the same results, I would tabe into one of the manditory controls and tab right out of it and on into the automatic...

Thank you for the response. I am running these procedures before the form is completed and the four or so controls MUST have data in them. There lies the problem, before the form is finished or the record is complete.

Thank you for responding, again. yes I did read it and I retried it and in the form's Before UPDate event it does not work, with or without full references. The OnExit is was talking about is the control's OnExit event. Right now I have it so the main form works with the OnExit procedure and...

Thank you again for the response, Pat. I have tried it in the Form' BeforeUpDate with and without full reference names. I have tried it everywhere and every way imaginable. On the main form, using the OnExit, as above, it works great. But in the subform it does not, that is the strange part...

Thank you for the response. I have already tried it in the Form's BeforeUpDate event and nothing. This works great on the main form, it is only the subform that is giving me problems. It is the tabstops on the subform, I think. Why it works on the main form and not the subformis what has me...

I have a form with a subform and on the form and also on the subform, I have three comboboxes or txtboxes and in the OnExit event I have a little procedure which makes sure that each have been filled in or it asks if you want to cancell and if yes, it setfocus on the cmdCancell and then I can...

I will attach something that I started with and now I have it runing outside the form and now it even opens the form and goes to the selected record. But do your self a favor start inside and open it with a cmdButton. hth.

You were asking for help on a form. A form, like Ruralguy said, is for creating, modifing, view and deleting records in a table. Now what you are saying sound more like a report, which will be based on a query and grouped by the query. So a this point in time, just decide what you want the...

This is a little vague on what this form is for, so I will assume somethings. The main form, I would make the Vehicle data and then I would have three tab controls, each with a subform on them, VehicleTire, VehicleCheck and TireCheck. Now you could also use three cmdButtons, each opening a...

I have used this from a pop-up with a find in it and with you click the item in the hi-lited column it puts that item into the txbox. If that is what you are trying to do try something like: If SysCmd(acSysCmdGetObjectState, ACForm, "FormName") Then Forms("FormName")("SubFormName if...

Sure, Access Help, InputMasks.

Yes, input masks will probably do the trick for you, try using something like: 90.99\%;0;_ If you chage the 9 to 0 then that will force everything to print. Of course you will have to modify it to fit your needs.

Thank you for the response. That was interesting, but not good at all. It started going into all the OnCurrent settings I have on the form. These were main the subform settings, if that is important. I use the main forms OnCurrent event to make a lot of things visible and invisible depending...

Try it just on a label of a txtbox using the GotFocus and LostFocus events of that txtbox. This is to see if 2003 supports it, 2000 does and I use it all of the time.

Thanks, I just discovered this a couple of days ago and I have tried everything that I can think of and nothing has worked yet, it is a real ________.

I tried it and the same thing happens, first time it works great and the second, no message or anything. It is like it does not reset after it is triggered once. If it was a query, I would just requery the dang thing. Any other thoughts? Thank you again for the help.