Warehouse Inventory Project

[MajP]

example

     Case "Receipt"
            With Me
                .lblReceipt.Visible = True
                .lblTransfer.Visible = False
                .lblAdjustment.Visible = False
                .EntityFK.Visible = False
                .EntityFK_Label.Visible = False
                .VendorsFK.Visible = True
                .VendorsFK_Label.Visible = True
                .TranTypeFK.RowSource = "SELECT TranTypePK, TranType from tblTranTypes WHERE TranTypePK<=2"
                .TranTypeFK.ColumnCount = 2
                .TranTypeFK.ColumnWidths = "0;1cm"
                .TranTypeFK.DefaultValue = 1
            End With

probably need something like
.Recordsource = "Select * from tblTransactionMain where transTypePK <=2"

 

[ahmad_rmh]

example

     Case "Receipt"
            With Me
                .lblReceipt.Visible = True
                .lblTransfer.Visible = False
                .lblAdjustment.Visible = False
                .EntityFK.Visible = False
                .EntityFK_Label.Visible = False
                .VendorsFK.Visible = True
                .VendorsFK_Label.Visible = True
                .TranTypeFK.RowSource = "SELECT TranTypePK, TranType from tblTranTypes WHERE TranTypePK<=2"
                .TranTypeFK.ColumnCount = 2
                .TranTypeFK.ColumnWidths = "0;1cm"
                .TranTypeFK.DefaultValue = 1
            End With

probably need something like
.Recordsource = "Select * from tblTransactionMain where transTypePK <=2"

.Recordsource = "Select * from tblTransactionsMain where TranTypeFK <=2"

Thanks MajP, It has fulfilled my requirement thanks

 

[ahmad_rmh]

Saving of record with Main and Sub Form:

I want to save record with save button on main form but after finishing data entry on Main and Sub Form.

Kindly suggest possible solutions.

 

[gemma-the-husky]

Saving of record with Main and Sub Form:

I want to save record with save button on main form but after finishing data entry on Main and Sub Form.

Kindly suggest possible solutions.

Why would you want to press any button to save a record? Why are you trying to enter a main record and a subrecord at the same time? This sounds all wrong to me.