Unbound textbox with query based form

  • Thread starter brownti via AccessMonster.com
  • Start date
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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top