Search results

OK, I carried on digging...It seems that the ODBC Refresh will show updated existing records, but does not add new records to the display or remove deleted ones. I have a link, but haven't made enough posts to add it yet. I'll update this with the link...one day ;-)

Hi Minty. Thanks for the reply. I'd read that, and expected that if I set the refresh interval to a shorter time (one minute), the subform would pick up any data changes after a minute. Unfortunately, this isn't happening. The subform doesn't refresh until I trigger a refresh manually. (The...

Hi. I have a sub-form, which has a query as its data source. The query is based on a linked table from an SQL Server database. When a user updates the table from a different PC, the data change is not reflected on the PC that I'm using...the subform looks the same until I manually refresh...