Search results

the solution to my problem was a basic way of creating a form which is to include all table I need in the form instead of manually adding subform... Sorry for the bother... Thank you very much of your time...

I will try all your suggestions... Thank you Very Much...

I already tried this "[TblPOLot Subform].Form![POLotID]" But it also does not work... Any workaround for my problem? I am open for suggestion... I am very sorry for the bother...

in my TblPurchaseRequest form, it somewhat works...

Good day, I am here again seeking help. But before I post here, I have tried many times but failed... What I am trying to accomplish is that the form TblPurchaseOrderNEW will have 2 subform same as the form TblPurchaseRequest with the same function... I have set the relationships but when I...

I already did the Cycle property on current record on the main form since it is only where available, but it still does not work

Is my intention still possible even if its not a subform, but a subform control?

I am sorry, my post is wrong... It would be pressing TAB in subform control1(TblLot Subform) then setfocus will go to subform control2 (TblLotParticular Subform)? Because I can only find the Cycle Property in the Main Form. I am so sorry for the wrong descriptions...

I am sorry if I identified it wrong...

hi, there is no cycle property

good day experts, I am here again seeking guidance.. I am planning to use key command combination in MACRO Builder in Access 2019. I can't seem to find any in google or in this forum... I am using Macro Builder and use gotocontrol to navigate my setfocus to another subform after pressing TAB...

yah... hahaha... And now back to encoding from start.... Thank you for the Big help...

accidentally solved my PROBLEM!!!!!!!!!!!! Private Sub Command12_Click() Dim strSQL As String Dim db As DAO.Database Dim rs As DAO.Recordset Dim ctl As Control Dim varItem As Variant On Error GoTo ErrorHandler Set db = CurrentDb()...

in the navigation, I will press the NEW PO then the form TblPurchaseOrder will open as new record one of the combobox(LotNumber) has afterupdate event that will open the form with listbox after selecting the items, clicking the ADD button, it will close the form w/ listbox and populate the...

Private Sub Command12_Click() Dim strSQL As String Dim db As DAO.Database Dim rs As DAO.Recordset Dim ctl As Control Dim varItem As Variant On Error GoTo ErrorHandler Set db = CurrentDb() Set rs = db.OpenRecordset("TblPOParticular"...

Good day, Thank you very much to helping me masters... This thread is now solved and closed...

Good day, Thank you very much to helping me masters... This thread is now solved and closed...

Good day, Thank you very much to helping me masters... This thread is now solved and closed...

good day to all, I am here again seeking help on my DB.. Below is a code I found in the net and I modified it. The code work when directly record the selected into the Table, But what I want is that when I press the command button, it will add the selected data in the Subform "TblPOParticular...

sorry for being noob on my 1st DB... Thank you...