autopopulate information in another table

[Serendipity]

Access 2002

Here's what I want to do:
When I check a box(name = attachment problems) on a form (name = Roof
Inspection), I want another form to open (Action Items),with a text box (name
= Item with error) to autopopulate with: roof edge attachment problems that
is stored in tblActionItems. This new forms has additional information that
will then be entered into the tblActionItems and is closed when completed.

With a macro I can get the form to open, enter the additional information,
and close the form, but I can't get text box to autopopulate the item with
error field with roof edge attachment problems, I am having to manually type
the information in. Since this will always be the same each time this box is
checked, I want to save time by having it automatically be there.

Is there anyway to do this? Everything I have tried, doesn't work.

Thanks

 

[Steve Schapel]

Serendipity,

You should be able to do this using the SetValue action in your macro.