After Update Event Procedure

[Little_Man22]

How can I send the value of field 'x' from a pop-up form to a field on the form underneath that is of the same name?

In other words I need code in the afterupdate event prodecure of field 'x' that says something like:

Copy value of Me!x to forms!frmclients!applicationdata!x

However, my primitive code above will not do the trick

Does anyone have any suggestions as to how this could work?

Thanks in advance,
Ryan.

 

[Jack Cowley]

[Forms]![frmClients]![ApplicationData] = Me.x

[This message has been edited by Jack Cowley (edited 10-31-2001).]

 

[Little_Man22]

Jack:

The code won't run. I get the error message 'Object doesn't support this property or method' (RuntimeError 438).

This is what I have written as per your example:

Private Sub MaidenName_AfterUpdate()
[Forms]![frmClients]![pgeAdditionalInfo]![MaidenName] = Me.MaidenName
End Sub

 

[Rich]

Wonder why you seem to be storing duplicate info, and it looks as if you need to rename your controls to something other than the field name,eg. Me.txtMaidenName

 

[Little_Man22]

Rich:

Ideally I don't even want to store the info that is entered into the pop-up form (within certain fields anyways). If I could just pass it down to the origional form and stroe it from there that would be great. The problem is that I can't seem to get it to pass down!

Ryan.

 

[Little_Man22]

Or ideally if I could have code that would automatically save something entered into a field like MaidenName in the appropriate table (in this case tblclients). Maybe if there was some kind of code written into the afterevent procedure that would store the code in this table, the field on the main form would update automatically?

Does anyone have any ideas if this is possible, or how to go about it?

Ryan.