Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old March 9th, 2004, 05:46 PM
lxu lxu is offline
Authorized User
Join Date: Oct 2003
Posts: 31
Thanks: 0
Thanked 0 Times in 0 Posts
Default How to refresh a table in a form

The problem I am having is:
- Select a code in a combo box which is in main form
- Click a button on the form
- Another form opened with all the data displayed in tabular format related on the code selected
- Back to the main form, select another code in the combo box,
- “#delete” is shown on all of the cells of the table

How can I refresh the fields on the second form before it has the data of second code shown? (or display data instead of "#delete")?

I cannot use button Close to close the form first, then select another code from the combo box.
I thought that it would work if adding some code in the programm to close the form before it is opened, but fail.

Thanks for any suggestion,

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to refresh owner form on closing of child form akumarp2p C# 2005 0 December 22nd, 2006 10:27 AM
How can I refresh a table in store procedure flyfish SQL Server 2000 1 July 19th, 2005 07:01 PM
Refresh Form sangata VS.NET 2002/2003 2 May 11th, 2004 03:01 AM
Refresh form while updating linked form mfletch Access 0 February 26th, 2004 10:32 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.