parent table update through macro event in child table

[Mike Eurice]

I would like to update a parent table when a combobox in a
child table's form has no suitable entry in the list.

On Data Event = Enter in the form combobox for the child
table, I run FirmTypeUpdate:

FirmTypeUpdate:

OpenTable FirmType Datasheet Edit
GoToRecord Table FirmType New
Close Table FirmType

Action:

Opens parent table FirmType, goes to the new record, and
then closes the table without adding the new firm type in
the new record position.

Can anyone help me make the final step to update the table?

 

[Steve Schapel]

Mike,

I regret to say that what you are trying to do is not possible.

It is not clear to me where the new FirmType is coming from. If you
are simply dropping down the combobox list and detecting visually that
the required value is not there, put a command button alongside the
combobox, to open a form based on the FirmType table, where you will
need to manually enter the new FirmType. If you are typing the new
FirmType into the combobox, the simplest approach is to use the
combobox's On Not In List event, once again to open your FirmType
form.

- Steve Schapel, Microsoft Access MVP

 

[Mike Eurice]

Steve,

Thanks for your quick reply, I'll use the work around you
suggested.

Mike