Re: Combo box help plzzzzzzz
From: Ken Snell [MVP] (kthsneisllis9_at_ncoomcastt.renaetl)
Date: 09/17/04
- Next message: zbook: "Hide Access Window"
- Previous message: Paul James: "Re: handling a No-Additions form that goes blank"
- In reply to: Sam: "Re: Combo box help plzzzzzzz"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 16 Sep 2004 20:21:20 -0400
I need you to post some specific information. Open the form in design view.
Open the Properties window (icon on toolbar).
(1) Don't click on anything else yet. Form should show in the "dropdown"
list at top of Properties window (If you're using ACCESS 2002 or 2003; else
in the dropdown list at top left of form in design view just under the
toolbar.) If Form doesn't show, select it from the dropdown list.
(a) In the Properties window, click on Data tab. Click into the box next
to Record Source and copy the entire text string there; paste it into a
message here.
(b) Click on the Event tab. Do any of the boxes have text in them (such
as [Event Procedure] or such? Copy and paste that information into message,
identifying the label's words that are to the left of that box.
(2) Click on the combo box.
(a) In the Properties window, click on Data tab. Click into the box next
to Row Source and copy the entire text string there; paste it into a message
here.
(b) What is the name of the combo box? (Other tab, Name box)
(c) Click on the Event tab. Do any of the boxes have text in them (such
as [Event Procedure] or such? Copy and paste that information into message,
identifying the label's words that are to the left of that box.
(d) Click on the Data tab. If there is anything in the box next to
Control Source, copy and paste it into message.
(3) Click on the subform control (click on left vertical side of the subform
control).
(a) What is the name of the subform control? (Other tab, Name box)
(b) Click on the Event tab. Do any of the boxes have text in them (such
as [Event Procedure] or such? Copy and paste that information into message,
identifying the label's words that are to the left of that box.
(c) Click on the Data tab. If there is anything in the box next to Link
Master Fields and/or Link Child Fieds, copy and paste it into message.
(4) Click on the small, grey square at the top left of the form that is
inside the subform control. A smaller, black square should show in that grey
square.
(a) In the Properties window, click on Data tab. Click into the box next
to Record Source and copy the entire text string there; paste it into a
message here.
(b) Click on the Event tab. Do any of the boxes have text in them (such
as [Event Procedure] or such? Copy and paste that information into message,
identifying the label's words that are to the left of that box.
--
Ken Snell
<MS ACCESS MVP>
"Sam" <Sam@discussions.microsoft.com> wrote in message
news:BE41E9D7-C6E4-459E-949D-2C273250D7A1@microsoft.com...
> Ken,
>
> To be frank with you, I am new in access. So I will simplify things the
> maximum.
> I have created a query that gives the different transactions of my
customers.
> The form, the subform and the combo box are getting their data from that
> query.
> I have created the combo box using the wizard and choose the find record
> option.
>
> When i choose a name from the combo box, the subfrom is populated by the
> correspondant info in addition to one empty field where I put "updates" of
> the transactions. When I fill data in the "updates" field, the record
> shouldn't show anymore. All this is working perfect except for two
situations:
> 1. If I open the form and click on the first name in the combo box,
nothing
> happens, I have to choose another name before, and then get back to the
first
> one.
> 2. When I fill data in the "updates" field, and I get to the point where
> only one name is left in the combo box, this last name also doesn't work
if
> choosen.
>
> I don't know if this makes sense, I am clear??
>
> Thks in advance.
>
> "Ken Snell [MVP]" wrote:
>
> > Tell us how you set up the form and subform. Did you use the wizard to
set
> > up the combo box? What code runs on the combo box's events? Is the
subform's
> > LinkChildFields and LinkMasterFields properties set so that the subform
> > tracks with the combo box? More details, please.
> > --
> >
> > Ken Snell
> > <MS ACCESS MVP>
> >
> >
> >
> > "Sam" <Sam@discussions.microsoft.com> wrote in message
> > news:F1279280-D2D8-46C1-ADCB-35E893B00995@microsoft.com...
> > > Hello all.
> > >
> > > Please I need your help with this one.
> > >
> > > I have a form with a subform and a combo box to use it as a search
tool.
> > >
> > > I am using the subform to see the customers transactions.
> > > When I open the combo box drop down list and I choose the first name
in
> > the
> > > list, nothing happens. If I choose another name, the subform is
populated
> > by
> > > the various transactions corresponding to that name.If after that I
choose
> > > the first name, it works.
> > > So everytime I open this "serach form", if I want the first name in
the
> > > combo box, I have to choose another one first, and then choose it
later to
> > > have its info shown in the subform.
> > >
> > > Why is this happening? what to do?
> > > Thks.
> > >
> >
> >
> >
- Next message: zbook: "Hide Access Window"
- Previous message: Paul James: "Re: handling a No-Additions form that goes blank"
- In reply to: Sam: "Re: Combo box help plzzzzzzz"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
