Search results

What do you mean by dirtying the record? On the first field of each subform I have an "On Exit" event If IsNull(Me.EventCategory) Then Me.Parent.[frmeventCsubform].SetFocus End If I have this so that when I tab through a subform when I am done entering it will tab to the next subform. The...

I have a main form with many subforms. The sub forms are all continuous but one and I want the editors to be able to put in more then one record if needed. My problem is I have my tabs set up so that when the box is empty it will tab to the next subform. When I do this, a extra blank record...

If understand correctly, I think that you need to make a combo box that you can select either driver, subout driver or subout company and a combo box below it that lists all the different information for driver, subout driver and subout company when you click that particular selection from the...

Create your main form using the main table (Job Table) and select the fields that you want in that form. Then create subforms underneath the main form for your Customers and Drivers. Use your control wizard and select the subforms button from the toolbar and it will guide you through it (which...

Yes, this is what I just accomplished. I have a main form and several subforms that are linked together by the "EventID" in the main form. On the first control of each subform put the following code on the "on exit" event function and if the control is blank it will tab to the next subform. If...

That worked liked a charm. Thanks a lot for your help. I am on my last subform which is a single form and when I tab off of the last text box I would like it to go to a command button on my main form. Do you know how I would do this? Thanks again in advance.

I put this code on the On Current Event of each subform and it didn't work. Maybe I don't understand properly. Can you explain further? Sorry

I have search the forum and have found many solutions to this same problem but so far none have worked for me. I am fairly new to Access so maybe I am just not understanding properly. I have a form with a main form and many subforms. All subforms but one are continuous and the other is a...