I have carfully read all of the questions regarding combo boxes and cannot
find anything that applies. I know it's simple, but I just can't seem to get
it. I have a form with an unbound combo box which is used to select a
record. That works fine. What I want is for the form to open with all of
the fields blank. Any guidance you can provide would be greatly appreciated.

Ron

Ron wrote:
> I have carfully read all of the questions regarding combo boxes and
> cannot find anything that applies. I know it's simple, but I just
> can't seem to get it. I have a form with an unbound combo box which
> is used to select a record. That works fine. What I want is for the
> form to open with all of the fields blank. Any guidance you can
> provide would be greatly appreciated.
>
> Ron

Assuming that this is a bound form then the only time the controls will all be
blank is when you are on the new record position. You would have to use code in
the Open event to take the form to that position.

DoCmd.RunCommand acCmdRecordsGoToNew


--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Rick,

Thanks for the quick answer. Since I am not a VBA guru, I will need a
little more information as to exactly what code to include and on that
action. I tried just adding it to the control to open the form, but it
bombed. Thanks in advance for your help.

Ron

"Rick Brandt" wrote:

> Ron wrote:
> > I have carfully read all of the questions regarding combo boxes and
> > cannot find anything that applies. I know it's simple, but I just
> > can't seem to get it. I have a form with an unbound combo box which
> > is used to select a record. That works fine. What I want is for the
> > form to open with all of the fields blank. Any guidance you can
> > provide would be greatly appreciated.
> >
> > Ron
>
> Assuming that this is a bound form then the only time the controls will all be
> blank is when you are on the new record position. You would have to use code in
> the Open event to take the form to that position.
>
> DoCmd.RunCommand acCmdRecordsGoToNew
>
>
> --
> Rick Brandt, Microsoft Access MVP
> Email (as appropriate) to...
> RBrandt at Hunter dot com
>
>
>

Ron wrote:
> Rick,
>
> Thanks for the quick answer. Since I am not a VBA guru, I will need a
> little more information as to exactly what code to include and on that
> action. I tried just adding it to the control to open the form, but
> it bombed. Thanks in advance for your help.

In the property sheet of the form while in design view go to the Events tab and
find the On Open event property. In the list of choices choose [Event
Procedure] then press the build button [...] to the right. In the VBA window
that will open enter...

DoCmd.RunCommand acCmdRecordsGoToNew

....between the two lines that will have been pre-built that define the
sub-routine for the Open event.


--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Rick,

Adding this code to the command used to open the form accomplished the task
and resolved my issue:

DoCmd.GoToRecord , , acNewRec

Thanks for your help. Without it I would have never solved my problem.

Ron

"Ron" wrote:

> Rick,
>
> Thanks for the quick answer. Since I am not a VBA guru, I will need a
> little more information as to exactly what code to include and on that
> action. I tried just adding it to the control to open the form, but it
> bombed. Thanks in advance for your help.
>
> Ron
>
> "Rick Brandt" wrote:
>
> > Ron wrote:
> > > I have carfully read all of the questions regarding combo boxes and
> > > cannot find anything that applies. I know it's simple, but I just
> > > can't seem to get it. I have a form with an unbound combo box which
> > > is used to select a record. That works fine. What I want is for the
> > > form to open with all of the fields blank. Any guidance you can
> > > provide would be greatly appreciated.
> > >
> > > Ron
> >
> > Assuming that this is a bound form then the only time the controls will all be
> > blank is when you are on the new record position. You would have to use code in
> > the Open event to take the form to that position.
> >
> > DoCmd.RunCommand acCmdRecordsGoToNew
> >
> >
> > --
> > Rick Brandt, Microsoft Access MVP
> > Email (as appropriate) to...
> > RBrandt at Hunter dot com
> >
> >
> >