That would work, though another option would be to use the DataMode argument of OpenForm to open the form for either data entry or edit, as appropriate. That way you only need one form.
I just have one problem with this, you see I have a form that has a function behind it, what it does is allows the users to search for records. The problem I'm having is that when I enter a new record then search for it int he search form I get no resulsts. Help I dont understand why
ALTER FUNCTION [dbo].[SearchByTM]
RETURN ( SELECT dbo.EmployeeGamingLicense.TM#, dbo.EmployeeGamingLicense.LASTNAME, dbo.EmployeeGamingLicense.FIRSTNAME,
dbo.EmployeeGamingLicense.CAT, dbo.EmployeeGamingLicense.JOBTITLE, dbo.EmployeeDocuments.EmployeeDocs,
FROM dbo.EmployeeGamingLicense INNER JOIN
dbo.EmployeeDocuments ON dbo.EmployeeGamingLicense.TM# = dbo.EmployeeDocuments.TM# INNER JOIN
dbo.EmpPics_Table ON dbo.EmployeeGamingLicense.TM# = dbo.EmpPics_Table.TM#
WHERE (dbo.EmployeeGamingLicense.TM# = @Enter_TM# ))
Can you share the solution here so that others might benefit?
sure no problem, what I did is I open up the form in design view then I went to the properties, then the event (ON OPEN) then created a macro with the Open Form Action and at the bottom where it way Action Arguments where it says datamode I choose the add option