Force Data Entry In Combobox First

[PC Datasheet]

I have a form with an unbound combobox at the top and seventeen controls
below it. Is there a simple way to prevent data entry in any of the controls
until a selection is made in the combobox?

Thanks!

Steve

[Ken Snell]

Assuming that the other controls are in the Detail section, just make that
section invisible and set its visibility in the AfterUpdate event of the
combo box (test for a value in the combobox).

--

Ken Snell
<MS ACCESS MVP>

"PC Datasheet" <no****@nospam.spam> wrote in message
news:W_*****************@newsread3.news.atl.earthl ink.net...

I have a form with an unbound combobox at the top and seventeen controls
below it. Is there a simple way to prevent data entry in any of the
controls until a selection is made in the combobox?

Thanks!

Steve

[WSF]

Contact me at my email address below if you would like outside help with
this. My fees are very reasonable.

-- PC Datasheet Your Resource For Help With Access, Excel And Word
Applications

re******@pcdatasheet.com www.pcdatasheet.com

PC Datasheet wrote:

I have a form with an unbound combobox at the top and seventeen controls
below it. Is there a simple way to prevent data entry in any of the controls
until a selection is made in the combobox?

Thanks!

Steve

[Bob Quintal]

"PC Datasheet" <no****@nospam.spam> wrote in
news:W_*****************@newsread3.news.atl.earthl ink.net:

I have a form with an unbound combobox at the top and
seventeen controls below it. Is there a simple way to prevent
data entry in any of the controls until a selection is made in
the combobox?

Thanks!

Steve

in the form's current event, set the .enabled property false for
each control. The in the combo box's .afterupdate, set them true.
--
Bob Quintal

PA is y I've altered my email address.

[Trevor Best]

Bob Quintal wrote:

"PC Datasheet" <no****@nospam.spam> wrote in
news:W_*****************@newsread3.news.atl.earthl ink.net:

I have a form with an unbound combobox at the top and
seventeen controls below it. Is there a simple way to prevent
data entry in any of the controls until a selection is made in
the combobox?

Thanks!

Steve

in the form's current event, set the .enabled property false for
each control. The in the combo box's .afterupdate, set them true.

Another way is to use the form's BeforeInsert event and set Cancel=True
if the combo box is null, that's the quicker way to code it but not as
user freindly as Bob's. Depends if you like your users much :-)

[John Marshall, MVP]

Answering your own questions?

John... Visio MVP

"WSF" <so*****@microsoft.com> wrote in message
news:nN*********************@news.xtra.co.nz...

Contact me at my email address below if you would like outside help with
this. My fees are very reasonable.

-- PC Datasheet Your Resource For Help With Access, Excel And Word
Applications

re******@pcdatasheet.com www.pcdatasheet.com

PC Datasheet wrote:

I have a form with an unbound combobox at the top and seventeen controls
below it. Is there a simple way to prevent data entry in any of the
controls until a selection is made in the combobox?

Thanks! Steve

[tina]

trying to plant questions so you can "self advertise" here? and why should
folks posting legitimate questions pay you to solve such simple problems -
when the rest of us will provide help for free?
"WSF" <so*****@microsoft.com> wrote in message
news:nN*********************@news.xtra.co.nz...

Contact me at my email address below if you would like outside help with
this. My fees are very reasonable.

-- PC Datasheet Your Resource For Help With Access, Excel And Word
Applications

re******@pcdatasheet.com www.pcdatasheet.com

PC Datasheet wrote:

I have a form with an unbound combobox at the top and seventeen controls
below it. Is there a simple way to prevent data entry in any of the controls until a selection is made in the combobox?

Thanks!

Steve

[Marshall Barton]

LOL

Another example of what goes around, comes around.
Or rather more like reaping what you sow.
--

WSF wrote:

Contact me at my email address below if you would like outside help with
this. My fees are very reasonable.

-- PC Datasheet Your Resource For Help With Access, Excel And Word
Applications

re******@pcdatasheet.com www.pcdatasheet.com

PC Datasheet wrote:

I have a form with an unbound combobox at the top and seventeen controls
below it. Is there a simple way to prevent data entry in any of the controls
until a selection is made in the combobox?

Thanks!

Steve

[Marshall Barton]

John, tina

If you're correct, the poster got it backwards.

OTOH, it looks more like someone sticking it back where it
came from.

Either way, it's good for a laugh.
--
tina wrote:

