Problem through REFRESH

[Sanjaylml]

I have made a form of Supplier Master, showing the details of one Supplier (LAST RECORD) at a time. That form has a button (Goods Details), which opens another form & shows what material is being supplied by that particular customer.



Private Sub GoodsDetails_Click()

Dim strDocName As String

Dim strLinkCriteria As String

strDocName = "ItemBank"

strLinkCriteria = "[DataBankID] = Forms![DataBank]![id]"

Me.Refresh

DoCmd.OpenForm strDocName, , , strLinkCriteria

End Sub



Whenever, I add a record of Supplier & click on button (Goods Details), it does not show the details of Supplier which I added, but the last record of Supplier before added.



In that case, there is only one option left to close the form & re-open to enter the goods details of supplier.



I have tried to amend the VBA by adding “ Me.REFRESH”, in OPEN/LOAD/ACTIVATE but it has no effect.



I shall be very grateful if anyone can help me to overcome this problem.



Thanking you,

[DThreadgill]

I have made a form of Supplier Master, showing the details of one Supplier (LAST RECORD) at a time. That form has a button (Goods Details), which opens another form & shows what material is being supplied by that particular customer.



Private Sub GoodsDetails_Click()

Dim strDocName As String

Dim strLinkCriteria As String

strDocName = "ItemBank"

strLinkCriteria = "[DataBankID] = Forms![DataBank]![id]"

Me.Refresh

DoCmd.OpenForm strDocName, , , strLinkCriteria

End Sub



Whenever, I add a record of Supplier & click on button (Goods Details), it does not show the details of Supplier which I added, but the last record of Supplier before added.



In that case, there is only one option left to close the form & re-open to enter the goods details of supplier.



I have tried to amend the VBA by adding “ Me.REFRESH”, in OPEN/LOAD/ACTIVATE but it has no effect.



I shall be very grateful if anyone can help me to overcome this problem.



Thanking you,

Try Me.Requery instead of refresh.

Refreshing records only updates the data that already exists in your datasheet or form. It doesn't reorder records, display new records, or remove deleted records and records that no longer meet specified criteria. To perform those tasks, requery the records.

[Sanjaylml]

Thanks for your reply.

Your suggestion seems to be O.Kay to add a new customer & simultaneously add corresponding Goods Detail.

But, there is a problem if we go to a particular record (existing) by searching & when we click Goods Detail button to view their part detail, it shows the detail of 1st record available in the database. It appears to be a problem with Me.REQUERY that goes to the top of record.

I have used Me.REQUERY before the following command but still wrong data shows.

strLinkCriteria = "[DataBankID] = Forms![DataBank]![id]"

It is requested to enlighten me to resolve this issue.

Try Me.Requery instead of refresh.

Refreshing records only updates the data that already exists in your datasheet or form. It doesn't reorder records, display new records, or remove deleted records and records that no longer meet specified criteria. To perform those tasks, requery the records.