Push values from bound form to undound, edit, then pull back

[Dickie Black]

Hi,

I've seen answers to similar questions, but none of them quite work. I have
a main bound form with various bound controls. I wish to be able to click a
button which will do the following:

open another (unbound) form
populate with some of the values from the main form, so they can be edited
close the new form
transfer the edited values back.

I know about "DoCmd.OpenForm, "MyForm", , , , , acDialog " to pause the
code until the new form is hidden, but how do I then tell the new form to
use values from the main form?

If I try

Forms.SessionDesc.SessionDescText = Forms.[Session test].SessionDescText
Forms.SessionDesc.SessionPrimary = Forms.[Session
test].PrimaryLecturerText
Forms.SessionDesc.SessionSecondary = Forms.[Session
test].SecondaryLecturerText

I get "Object doesn't support this property or method" errors, whether this
code is in the OnClick event of the button, or the Form_Current event of the
unbound form.

I'm sure it's something relatively simple I'm missing...

Dickie

[Dickie Black]

Thanks, I knew it would be something that simple!

Dickie

"Elwin" <bosk@attbi.com> wrote in message
news:3e7a01c340a0$1a96a090$a601280a@phx.gbl...

> you should be using exclamations to separate your object
> names, not periods.
> eg) Forms!SessionDesc!SessionDescText
>
> Periods preceed a method or property name that has been
> assigned by Access. Exclamations preceed an object name
> that has been assigned by the user.
> eg) Forms!SessionDesc.Requery
>
> Good luck.
>

> >-----Original Message-----
> >Hi,
> >
> >I've seen answers to similar questions, but none of them

> quite work. I have

> >a main bound form with various bound controls. I wish to

> be able to click a

> >button which will do the following:
> >
> >open another (unbound) form
> >populate with some of the values from the main form, so

> they can be edited

> >close the new form
> >transfer the edited values back.
> >
> >I know about "DoCmd.OpenForm, "MyForm", , , , ,

> acDialog " to pause the

> >code until the new form is hidden, but how do I then tell

> the new form to

> >use values from the main form?
> >
> >If I try
> >
> > Forms.SessionDesc.SessionDescText = Forms.[Session

> test].SessionDescText

> > Forms.SessionDesc.SessionPrimary = Forms.[Session
> >test].PrimaryLecturerText
> > Forms.SessionDesc.SessionSecondary = Forms.[Session
> >test].SecondaryLecturerText
> >
> >I get "Object doesn't support this property or method"

> errors, whether this

> >code is in the OnClick event of the button, or the

> Form_Current event of the

> >unbound form.
> >
> >I'm sure it's something relatively simple I'm missing...
> >
> >Dickie
> >
> >
> >.
> >

[John Vinson]

On Wed, 2 Jul 2003 12:08:02 +0100, "Dickie Black"
<r.black@sheffield.ac.uk> wrote:

> Forms.SessionDesc.SessionDescText = Forms.[Session test].SessionDescText

Use ! instead of . - it's confusing because they will both *often*
work interchangably but they're not quite interchangable. The ! refers
to an item in a collection (such as the Forms collection, or the
Controls collection of a form), and that's what you need here.


John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
[url]http://go.compuserve.com/msdevapps?loc=us&access=public[/url]