Search results

Ahh yes I get it :banghead: so it's the same as a remote procedure call or jump function . . that fit's in with your answer to my previous question/post. If only I could remember more from my COBOL days :confused: Cheers D

Hello all. Just a quick question . . . Is there a correct / preferred way of opening one form from another and then going back to the original form ? Should it be: DoCmd.OpenForm "new form name" DoCmd.Close acForm, "original form name" or DoCmd.Close acForm, "original form name"...

Holly bat doodar that did it !!! Thank you sooooo much Bob. Just going to take a moment or two to work out the logic of why that works that way !! Next job is to add data entry validation and null detection to all my input forms. Reading about IF, is null and nz commands right now. Thanks...

Eek ... Sorry Bob you lost me there, we may have a crossed wire here, which is most likely of my doing :) I'm not sure what you mean when you talk about the combo boxes, as they are working correctly, it's when all the fields on the data entry form are filled out and I press save and exit, the...

Hi Bob, No the user does not need to go back to the main form until the data entry is completed. I just have the data entry form popping up over the top of the main form, so when that closes the main form is still there. Cheers D.

Hi RainLover (btw if you like rain that much you should move to the UK :D ) Yes sorry my first post is sort of irrelevant now as I have ditched that approach as I realised that it was the wrong way to go about it even though the reason I tried doing it that way was because I couldn't get the...

OK so realising that this is not the best way of going about adding a new record, I have changed things back to how I had them first which is: My "Add a New Item" button on the main form opens up the "addperform" which now has the record source set to the Peripherals table, and all of the combo...

Thanks for the reply JHB, but that didn't make any difference ! Same error. The odd thing that I have just noticed is that when I re-type that whole line in, Access auto-corrects the subform name i.e. PeripheralsSubForm.Form! but not the first part: Forms!peripheralsViewForm! which should...

Hello all, I am pretty much a beginner in Access, although I did create a few basic databases with access 97 a long time back ! I am trying to create a database to manage IT assets, most of the structure is done, I'm now trying to get the details done. The issue I am currently trying to tackle...