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

stop next record, if field not complete

P: n/a
Hi all,
Ive got a bound form (its actually a subform), but want to ensure that a
specific field is populated before the user can move away from that record.

Can anyone suggest the best method for doing this.? It would need to cover
next record, previous record, and the form (subform) losing focus.

Thanks in advance.
--
Gerry Abbott,


Feb 15 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Gerry Abbott wrote:
Hi all,
Ive got a bound form (its actually a subform), but want to ensure
that a specific field is populated before the user can move away from
that record.
Can anyone suggest the best method for doing this.? It would need to
cover next record, previous record, and the form (subform) losing
focus.
Thanks in advance.


Making it a required field in your table design is the best way.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Feb 15 '06 #2

P: n/a
Sounds good. Rick,
Sometimes we don't see the wood for the trees.....................
"Rick Brandt" <ri*********@hotmail.com> wrote in message
news:Ho*****************@newssvr27.news.prodigy.ne t...
Gerry Abbott wrote:
Hi all,
Ive got a bound form (its actually a subform), but want to ensure
that a specific field is populated before the user can move away from
that record.
Can anyone suggest the best method for doing this.? It would need to
cover next record, previous record, and the form (subform) losing
focus.
Thanks in advance.


Making it a required field in your table design is the best way.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Feb 15 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.