help with combo box requery

[Dos Lil]

I have a comobox in the main form which has a query attached to it to
list the employee numbers.I have written this code to requry the control
in the control's after update event

Private Sub CBOEmpNo_AfterUpdate()
Me![CBOEmpNo].Requery
End Sub

but still I am getting error

Is there any other tips regarding requery

can anyone offer any help

Regards
Dos lil
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Van T. Dinh]

Do you know which line of code that errors out? Error Number? Error
Description Text?

--
HTH
Van T. Dinh


"Dos Lil" <do****@hotmail.com> wrote in message
news:3f*********************@news.frii.net...

I have a comobox in the main form which has a query attached to it to
list the employee numbers.I have written this code to requry the control
in the control's after update event

Private Sub CBOEmpNo_AfterUpdate()
Me![CBOEmpNo].Requery
End Sub

but still I am getting error

Is there any other tips regarding requery

can anyone offer any help

Regards
Dos lil
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Ray]

Dos Lil <do****@hotmail.com> wrote in message news:<3f*********************@news.frii.net>...

I have a comobox in the main form which has a query attached to it to
list the employee numbers.I have written this code to requry the control
in the control's after update event

Private Sub CBOEmpNo_AfterUpdate()
Me![CBOEmpNo].Requery
End Sub

but still I am getting error

Is there any other tips regarding requery

can anyone offer any help

Regards
Dos lil
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Hello Dos,

Just one question. What are you doing in the combo
box that needs to run the After Update property to
requery it? Are you adding a new record? What?

Regards,

Ray

[Dos Lil]

Thanks for the response.

Let me give you an overall scenario of what i am trying to do.I have a
combo list on the main form which is linked to the child form.The child
form is for the data entry purpose for the employee selected from the
main form.When I select the first emplouyee No in the combo i do not get
this message,but it is not inserting the employee number also selected
the from the main form.But when i select the second employee number from
the main form i get this error.I do not have any macro attached to the
coombo except for the code i have written for the control in the after
update event
The error message is "Macro or ites group macro does'nt exits /macro is
new and have'nt saved.Nit that when you enter macrogroupname.macroname
syntax in an argument you must specify the name the macro's macro group
was last saved under".

The other error I get is :The changes you requested was not saved cos
they would create dupliacte values in the index,primary key or
realtionship.remove the index or redifing the index or change the values
in the field."

I have written code for inserting the employee number to the subform
selcted from the main form
But still.....
Private Sub Form_BeforeUpdate(Cancel As Integer)
If IsSubform(Me) Then
If IsNull(Me.Empno) Then
Me.Empno = Me.Parent.Empno
End If
End If
End Sub

please help have been trying this for a week :)

Regards

Dos lil


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Van T. Dinh]

What is IsSubForm()? Is it a UDF?

Have you Compiled your code to see if there are compilation errors?

--
HTH
Van T. Dinh
MVP (Access)

"Dos Lil" <do****@hotmail.com> wrote in message
news:3f*********************@news.frii.net...

Thanks for the response.

Let me give you an overall scenario of what i am trying to do.I have a
combo list on the main form which is linked to the child form.The child
form is for the data entry purpose for the employee selected from the
main form.When I select the first emplouyee No in the combo i do not get
this message,but it is not inserting the employee number also selected
the from the main form.But when i select the second employee number from
the main form i get this error.I do not have any macro attached to the
coombo except for the code i have written for the control in the after
update event
The error message is "Macro or ites group macro does'nt exits /macro is
new and have'nt saved.Nit that when you enter macrogroupname.macroname
syntax in an argument you must specify the name the macro's macro group
was last saved under".

The other error I get is :The changes you requested was not saved cos
they would create dupliacte values in the index,primary key or
realtionship.remove the index or redifing the index or change the values
in the field."

I have written code for inserting the employee number to the subform
selcted from the main form
But still.....
Private Sub Form_BeforeUpdate(Cancel As Integer)
If IsSubform(Me) Then
If IsNull(Me.Empno) Then
Me.Empno = Me.Parent.Empno
End If
End If
End Sub

please help have been trying this for a week :)

Regards

Dos lil


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Dos Lil]

IsSubform is a function which return true if the form is currently
loaded as a subform.And False if it is a stand-alone from.

I checked with the function code there seems to be no error.The error is
in the combo list of the main form.When I select the value from the
exixting list (EMpNO) Instead of selecting it is agian adding to the
table ,which is the result of the duplicate key entry since the EMPno in
the main table is PK.

All I need to do is to select from the combo and requery it .Please let
me know How I go with this.
I have a deadline next week

Thanks again


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Van T. Dinh]

Not sure of your set-up but it seems to me that you want to use the ComboBox
for selection then the ComboBox should be an unbound Control, i.e. its
ControlSource should be blank. The fact that it adds Record seems to
indicate that it is a bound Control somehow.

Another point is that I am not sure why you want to requery the ComboBox
just after selecting a value. Logically for normal usage, this doesn't do
anything as the RowSource of the ComboBox canNOT depends on its value (or
you get a circular reference).

--
HTH
Van T. Dinh
MVP (Access)

"Dos Lil" <do****@hotmail.com> wrote in message
news:3f*********************@news.frii.net...

IsSubform is a function which return true if the form is currently
loaded as a subform.And False if it is a stand-alone from.

I checked with the function code there seems to be no error.The error is
in the combo list of the main form.When I select the value from the
exixting list (EMpNO) Instead of selecting it is agian adding to the
table ,which is the result of the duplicate key entry since the EMPno in
the main table is PK.

All I need to do is to select from the combo and requery it .Please let
me know How I go with this.
I have a deadline next week

Thanks again


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!