Search results

thanks,

I am making search form as under 1. added text box named @ txtSearch 2. added find button named @ btnSearch 3. added list box named @Searchlistbox1 I am using the following code to show record in the list box as per the text box. Private Sub btnSearch_Click() Dim sql As String sql =...

DynamicList.ListIndex=0 'Current stock DynamicList.ListIndex=1 'Received DynamicList.ListIndex=2' Transferred and so on... This is correct, suggest please

Thanks Carletto, what about the transfer case solution, open Navigation form, click on Inventory Management, then click in list box 1st - Transferred, it will show the related records in 2nd list box, double click on any record, it's opening on 1st record but not going on the specified record...

Is it possible to make it short through loop from case 1 to onward as there is only difference in each case TranTypeFK.

What about the filter solution in transfer case

I have attached the database for the solution of transfer case filter not working on double click DynamicList1.

DynamicList is listbox1, DynamicList1 is listbox2

I have resolved the blank form issue but now it's opening on 1st record and not going on specific record (not filtering the record) in the transfer case. The code which I am using in the main form is as under Case "Transfer" 'Transfer lblForm.Caption = "Transfer"...

Yes, It's giving the accurate results.

I am using two list boxes. On click in listbox1 value the data is shown in listbox2 as per the selection in listbox1. on double click in listbox2, as per the selection the specific record should have to open. Private Sub DynamicList1_DblClick(Cancel As Integer) DoCmd.OpenForm...

thanks a lot Maj. 🌹 🌹 🌹

Now I am facing another problem, I have made a search form to go on a specific record through list box. It's working but option group is missing.

thanks a lot Maj, 🌹🌹🌹 done and resolved, the shortest way for all cases, so not required to write in all cases separately.

Thanks Maj, i have tried but could not implemented because lack of proper information and study.

Is there any way like as under If Frame.Enabled = True then Frame.Value > 2 The frame value greater than 2 for case "Receipt" should be false. But how to do

thanks @MajP, I have not tried before tag property. I try it, if there is any reading article then let me know please.

I am already doing like this but i have 6 values so want to make short

I have an option group as under Frame1: Received Returned to supplier Stock Transfer Transfer Return Expired / Damaged Inventory Adjustments with values 1 to 6, I have three case statements working as under as an open args Receipt Transfer Adjustments =============== I want one line code...

I have got the mistake, I was using .rowsource in place of .listindex, I have resolved the error afer reading the articles as under; ListIndex: https://learn.microsoft.com/en-us/office/vba/api/access.listbox.listindex Rowsource...