Unbound Data Entry Problems

[InDeSkize]

Hello my programming Super Heroes.

I think this one is a no brainer, me being the one with no brain.

I have a form that is used for data entry. The goal is to have an
unbound form that only enters the record when you hit the "Save
Record" button.

I've been using a form that enters right into the table, and I'm
running into too many problems with Multiple Primary Keys and
calculated Text Boxes. I think this will solve all of my worrys.

Thanks for any help.

Ricky

[Allen Browne]

To use an unbound form and write the record via the Save button, generate an
INSERT statement (SQL) from the controls (being careful to handle Nulls
correct), and Execute it.

In reality, that ends up being more work than using a bound form. Use the
BeforeUpdate event of the *form* to validate the record, and ensure the
results are correct before saving. Certainly, this will create greater
problems that the ones you are trying to solve.

You must not save calculated results back into the table, unless it would be
meaningful to have results there that do NOT match the result of the
calculation. For more information on that, see:
Calculated Fields
at:
http://allenbrowne.com/casu-14.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"InDeSkize" <ri***@rickybel l.com> wrote in message
news:22******** *************** ***@posting.goo gle.com...

Hello my programming Super Heroes.

I think this one is a no brainer, me being the one with no brain.

I have a form that is used for data entry. The goal is to have an
unbound form that only enters the record when you hit the "Save
Record" button.

I've been using a form that enters right into the table, and I'm
running into too many problems with Multiple Primary Keys and
calculated Text Boxes. I think this will solve all of my worrys.

Thanks for any help.

Ricky