Prev: My Access query shows blank in the label merge
Next: Nz - need code -
From: Marshall Barton on 9 Mar 2010 00:34
Well, I am sure glad that you solved it because corruption
symptoms rarely relate to the real problem. We would have
been chasing all over the place trying to pin down the
inconsistent bahavior caused by any kind of corruption.
--
Marsh
MVP [MS Access]


kc-mass wrote:
>Problem solved rebuilt form from scratch and works fine seems some level of
>corruption.
>
>
>"kc-mass" <connearney_AT_comcast_DOT_net> wrote
>> Thanks Marshal but the form still does not refresh the data. It opens to
>> the first record and stays there no matter how many times i select
>> something from the combobox.
>>
>> Further ideas appreciated. Driving me nuts.
>>
>>
>> "Marshall Barton" wrote
>>> kc-mass wrote:
>>>>I have a personnel form with typical personnel data. On the form is an
>>>>combo that has a data source of employeeID, LastName, First name. The
>>>>first
>>>>(0) column is bound to the combo.
>>>>
>>>>The query that feeds the form references the combo as criteria against
>>>>the
>>>>employeeID.
>>>>=[ME].[cboEmployee] Or Is Null
>>>>
>>>>The onchange event of the combo asks for a requery of the form
>>>>
>>>>Private Sub cboEmployee_Change()
>>>> Requery
>>>> Debug.Print "it fired"
>>>>End Sub
>>>>
>>>>The event fires but the form does not requery.
>>>
>>> The Change event is inapproprate. You should use the
>>> AfterUpdate event instead.
>>>
>>> Me is not allowed outside of a class module, use the full
>>> reference:
>>> =Forms![form name].[cboEmployee] Or Is Null
From: vernal on 9 Mar 2010 05:31
i also have a similar problem ......................
have got a drop down list in excel say A, B, C, D, data..now this data has
got various other sub data to it.. i wan get this sub - data in the excel
format in such a way that if i click A i should only get that sub data for A
only and not for some thing else....so in the same cell if i clear the data A
to B i should get the list for only data B in the next cell
please help
m breaking my head over it

"kc-mass" wrote:

> Hi,
>
> I have a personnel form with typical personnel data. On the form is an
> combo that has a data source of employeeID, LastName, First name. The first
> (0) column is bound to the combo.
>
> The query that feeds the form references the combo as criteria against the
> employeeID.
> =[ME].[cboEmployee] Or Is Null
>
> The onchange event of the combo asks for a requery of the form
>
> Private Sub cboEmployee_Change()
> Requery
> Debug.Print "it fired"
> End Sub
>
> The event fires but the form does not requery.
>
> Any help appreciated.
>
> Kevin
>
>
> .
>
From: Marshall Barton on 9 Mar 2010 10:59
vernal wrote:
>i also have a similar problem ......................
>have got a drop down list in excel say A, B, C, D, data..now this data has
>got various other sub data to it.. i wan get this sub - data in the excel
>format in such a way that if i click A i should only get that sub data for A
>only and not for some thing else....so in the same cell if i clear the data A
>to B i should get the list for only data B in the next cell
>

If you are asking a question about something in MS Access,
you should translate it to what you are using in an Access
form.

If you are asking an Excel question, then you should post it
to an appropriate Excel forum.

--
Marsh
MVP [MS Access]
First  |  Prev  | 
Pages: 1 2
Prev: My Access query shows blank in the label merge
Next: Nz - need code -