Access VBA passing to subform

Wrox Programmer Forums

		Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
Access VBA passing to subform

Access VBA Discuss using VBA for Access programming.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA 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

July 10th, 2007, 09:03 AM

ayazhoda

ayazhoda is offline

Friend of Wrox

Join Date: Apr 2007

Posts: 110

Thanks: 1

Thanked 2 Times in 2 Posts

Send a message via MSN to ayazhoda

Default

Access VBA passing to subform

Hi All

Main form calling subform

Me!CallSub.Requery

Sub form running this line

If IsNull(Me!CID) Then Exit Sub

But Me!CID has no value is shows null

Any idea!

Thanks

Old

July 11th, 2007, 07:45 AM

darrenb

darrenb is offline

Authorized User

Join Date: Mar 2007

Posts: 53

Thanks: 0

Thanked 0 Times in 0 Posts

Default

Hi

Instead of your current code

If IsNull(Me!CID) then
Exit Sub

Try
If Me.CID.Value = "" then
Exit Sub

Not sure what you are trying to do here with this, but this works for me

Cheers

Darren

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Passing value to subform using SQL	ayazhoda	Access VBA	0	July 10th, 2007 04:21 AM
Code works in Excel VBA but not Access VBA	fossx	Access VBA	2	May 21st, 2007 08:00 AM
Passing Query from Access to MySAL using VBA	stephej	Access	3	June 20th, 2006 06:56 AM
Can't find subform referred to in VBA Error 2450	mmcdonal	Access VBA	2	April 18th, 2005 10:05 AM
Passing a Variable to a SubForm in Access	ritag	Access	1	September 29th, 2004 03:53 PM