SQL-Compass: MS Access: Refresh the form using VBA

SQL Server
T-SQL
UDFs
- String related
- Date related
  - Calculate Business Days
DBAdministraton
- sp_who Related
  - sp_who2 results for a specific database
  - Sub Topic 2
- Table Locks
  - Check Table Lock Status
SSIS
SSRS
SSAS
Definitions
- Database
- Datawarehouse
- Data Mining
- Data Migration
- ETL
- BI
- OLTP
- OLAP
- Big Data
- Data Analytics
MS Access
MS Excel
Tech
Contact

MS Access: Refresh the form using VBA

There was a label where value comes dynamically from table. I was opening the form using Docmd.Openform method. But the label(caption) value was not refreshing. After some internet search found that requery is better than refresh.

Best way

Form!MyFormName.Form.Requery

MS Access: Refresh the form using VBA

No comments:

Post a Comment