Popup Form question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dave - 16 Jul 2007 02:17 GMT

How can I set a pop-up form to only take one record?
I have a popup form (single form) to take some customer info however when if
they tab past the last field all the data disappears.
Anyway to prevent this?

Thanks in advance

D

Reply to this Message

Bob Quintal - 16 Jul 2007 01:41 GMT

> How can I set a pop-up form to only take one record?
> I have a popup form (single form) to take some customer info
[quoted text clipped - 4 lines]
>
> D

set the form's Cycle property (on the Other tab) to Currrent
Record.

Signature

Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

Reply to this Message

missinglinq - 16 Jul 2007 02:30 GMT

In the form's Design View goto Properties - Other - Set the Cycle Property to
Current Record. This will keep it from going to a new record when tabbing
past the last control, which is what is happening when your data "disappears.
" To additionally assure that only one record is added, Under the Format tab,
set the Navigation Buttons Property to No.

Good Luck!

Signature

There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Reply to this Message

Dave - 16 Jul 2007 16:20 GMT

Thank you both.
That was exactly what I needed.

D

> How can I set a pop-up form to only take one record?
> I have a popup form (single form) to take some customer info however when
[quoted text clipped - 4 lines]
>
> D

Reply to this Message