Adding Records to a "Task" subform based on Item selected in Parent form...

C

Cameo

Hi everyone,

I'm a newbie to this newsgroup and can do a lot of things in Access but
don't know how to write code (but I'm good at modifying codes, just don't
know how to write them from scratch)....

I'm hoping someone can help me.

I created a database to manage Tradeshow activities. What I want to have
Access do is to automatically assign X number of tasks (add X records) to
Task Subform based on an Assigned Display. For example, when I select
Tabletop Display 1 in the Assigned Display ListBox, I want the following
tasks automatically added to the subform:
Task 1 - Pay Exhibit Fee
Task 2 - Email Shipment Checklist to Sales Rep
Task 3 - Fulfill checklist and ship

Can someone tell me how I can do this?

Thank you so much!

Cameo
 
C

Cameo

This got me half-way there...It adds just one task, but I need it add a
whole bunch. Any suggestions?

Thank you.

Cameo
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Main Form List Box Selections Add Record in Subform 1
Create a "modular" subform 0
Dynamic Subforms based on the number of records in Table 8
Problem adding a new record to a subform 1
Filter main form to records with no related records in subform,maintain updateable recordset 4
How make subform independent of main form? 11
select record based on record selected in the child form 4
Adding new records to a Subform 1

Top