Combo used for Find does not trigger AfterUpdate Event

[Pat Garard]

G'Day All,

I have a Form/Subform arrangement.

The Form is linked to Cases, the subform shows CaseAppointments
and is linked over CaseID.

I have put a combo on the subform, to list CaseAppointments, and move
to a specific CaseAppointment.

The combo was wizard created, but I have modified it's Query to add
CaseID=[Forms]![Cases].CaseID as a criterion.
Columns: AppointmentID ; CaseID ; AppointmentDateTime
0cm ; 0cm ; 3cm

The Form displays cases ok (has it's OWN combo to move to Case)
The subform displays/navigates CaseAppointments ok
the combo in question correctly loads the Appointment Dates
BUT
When the combo list is clicked it just sits there - the AfterUpdate
Event
just is not being triggered.

Any ideas would be appreciated.

 

[Arvin Meyer]

Try adding the line:

Me.NameOfSubform.Form.Requery

in your code. "Me" refers to the current open form or report, and replaces
"Forms!FormName". Make sure you replace "NameOfSubform" with the control
name of your subform.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Pat Garard]

G'Day Arvin,

Thanks for the response. I found other controls misbehaving
so I have gone back to a previous (working) version of the Form.

Either the form had in some way become corrupt, or I had 'corrupted'
it with incompetent code.

Either way, I will rework the addition of the combo, and see how I go
- bearing your suggestion in mind.

I will post here with the outcome.

Thanks again!
--
Regards,
Pat Garard
Melbourne, Australia
_______________________

Try adding the line:

Me.NameOfSubform.Form.Requery

in your code. "Me" refers to the current open form or report, and
replaces
"Forms!FormName". Make sure you replace "NameOfSubform" with the
control
name of your subform.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

G'Day All,

I have a Form/Subform arrangement.

The Form is linked to Cases, the subform shows CaseAppointments
and is linked over CaseID.

I have put a combo on the subform, to list CaseAppointments, and
move
to a specific CaseAppointment.

The combo was wizard created, but I have modified it's Query to add
CaseID=[Forms]![Cases].CaseID as a criterion.
Columns: AppointmentID ; CaseID ; AppointmentDateTime
0cm ; 0cm ; 3cm

The Form displays cases ok (has it's OWN combo to move to Case)
The subform displays/navigates CaseAppointments ok
the combo in question correctly loads the Appointment Dates
BUT
When the combo list is clicked it just sits there - the AfterUpdate
Event
just is not being triggered.

Any ideas would be appreciated.
--
Regards,
Pat Garard
Melbourne, Australia
_______________________

 

[Pat Garard]

G'Day (again) Arvin,

I have re-developed the form, from it's previous version, without
problems. I have no idea what the issue could have been.

When 'strange' things occur I become paranoid - but not so that
I fail to keep some version control.

Again - Many Thanks!
--
Regards,
Pat Garard
Melbourne, Australia
_______________________

G'Day Arvin,

Thanks for the response. I found other controls misbehaving
so I have gone back to a previous (working) version of the Form.

Either the form had in some way become corrupt, or I had 'corrupted'
it with incompetent code.

Either way, I will rework the addition of the combo, and see how I
go
- bearing your suggestion in mind.

I will post here with the outcome.

Thanks again!
--
Regards,
Pat Garard
Melbourne, Australia
_______________________

Try adding the line:

Me.NameOfSubform.Form.Requery

in your code. "Me" refers to the current open form or report, and
replaces
"Forms!FormName". Make sure you replace "NameOfSubform" with the
control
name of your subform.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

G'Day All,

I have a Form/Subform arrangement.

The Form is linked to Cases, the subform shows CaseAppointments
and is linked over CaseID.

I have put a combo on the subform, to list CaseAppointments, and
move
to a specific CaseAppointment.

The combo was wizard created, but I have modified it's Query to
add
CaseID=[Forms]![Cases].CaseID as a criterion.
Columns: AppointmentID ; CaseID ; AppointmentDateTime
0cm ; 0cm ; 3cm

The Form displays cases ok (has it's OWN combo to move to Case)
The subform displays/navigates CaseAppointments ok
the combo in question correctly loads the Appointment Dates
BUT
When the combo list is clicked it just sits there - the
AfterUpdate
Event
just is not being triggered.

Any ideas would be appreciated.
--
Regards,
Pat Garard
Melbourne, Australia
_______________________