Hello Micron.
I will follow your suggestions soon and get back to you with both of the things you requested. I can give you the SQL that is behind the form though currently. I just want to update everybody on this thread that with the link source option in the wizard, I am able to successfully input data with merely just a table. I've also tried a suggestion to just import the data to Access , instead of linking it. If I do not link it, I can use the form wizard for multiple tables. These are some things I've tried so far. Micron, part of what you want should be below. If it isn't what you want, please let me know and I'll get back to you. Thanks!
Code:
SELECT [C##LAMBERT_JOB].[JOBNO], [C##LAMBERT_DEVELOPMENT].[DEVNAME],
> [C##LAMBERT_CLIENT].[CLIENTCOMPANY], [C##LAMBERT_CLIENT].[CLIENTREQUESTER],
> [C##LAMBERT_JOB].[DATESCHEDULED], [C##LAMBERT_DEVELOPMENT].[DEVLOCATION],
> [C##LAMBERT_DEVELOPMENT].[DEVRANGE], [C##LAMBERT_DEVELOPMENT].[DEVSECTION],
> [C##LAMBERT_DEVELOPMENT].[DEVTOWNSHIP], [C##LAMBERT_JOB].[JOBRESTAKE],
> [C##LAMBERT_CREW].[CREWNO], [C##LAMBERT_JOB].[JOBWORKDATE],
> [C##LAMBERT_CREW].[NOTES] FROM ([C##LAMBERT_CLIENT] INNER JOIN
> ((([C##LAMBERT_DEVELOPMENT] INNER JOIN [C##LAMBERT_TASKS] ON
> [C##LAMBERT_DEVELOPMENT].[DEVNAME] =[C##LAMBERT_TASKS].[DEVNAME]) INNER
> JOIN [C##LAMBERT_EMPLOYEE] ON [C##LAMBERT_TASKS].[TASKNO]
> =[C##LAMBERT_EMPLOYEE].[TASKNO]) INNER JOIN [C##LAMBERT_CREW] ON
> [C##LAMBERT_EMPLOYEE].[EMPNO] =[C##LAMBERT_CREW].[EMPNO]) ON
> [C##LAMBERT_CLIENT].[CLIENTNO] =[C##LAMBERT_DEVELOPMENT].[CLIENTNO]) INNER
> JOIN [C##LAMBERT_JOB] ON [C##LAMBERT_CLIENT].[CLIENTNO]
> =[C##LAMBERT_JOB].[CLIENTNO];
Edit: Micron, do you mean the SQL of the Control Source? Or are you referring to something different?