Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

REQUERYING ONLY ONE RECORD

Status
Not open for further replies.
SeanB

SeanB

Programmer
Jul 19, 2001
70
0
0
US
Is there anyway in Access 2000 to not have to requery the entire recordsource on a form and just the record that I am on without losing the place I am on?
 
Sort by date Sort by votes
It sounds as though you want to requery certain fields on the form, not the form. If this is the case, the syntax is [Fieldname].requery which will leave you on the same record with the field(s) updated.

Hope this helps.

mac318
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

PizMac
  • Locked
  • Question
error 3027 database or object is read-only
Replies
5
Views
113
PizMac
PizMac
atadbitslow
  • Locked
  • Question
comparing fields, one populated with data and one blank 2
Replies
8
Views
134
atadbitslow
atadbitslow
JerryR
  • Locked
  • Question
Access 365 - Only allow one user to open 1
Replies
5
Views
65
JerryR
JerryR
Moss100
  • Locked
  • Question
Using data macro to alert user when record is added to a table.
Replies
2
Views
54
Andrzejek
Andrzejek
lameid
  • Locked
  • Question
Read only .ACCDB
Replies
1
Views
51
lameid
lameid

Part and Inventory Search

Sponsor

Back
Top