With the help of EE the form “frmTools” is finally working it sees the three tables as I need it to.
I was hoping to use the SQL code from form “frmToolsLookUpDimensional
” to make it so the form “frmTools’ would only see Dimensional tools.
I have looked for a “Row Source” in the data tab of the properties box but don’t see one. Why is this “Row Source” not in this form?
Here is the SQL code:
SELECT tblTools.Tool_PK, tblTools.ToolName, tblTools.TypeOfDevice, tblTools.Location, tblTools.Brand, tblTools.[Code_#], tblTools.[Model_#], tblTools.[Serial_#], tblTools.InUse, tblTools.Inventory, tblTools.OutOfService FROM tblTools WHERE (((tblTools.TypeOfDevice)=
This could also be used in the field “TypeOfDevice” but I don’t see a Row Source on the Data Tab in the properties box.
Any idea on how to do this??
I have six other tables to do this with and I almost have a working example to use on the other tables.