How are ya devagupt . . .
Yes its possible! . . . I've already done so for a few clients in the past who were adamant about this.
What you need to do:
[ol][li]Base the [blue]RecordSource[/blue] of your [blue]continuous form[/blue] on a query thats [blue]sorted decending[/blue] on a field that increases with [purple]unique[/purple] values (numeric primarykey, date, or other equivalent numeric).[/li]
[li]Here's the trick: [purple]
In the forms header underneath the labels for the fields, add a row of unbound textboxes.[/purple] [blue]
This is your input line at the top of the form![/blue] . . . and since its in the header it stays at the top! If you close-up the detail section properly you wont know the difference in form view![/li]
[li]Now its a simple matter of [blue]a little code to polish it off[/blue], the sequence of which should be:
[ol a][li]In the last unbound textbox [blue]validate key fields[/blue] before appending the unbound data.[/li]
[li]Append the data.[/li]
[li]Requery the form.[/li]
[li]Clear the unbound data.[/li]
[li]Set focus to the 1st unbound control[/li][/ol][/li][/ol]
[blue]Your Thoughts? . . .[/blue]
See Ya! . . . . . .
