B
brownti via AccessMonster.com
I am running into a problem using a query based form. this might not be the
ideal way of doing things and i am open to other suggestions but here is what
i have going on. First i am using Allen Browne's FindAsYouType Utility so
search on a continuous form. The control source of this form is a query that
links 8 tables. Here is the SQL of that query:
SELECT tblDoors.DoorID, tblDoorWidth.DoorWidth, tblDoorHeight.DoorHeight,
tblDoors.PanelConfig, tblPanelType.PanelType, tblDoorThickness.DoorThickness,
tblSlabType.SlabType, tblVendors.VendorName, tblSpecies.Species, tblDoors.
BidPrice
FROM tblDoorHeight INNER JOIN (tblSpecies INNER JOIN (tblSlabType INNER JOIN
(tblPanelType INNER JOIN (tblDoorThickness INNER JOIN (tblDoorWidth INNER
JOIN (tblVendors INNER JOIN tblDoors ON tblVendors.VendorID = tblDoors.
VendorID) ON tblDoorWidth.WidthID = tblDoors.WidthID) ON tblDoorThickness.
ThicknessID = tblDoors.ThicknessID) ON tblPanelType.PanelTypeID = tblDoors.
PanelTypeID) ON tblSlabType.SlabTypeID = tblDoors.SlabTypeID) ON tblSpecies.
SpeciesID = tblDoors.SpeciesID) ON tblDoorHeight.HeightID = tblDoors.
HeightID;
I have everything working except that i would like to be able to change
BidPrice on the form. I think i need to do this with an unbound box...but
i'm not sure. i cant base the form on the table and then use unbound boxes
because of the search control that i am using...
ideal way of doing things and i am open to other suggestions but here is what
i have going on. First i am using Allen Browne's FindAsYouType Utility so
search on a continuous form. The control source of this form is a query that
links 8 tables. Here is the SQL of that query:
SELECT tblDoors.DoorID, tblDoorWidth.DoorWidth, tblDoorHeight.DoorHeight,
tblDoors.PanelConfig, tblPanelType.PanelType, tblDoorThickness.DoorThickness,
tblSlabType.SlabType, tblVendors.VendorName, tblSpecies.Species, tblDoors.
BidPrice
FROM tblDoorHeight INNER JOIN (tblSpecies INNER JOIN (tblSlabType INNER JOIN
(tblPanelType INNER JOIN (tblDoorThickness INNER JOIN (tblDoorWidth INNER
JOIN (tblVendors INNER JOIN tblDoors ON tblVendors.VendorID = tblDoors.
VendorID) ON tblDoorWidth.WidthID = tblDoors.WidthID) ON tblDoorThickness.
ThicknessID = tblDoors.ThicknessID) ON tblPanelType.PanelTypeID = tblDoors.
PanelTypeID) ON tblSlabType.SlabTypeID = tblDoors.SlabTypeID) ON tblSpecies.
SpeciesID = tblDoors.SpeciesID) ON tblDoorHeight.HeightID = tblDoors.
HeightID;
I have everything working except that i would like to be able to change
BidPrice on the form. I think i need to do this with an unbound box...but
i'm not sure. i cant base the form on the table and then use unbound boxes
because of the search control that i am using...