RobertIngles
Technical User
I have a control on my switchboard that activates a user input parameter query - popup asks the user to enter the parameter value. If the user input parameter value matches the associated record in the TBLLaptop the related form opens with the information in edit mode however if there is no match then Access returns a blank screen. On a parameter mismatch I would like the form to open in add mode and I think I need to run a
DoCmd.OpenForm "FRMCreateNewLaptopUseProfile", , , , acFormAdd
but I have no idea where to place the code when using a popup parameter request. Do I need to use a sql statement to accomplish my goal? If so, maybe someone could give me an example of the code or let me know what to search for as I have no experience with sql.
Thanks
DoCmd.OpenForm "FRMCreateNewLaptopUseProfile", , , , acFormAdd
but I have no idea where to place the code when using a popup parameter request. Do I need to use a sql statement to accomplish my goal? If so, maybe someone could give me an example of the code or let me know what to search for as I have no experience with sql.
Thanks