Hi guys....im really quite stuck now.
Original Problem: Cascading Combos on continuous forms. Changing value of combos changes all combos on form (although underlying data is not changed)
Original Solution: Created unbound combo boxes on form header. Used the following code to add a new record based on the final combo selection:
New Problem: The original "solution" means the user can easily select the correct software package. A new record is created on the continuous form based on their selection.
However, as only the software_package_Edition_ID is transferred (and subsequently stored) I would like to have a text box that shows for each record on the continuous form the Manufacturer, Software Package & Software Package Edition.
My Attempts: I can do a Dlookup to show the Software Package Edition Name:
But this can only look for one of the required fields in only one table.
The following SQL works as a separate query:
But I am not sure how I can get the results for the three fields on this query (manufacturer, package, package edition) into a text box on the form.
I had tried using the above SQL as a record source for a combo and then using: me.textbox = me.combo.columns(x)
but as it is a cont. form, this does not work.
Would really appreciate some help with this.
Thanks
BF
Original Problem: Cascading Combos on continuous forms. Changing value of combos changes all combos on form (although underlying data is not changed)
Original Solution: Created unbound combo boxes on form header. Used the following code to add a new record based on the final combo selection:
Code:
If Not IsNull(Me.CboSoftwarePackageEdition) Then
DoCmd.GoToRecord , , acNewRec 'create new record
Me.Software_Package_Edition = Me.CboSoftwarePackageEdition 'where software package edition = selected combo selection
CmdResetCbo_Click 'uses the reset sub to clear all combos
End IfNew Problem: The original "solution" means the user can easily select the correct software package. A new record is created on the continuous form based on their selection.
However, as only the software_package_Edition_ID is transferred (and subsequently stored) I would like to have a text box that shows for each record on the continuous form the Manufacturer, Software Package & Software Package Edition.
My Attempts: I can do a Dlookup to show the Software Package Edition Name:
Code:
strSoftwareEdition = DLookup("[Software_Package_Edition]", "TblSoftwareDetail", "[Software_Detail_ID] = [Forms]![Form1]![Software_Package_Edition]")But this can only look for one of the required fields in only one table.
The following SQL works as a separate query:
Code:
SELECT TblProductManufacturer.Manufacturer_Name, TblProductSoftware.Software_Package_Name, TblSoftwareDetail.Software_Package_Edition
FROM (TblProductManufacturer INNER JOIN TblProductSoftware ON TblProductManufacturer.Product_Manufacturer_ID=TblProductSoftware.Product_Manufacturer_ID) INNER JOIN TblSoftwareDetail ON TblProductSoftware.Product_Software_ID=TblSoftwareDetail.Product_Software_ID
WHERE (((TblSoftwareDetail.Software_Detail_ID)=Forms!Form1!Software_Package_Edition));But I am not sure how I can get the results for the three fields on this query (manufacturer, package, package edition) into a text box on the form.
I had tried using the above SQL as a record source for a combo and then using: me.textbox = me.combo.columns(x)
but as it is a cont. form, this does not work.
Would really appreciate some help with this.
Thanks
BF