S
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
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