Setvalue from sub form to Pop up form

[Stoffman]

I am opening up a Pop up form from a subform and showing records with linked values. This works fine, however when I choose an option on the Pop up form I want to link this record back to the subform.

I have tried Setvalue where the Cust_id value in the popup form = The cust_id in the subform, but the error messge 'Microsoft Access can't find the form FRM: Customer Sub form referred to in a macro expression or visual basic code'-the form you referenced may be closed or does not exist.

The Subform is not closed and does exist, does anyone know how this can be done.

Cheers Stoffman

 

[PHV]

You may try something like this to reference the subform's control:
Forms![mainform name]![subform control name].Form!cust_id

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Stoffman]

It nows moans about 'The object doesn't contain the automation Object'Cust_No'

-You tried to run a visual Basic procedure to set a property or method for an object. However, the component doesn't make the property or method available for automation operations.

The Subform is not locked and is enabled and so is the field I am trying referenece. This works when theis form is not a sub form. So I can only asssume it has something to do with the fact that is has to be a subform. Any more Ideas

Can I use global Variables and if so how?

Cheers Stoffman

 

[PHV]

Take a look here:

http://support.microsoft.com/?kbid=209099

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[TheAceMan1]

How are ya Stoffman . . . . .

[blue]however when I choose an option on the Pop up form [purple]I want to link this record back to the subform.[/purple][/blue]

I get you drift, but can take one of several paths in response.

[purple]Be a little more specific about this . . . [/purple]

See Ya! . . . . . .

 

[Stoffman]

Cheers guys. Got it sorted in the end changed the set value from
.[Cust_Id] to ![Cust_id]. How annoying??

 

[PHV]

. is for property/method, ! is for member of the collection.
If you reread my suggestion you'll see you had the solution.