I make forms Orders, based on 2 tables (Vessel and Orders) where in header of forms I have combo box (VesselId),in details section of form is field from Order table,in subform is all Orders for Vessel what is choosen from Combo box in heared of form, so when user select Vessel from combo box, in details of form is Order Form,he enter data in fields and ect,ect .The subform(datashet) show all records(orders) for that Vessel.Now my question is :"how to make when user click on record in subfom same record show in form?
I come on idea to make combo box in footer of Order form by wizard, but combo box is give list of all records.Anybody have maybe beter idea??
Thanks
Fule
I come on idea to make combo box in footer of Order form by wizard, but combo box is give list of all records.Anybody have maybe beter idea??
Thanks
Fule