Search results

Not working. Created a SubForm instead, working fine, updates when i change record. Not what i wanted, it's ugly, but does the trick for now LOL Thanks for the patience!

Yes sir, I did, that gives me Vessels with all CustomerID's (All vessels actually) I changed my RowSource to this: SELECT [VesselT].[VesselID], [VesselT].[Vessel IMO (Vessel Table)], [VesselT].[Vessel Name], [VesselT].[CustomerID] FROM VesselT WHERE [VesselT].[CustomerID] =...

I removed the ControlSource for the ListBox and updated RowSource: Maybe i explained it wrong initially. My form for CustomerF, should list all corresponding ships that has same CustomerID in VesselT. After saving and closing all, CustomerF Openscustomer with CustomerID = 1, and ListBox lists...

Thanks for your inputs CheekyB :) Changed my Where Clause: Did not solve. Bound Column said "1" - Should that be CustomerID form VesselT? Both Tables attached

Hello all, Complete noob here :) I have a CustomerT and VesselT with customers and ships, combined through Customer ID in both tables. In CustomerF, i have a Listbox as shown. It populates with Vessel's that have the corresponding CustomerID's as the CustomerID in CustomerT. If I change from...