Data Form Wizard

[Jeff Brown]

I am developing my First "Real" app and i am running in to the following
problem.
I use the data form wizard to create a form, so i do not have to manually do
all the binding.
But the only thing i want the user to be able to do on this form is Add a
record.

I tried moving the fill dataset in to the form load to get rid of the "load"
button and that worked but it also loads data into my textboxes.
Ok i could code around that ....
But it also generates the insert , update and delete commands ... and i am
getting lost .. when i click "add" it increments the navigation counter yet
i remain on the same record and am unable to get to the new record and no
record is actually inserted. in the database because it is satying in my
dataset!!!!.... HELP!!!
am i supposed to click add , then update .. or enter my vales and then click
add then update....
because when i go back and look in the database sometimes i get a blank
record but usually it just updates whichever record is the last one ...
being that i cannot navigate to the newly created record in my dataset to
edit it and send it back to the database.

My idea was to have a form for users to enter data and seperate forms for
the update and delete to prevent certain users from being able to add
records.

Thanks,
Jeff Brown
aka BrntPhish

[Jeff Brown]

OK i decided to hand code ALL (10 - 15 Tables , 15 - 20 fields per) of my
bindings and queries, probably more efficient that way.i didnt particlaurly
want to use the wizard but i thought it might save a few hundred keystokes

"Jeff Brown" <no******@thistime.com> wrote in message
news:3a*****************@twister.austin.rr.com...

I am developing my First "Real" app and i am running in to the following
problem.
I use the data form wizard to create a form, so i do not have to manually do all the binding.
But the only thing i want the user to be able to do on this form is Add a
record.

I tried moving the fill dataset in to the form load to get rid of the "load" button and that worked but it also loads data into my textboxes.
Ok i could code around that ....
But it also generates the insert , update and delete commands ... and i am
getting lost .. when i click "add" it increments the navigation counter yet i remain on the same record and am unable to get to the new record and no
record is actually inserted. in the database because it is satying in my
dataset!!!!.... HELP!!!
am i supposed to click add , then update .. or enter my vales and then click add then update....
because when i go back and look in the database sometimes i get a blank
record but usually it just updates whichever record is the last one ...
being that i cannot navigate to the newly created record in my dataset to
edit it and send it back to the database.

My idea was to have a form for users to enter data and seperate forms for
the update and delete to prevent certain users from being able to add
records.

Thanks,
Jeff Brown
aka BrntPhish