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....
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....
Last edited:
