Hello again, yet another problem in my ICT project...
I have a booking out form that has a few subforms in it, one of these subforms shows what the customer purchases, at the moment you must type in the item Code to bring up the item.
The other subform is the items table showing all the items available to purchase:
a) Is there a way of having a text box above the subform that will position the record selector in the subform to the nearest matching item (i.e. when "cop" is entered, "Copper Pipe" will be selected)
b) Secondly, how would i create a way so that when the item in the subform is double-clicked it is inserted as a new purchase in the purchase subform.
I appreciate any help
I have a booking out form that has a few subforms in it, one of these subforms shows what the customer purchases, at the moment you must type in the item Code to bring up the item.
The other subform is the items table showing all the items available to purchase:
a) Is there a way of having a text box above the subform that will position the record selector in the subform to the nearest matching item (i.e. when "cop" is entered, "Copper Pipe" will be selected)
b) Secondly, how would i create a way so that when the item in the subform is double-clicked it is inserted as a new purchase in the purchase subform.
I appreciate any help
