How do i automate some entries into a query ?

[shenty]

I am trying to work out how to batch enter some info into a table or query. Sample attached.

Basically this sample db is part of a bigger db i'm working on. It tracks the administration of medicine on animals. Using the "Individual Medicine Admin" button on the sample db it is simple to select an animal, then select a medicine, an amount and a date.

What i can't work out is, using the "Batch Medicine Admin" button and the red button on that form, how to write the code the automate an entry to the underlying table/query for each animal selected in the listbox. (ie using shift, drag or ctrl to select more than 1).

Any help or suggestions would be helpful, thanks....

 

[MagicMan]

1) The Batch Medicine Popup Shrinks when the button is Launched. Popups can be such a pain. If you need help with this let me know.
2) The list of animals is populated from a query. To be able to select and apply the appropriate medicine to multiple selections, you will require a Contimuous Subform and you may have to add a field to the table with the animal register and the query called SelectedForBatch. That bound field can be a Y/N field, default No. On the continuous form the user can now select by clicking the check box. You may want to provide a select all button as well (just a thought). The batch process, can then be launched and can process the selected animals.

Ignore Point 1)....me bad...that happened on the read only Zip...not the saved. Me bad.