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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Refreshing linked SQL table data using VBA - Access 2007

Status
Not open for further replies.
CarolCook

CarolCook

IS-IT--Management
Mar 7, 2003
158
US
I have a combo box linked to a sql table via ODBC. When the SQL users add more values, I would like the Access user to be able to force a re-read of the table so that the combo box is up to date.

This is a switchboard-driven app so the user will not have access to the linked table manager and the link itself is not changing.

Thanks for your help.
 
Sort by date Sort by votes
Is it as simple as putting a Requery in the Before Update property?
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

M
  • Locked
  • Question
display a calendar with appointments in body of html email with access vba
Replies
1
Views
2K
SoftwareRT
SoftwareRT
Dan Stoica
  • Locked
  • Question
Problems with Foxpro dsnless linked tables
Replies
0
Views
347
Dan Stoica
Dan Stoica
Moss100
  • Locked
  • Question
Filter vba problem
Replies
1
Views
506
Andrzejek
Andrzejek
Omarahmed22
  • Locked
  • Question
VBA Formating
Replies
1
Views
453
Andrzejek
Andrzejek
DarkOne72
  • Locked
  • Question
MS Access DoCmd.Transferdatabase Assistance
Replies
2
Views
1K
lameid
lameid

Part and Inventory Search

Sponsor

Back
Top