trying to plant questions so you can "self advertise" here? and why should
folks posting legitimate questions pay you to solve such simple problems -
when the rest of us will provide help for free?
"WSF" <so*****@microsoft.com> wrote in message
news:nN*********************@news.xtra.co.nz...

Contact me at my email address below if you would like outside help with
this. My fees are very reasonable.

-- PC Datasheet Your Resource For Help With Access, Excel And Word
Applications

re******@pcdatasheet.com www.pcdatasheet.com

PC Datasheet wrote:

> I have a form with an unbound combobox at the top and seventeen controls
> below it. Is there a simple way to prevent data entry in any of thecontrols > until a selection is made in the combobox?
>
> Thanks!
>
> Steve
>
>

[PC Datasheet]

Thanks for your responses!

Steve
"PC Datasheet" <no****@nospam.spam> wrote in message
news:W_*****************@newsread3.news.atl.earthl ink.net...

I have a form with an unbound combobox at the top and seventeen controls
below it. Is there a simple way to prevent data entry in any of the
controls until a selection is made in the combobox?

Thanks!

Steve

[Keith]

"Marshall Barton" <ma*********@wowway.com> wrote in message
news:g8********************************@4ax.com...

John, tina

If you're correct, the poster got it backwards.

OTOH, it looks more like someone sticking it back where it
came from.

Indeed, and I don't believe for one minute that "PC Datasheet" didn't
already know the answer to the question he asked.

[WSF]

Very perceptive of you young Marshall.
I figured if it is good enough to advertise in one's responses why not
do so in one's questions!

ah hah hah hah hah hah hah hah hah hah hah haaaaaaaaaah ! hiccup!

Marshall Barton wrote:

John, tina

If you're correct, the poster got it backwards.

OTOH, it looks more like someone sticking it back where it
came from.

Either way, it's good for a laugh.

[Marshall Barton]

While I appreciate the complement WSF, I can not let a
misunderstanding go uncorrected. The word "young" is not an
appropriate description of me, even if it is relative to
your own feelings of decrepitude ;-)
--
Marsh

WSF wrote:

Very perceptive of you young Marshall.
I figured if it is good enough to advertise in one's responses why not
do so in one's questions!

ah hah hah hah hah hah hah hah hah hah hah haaaaaaaaaah ! hiccup!

Marshall Barton wrote:

John, tina

If you're correct, the poster got it backwards.

OTOH, it looks more like someone sticking it back where it
came from.

Either way, it's good for a laugh.

[Larry Linson]

"Marshall Barton" wrote

While I appreciate the complement WSF,
I can not let a misunderstanding go uncorrected.
The word "young" is not an appropriate
description of me, even if it is relative to
your own feelings of decrepitude ;-)

Gosh, Marsh, I thought "young, handsome, wearing a jaunty beret" was a
perfectly apt description. Of course, my POV on age may from some here.
<GRIN>

Larry

[WSF]

I fear the physical decrepitude may be on me soon enough but the mental,
no! There but for a sense of humour go we all.
WSF

Marshall Barton wrote:

While I appreciate the complement WSF, I can not let a
misunderstanding go uncorrected. The word "young" is not an
appropriate description of me, even if it is relative to
your own feelings of decrepitude ;-)
--
Marsh

WSF wrote:

Very perceptive of you young Marshall.
I figured if it is good enough to advertise in one's responses why not
do so in one's questions!

ah hah hah hah hah hah hah hah hah hah hah haaaaaaaaaah ! hiccup!

Marshall Barton wrote:

John, tina

If you're correct, the poster got it backwards.

OTOH, it looks more like someone sticking it back where it
came from.

Either way, it's good for a laugh.

[Marshall Barton]

I think both Larry amd I are in total aggreement with your
sentiments.

Keep on truck'n
--
Marsh

WSF wrote:

I fear the physical decrepitude may be on me soon enough but the mental,
no! There but for a sense of humour go we all.
Marshall Barton wrote:

While I appreciate the complement WSF, I can not let a
misunderstanding go uncorrected. The word "young" is not an
appropriate description of me, even if it is relative to
your own feelings of decrepitude ;-)
WSF wrote:

Very perceptive of you young Marshall.
I figured if it is good enough to advertise in one's responses why not
do so in one's questions!

ah hah hah hah hah hah hah hah hah hah hah haaaaaaaaaah ! hiccup!
Marshall Barton wrote:
John, tina

If you're correct, the poster got it backwards.

OTOH, it looks more like someone sticking it back where it
came from.

Either way, it's good for a laugh.