multiple table entries from form

[foobar182]

Hello. I have a form set up that enters data to a table. For a few certain types of data i need the form to automatically make two entries. for example:

If name=Rob
make a rob entry
and make a billy entry.

Right now it would of course just enter Rob.

Im guessing a need a conditional statement somewhere but i dont know how to structure that and if i need a macro or VB. I also don't know VB so i might be screwed here.

Thank You

 

[3divine]

For a start, search MS Access help on the topic:

Set the value of a control based on the value of another control by using a macro