Add a record on subform using button

[oxicottin]

Is this possible and please say yes.... I have a form with a subform that has continious records and on the subform I want to add a button that would show up on each line because its a continious form and this button would add a record "ABOVE" that record. How can I do this? Please expain because im still learning

Thanks,
Chad


Thanks,
SoggyCashew.....

 

[PHV]

Please, define ABOVE

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[oxicottin]

OK, if I would press a button in a record in the continious subform below where I want to inset a new record. So what it would do is insert a new record above the row selected.

Thanks,
SoggyCashew.....

 

[dhookom]

What PH is getting as is records are like marbles in a bag. You throw a new marble in the bag, it becomes part of the un-ordered marbles. There is no first, last, above, below, previous, or next. Only a random bag of marbles.

If you want marbles (records) in order, you have to identify characteristics (field values) that determine the order.

Duane
Hook'D on Access
MS Access MVP