By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,663 Members | 1,843 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,663 IT Pros & Developers. It's quick & easy.

Unbound Data Entry Problems

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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***@rickybell.com> wrote in message
news:22**************************@posting.google.c om...
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

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.