[AccessD] Changing Subform Record Source

Shamil:

I had about 4 other things wrong with that form and code - but got them all
straightened out.  Final code is:

    Forms!frmRoutings!sfrmRoutingSubForm.Form.RecordSource = _
        "Select * FROM tblProductionRouting " _
        & "WHERE fldPanelDefID = " _
        & Val(Nz(Me.cboPanelDefID.Column(0)))

Ans takes care of the problem of the user not selecting a record from the
cboPanelDef combo box - the subform then has zero records.  

Thanks

Rocky
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Shamil
Salakhetdinov
Sent: Sunday, March 20, 2011 12:49 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Changing Subform Record Source

Hi Rocky --

Yes, I have seen from your other message that you've solved the issue.

It could have been that subform has had "Dirty = True"  when you tried to
change its recordsource?

Thank you.

--
Shamil
 
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: 20 ????? 2011 ?. 21:14
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Changing Subform Record Source

It's in the after update of an option frame where the user picks one of two
subforms.  But I got it to work.

Thanks

Rocky
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Shamil
Salakhetdinov
Sent: Sunday, March 20, 2011 10:50 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Changing Subform Record Source

Hi Rocky --

When/where (within what event/object) do you call this code to change
subform's recordsource?

Thank you.

--
Shamil
 
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: 20 ????? 2011 ?. 20:24
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Changing Subform Record Source

Changed the statement to:

    Forms!frmRoutings!sfrmRoutingSubForm.Form.RecordSource = "Select * FROM
tblFinishingRouting " _
        & "WHERE fldPanelDefID = " & Val(Me.txtPanelDefID)

Now I get "You canceled the previous operation"  :(

Rocky
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Sunday, March 20, 2011 10:20 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Changing Subform Record Source

Dear List:
 
Trying to change the record source on a sub-form and I can't ever remember
the correct syntax.  This
 
Forms!frmRoutings!sfrmRoutingSubForm.RecordSource = "Select * FROM
tblFinishingRouting " _
        & "WHERE fldPanelDefID = " & Val(Me.txtPanelDefID)
 
gives error object doesn't support this propertyor method.
 
I know I'm close but can't get it to work.  Anyone see what's wring?
 
MTIA
 

Rocky Smolin

Beach Access Software

858-259-4334

Skype: rocky.smolin

www.e-z-mrp.com <http://www.e-z-mrp.com/> 

www.bchacc.com <http://www.bchacc.com/> 

 

 

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com