View Full Version : need to update several records with a single form--how?


arage
08-12-2001, 08:49 PM
i have a form that updates anthology info.

i have a control where i specify the anthology title i am applying the stories against.

then i have a trio of controls title/author/rating that represent one new record to be added to my query. However adding 1 record for an anthology is no good to me. the whole point of the form is so that i can enter several titles against a single anthology i specify. When i copy the trio of controls & paste them (they represent a new record) they end up reflecting whatever i have typed in the first trio of controls (or the first record info)

how do i get around this problem?

Pat Hartman
08-13-2001, 05:47 AM
You need to use a subform to add the records for the stories in the anthology.

arage
08-15-2001, 11:30 AM
I’ve done as you’ve advised thanks, but is it possible for the subform to only accept new records for an anthology I specify as opposed to pulling in all related records & then providing a space for a new record to be added at the end of the subform results?