requery wo startin new record - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

requery wo startin new record

John Yeung

3 years ago

I have a form (as below pic 1). When I press the Refresh button (it is actually requery button). The caption (numbner of receipt) on the button will automatically updated (pic 2 below). But sometimes it started a blank new record that I do NOT want.
Is there a way just to requery the button and stay on the same record?

	John Yeung OP @Reply 3 years ago

	Kevin Robertson @Reply 3 years ago
Requery in Place

	John Yeung OP @Reply 3 years ago
i tried recordset.requery, but it didnt work. May be the form is single instead of continuous

	John Yeung OP @Reply 3 years ago
i also tried (suggested by AI) : Dim strFormName As String strFormName = "Form1" ' change to your form name Forms(strFormName).AllowAdditions = False Forms(strFormName).Requery Forms(strFormName).AllowAdditions = True But still didnt work

	Kevin Yip @Reply 3 years ago
You don't use Requery just to update a button's caption. Requery is for refreshing the entire recordset. Sometimes you don't need to do that, especially in a single form, where the user doesn't even see all the records. Just update the button's caption with: MyButton.Caption = ...

	John Yeung OP @Reply 3 years ago
Dear Kevin Done. Thanks very much for your advice

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View