Search results

Here you go, Chaps. I've stripped it down to the bare necessities. Again, I appreciate your time and help.

Darn, it didn't work..

If you click on the 'maintenance form' tab on the 'table of contents' and go to the bottom of the form to the floppy disk icon that saves record, this is where I placed the code behind (on-click). I doubt I will be successful in sending the DB because it exceeds the size limitation but I will...

yes I changed it to serial_no in all places....., it keeps coming back with not being able to find the field 'sbfmACTVHIST' in the expression. sbfmACTVHIST is my subform.

The Main form

Got rid of the # - and I still get the same error. Thanks for your patience.

I tried what you suggested but I get the error 'MS Access can't find the field 'sbfmACTVHIST' referred to in your expression'. This is what I put as far as code goes Forms!MAINTENANCE!sbfmACTVHIST!SIGN#.Setfocus Me.MP.Setfocus What did I do wrong???

Thank you Andy, your a gem!

I have a form with a subform. When I add a record to the subform I have to scroll to the right to continue to add to the fields (because it's wide). After I click my save button the form clears so I can go to the next record to add - but my problem is that my subform clears but it is stuck at...

This is very confusing and hope I make sense in my explaination........... I have a database that uses 2 forms and a subform. The first form and subform is used for viewing purposes only, but the way I get to the record that I want is that I've created a control text box where you type in or...

Rob, the "IsNull" doesn't seem to be working, there aren't any resurlts when it is used (in both queries). There are many pass/fail's and yes/no's that populate the 2 fields. How would I do the 3rd query and would I use that query when creating my report? Thanks.

I can't seem to get this question answered..... so here goes ............ If I have a query, and If I have two seperate fields unrelated to each other in the same table and I want to select all the records that populate one field with 'Fail' and select all the records in the other field with...

When I click to open my form, how can I only have the records that are populated as 'southwest' in the QUAD field (of my table) show up in my form? Would I use the expression builder (under the QUAD control) under the data tab under the default value? How would I fill out the expression...

If someone could be so kind as to helping me with a problem I am having. Here is my situation: I have one complete table and I would like to have 2 combo boxes on my form (for searching purposes). The first combo would have a dropdown of road names and when one is chosen, the second combo box...