hi all
I have an access db front end, with a dataverse backend. My main data entry form "policies" has a variety of subforms (with the correct Parent and Child ID assigned). the master form itself only updates fields in the table policies. Everything works flawlessly on existing records in the Policies table, hence I also know the Parent Child link works fine. My issue is the following, appreciate your help if possible. It relates to opening the master form in new recordmode which results in the subform never updating until the master form has been closed and reopened:
I open my main data entry form "Policies" in a new record mode. I use the following VBA code in the .open event to go to a new record
If IsNull(Me.OpenArgs) Then
Me.AllowEdits = True
Me.AllowAdditions = True
Me.DataEntry = True
DoCmd.GoToRecord , , acNewRec
obviously all the subforms are unpopulated as there is no ID saved yet. After the first few required fields have an entry, a save is forced.One of these fields is a combobox linking to a related table (risks), and stores the foreign key in the policies table. that part all works fine.
My issue is that the subforms remain empty even after the foreign key is saved, until I close the master form alltogether and reopen it again. It is like there is no parent child ID link, unlike when the form was opened on an existing record. I can see the Key in my table, so I know it has been correctly saved.
To solve this, I was using a simple .requery on the subforms (me.subfrmcontrol.form.requery). However, this does not help , the subform remains blank. I tried .refresh .repaint, I tried to force a refresh by doing me.subfrmcontrol.form.recordsource = me.subfrmcontrol.form.recordsource, I overwrote the .recordsource with a new Select query... I cannot get the subform to show the linked record, until I close the master form the child form remains blank.
Once the form has been closed and I open the master form on an existing record, then it works flawlessly.
I read somewhere that using SQL server or Dataverse as backend changes the way Parent and Child behaviour changes and the link isn't instantenous. Suspect that is the cause here.
My main question is : how can I get the subform to show the correct linked record, without having to close the master form?
Thanks a lot for your views.
I have an access db front end, with a dataverse backend. My main data entry form "policies" has a variety of subforms (with the correct Parent and Child ID assigned). the master form itself only updates fields in the table policies. Everything works flawlessly on existing records in the Policies table, hence I also know the Parent Child link works fine. My issue is the following, appreciate your help if possible. It relates to opening the master form in new recordmode which results in the subform never updating until the master form has been closed and reopened:
I open my main data entry form "Policies" in a new record mode. I use the following VBA code in the .open event to go to a new record
If IsNull(Me.OpenArgs) Then
Me.AllowEdits = True
Me.AllowAdditions = True
Me.DataEntry = True
DoCmd.GoToRecord , , acNewRec
obviously all the subforms are unpopulated as there is no ID saved yet. After the first few required fields have an entry, a save is forced.One of these fields is a combobox linking to a related table (risks), and stores the foreign key in the policies table. that part all works fine.
My issue is that the subforms remain empty even after the foreign key is saved, until I close the master form alltogether and reopen it again. It is like there is no parent child ID link, unlike when the form was opened on an existing record. I can see the Key in my table, so I know it has been correctly saved.
To solve this, I was using a simple .requery on the subforms (me.subfrmcontrol.form.requery). However, this does not help , the subform remains blank. I tried .refresh .repaint, I tried to force a refresh by doing me.subfrmcontrol.form.recordsource = me.subfrmcontrol.form.recordsource, I overwrote the .recordsource with a new Select query... I cannot get the subform to show the linked record, until I close the master form the child form remains blank.
Once the form has been closed and I open the master form on an existing record, then it works flawlessly.
I read somewhere that using SQL server or Dataverse as backend changes the way Parent and Child behaviour changes and the link isn't instantenous. Suspect that is the cause here.
My main question is : how can I get the subform to show the correct linked record, without having to close the master form?
Thanks a lot for your views.
