OK, here is what I want to do....have a combobox that only displays records on a table where field = 0..... got that.....now I want to be able to click on record in combobox and have it open up the form to that specific record.....
So far I have combobox with...
SELECT tblLoad.LoadID, tblLoad.LoadDate, tblLoad.AutoclaveID, tblLoad.LoadNumber, tblLoad.[Cycle Complete] FROM tblLoad WHERE (((tblLoad.[Cycle Complete])=0));
Bound Column is 1
This works to limit records shown in combbox....yea!
Now I can't figure out how to open form to that particular record.....have tried several things in afterupdate of combobox....but no luck
Any help would be appreciated.
Kevin