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 September 9th, 2005, 11:50 PM
Authorized User
 
Join Date: Jul 2005
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to rocknrisk
Default Requery a Form Field from another Form

Hi all,

I have a form "frmCalls" with a ComboBox "cboContact". Next to the ComboBox is a command button "cmdAddContact" which opens a form to add a contact not in in the ComboBox.

on the Form "frmAddContact", I have an OK button "cmdOK" which saves the new contact details and closes frmAddContact.

I want "cboContact" on "frmCalls" to include the new contact I have added through "frmAddContact". So basically, when I click "cmdOK" on "frmAddContact", "frmAddContact" closes and requeries the list in "cboContact" on "frmCalls". I do not want to requery the whole form as "cboContact" is halfway down the form and I don't want users to have to re - fill the fields above.

I hope this makes sense. Thank you in advance.

Clinton.
 
Old September 10th, 2005, 01:10 AM
Friend of Wrox
 
Join Date: Jan 2005
Posts: 471
Thanks: 0
Thanked 1 Time in 1 Post
Default

Hiya Clinton!,

In the OK Button "cmdOK" on the Form "frmAddContact" event put the following:

Form![frmCalls].[cboContact].requery

Hope all else is well!

Kevin

dartcoach
 
Old September 16th, 2005, 01:41 PM
Authorized User
 
Join Date: Jul 2005
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to rocknrisk
Default

Hey Kevin,

I'm cool. Been off on vacation for a week. Thank you mate. I will try that...

Hope all is well with you too... How's the arrows going?

Clinton
 
Old September 16th, 2005, 03:51 PM
Authorized User
 
Join Date: Jul 2005
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to rocknrisk
Default

Hey Kevin,

Cheers mate. I sent you an email.

Clinton...





Similar Threads
Thread Thread Starter Forum Replies Last Post
How to grey out a form field? kk_sg Access 4 April 29th, 2008 10:11 AM
Updating Field in Form cthibault Access 2 January 8th, 2008 03:37 PM
Subform Record Saved, Update/Requery Form controls CB-VTXer Access VBA 2 August 6th, 2007 02:35 PM
form field problem hastikeyvan Classic ASP Professional 12 September 3rd, 2006 08:45 AM
unbound field in a form zanza67 BOOK: Access 2003 VBA Programmer's Reference 0 September 3rd, 2005 01:46 PM





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