chrisjames25
Registered User.
- Local time
- Today, 07:39
- Joined
- Dec 1, 2014
- Messages
- 401
Hi
I have a form header with a search textbox that as i type filters a listbox to show particular products.
For exmaple if i type 1234 it will bring up batch 1234 and its variety name of "Apple Blossom". Likewise if i type "App" in the txt box it will filter the listbox and only show all batches with a variety that contains the letters App.
All this thanks to your previous help works great.
Query now is:
How to i pass the information form the listbox down to the current record in the detail section of the form. I.e how do i pass the batchNo in the lstbox which is the first column of lstbox into the current record in the Txt_BatchNo of the detail section.
Cheers in advance.
Copied image of form to get idea what trying to achieve. Was thinking of putting the event to make this happen in the doubleclick event.
I have a form header with a search textbox that as i type filters a listbox to show particular products.
For exmaple if i type 1234 it will bring up batch 1234 and its variety name of "Apple Blossom". Likewise if i type "App" in the txt box it will filter the listbox and only show all batches with a variety that contains the letters App.
All this thanks to your previous help works great.
Query now is:
How to i pass the information form the listbox down to the current record in the detail section of the form. I.e how do i pass the batchNo in the lstbox which is the first column of lstbox into the current record in the Txt_BatchNo of the detail section.
Cheers in advance.
Copied image of form to get idea what trying to achieve. Was thinking of putting the event to make this happen in the doubleclick event.