Want to use combo box to navigate continuous form

[EManning]

Using A2K. I have a form/subform and would like to use a combo box to
navigate the subform. So, a user would choose a name from the combo box
(SSN is the key and is the bound column) and the subform would automatically
navigate to the name requested. Is there a way to do this? I tried the
following code in the AfterUpdate event of the combo:

strCriteria = "[SSN] = " & conDoubleQuote & Me.cboSearch.Column(0) &
conDoubleQuote
Me.subfrmConferenceAttendance.Form.RecordsetClone.Find strCriteria
Me.subfrmConferenceAttendance.Form.Bookmark = _
Me.subfrmConferenceAttendance.Form.RecordsetClone.Bookmark

Nothing appears to happen.

Thanks for any help or advice.

 

[Frank Reichenbacher]

Using A2K. I have a form/subform and would like to use a combo box to
navigate the subform. So, a user would choose a name from the combo box
(SSN is the key and is the bound column) and the subform would automatically
navigate to the name requested. Is there a way to do this? I tried the
following code in the AfterUpdate event of the combo:

strCriteria = "[SSN] = " & conDoubleQuote & Me.cboSearch.Column(0) &
conDoubleQuote
Me.subfrmConferenceAttendance.Form.RecordsetClone.Find strCriteria
Me.subfrmConferenceAttendance.Form.Bookmark = _
Me.subfrmConferenceAttendance.Form.RecordsetClone.Bookmark

Nothing appears to happen.

Thanks for any help or advice.

Same result with a textbox. Our posts reference nearly the identical
question.

Frank

 

[Scott]

My post is just before you two and it deals with
precisely the same dilemma. We are trying to iterate
through a recordset, but are unable to get it to
correlate to the created form controls. My situation
starts with an Access generated recordset and no matter
what I have tried, I can't get my code to work with that
recordset and tie into the form at the same time. I have
created my own recordsets in a million different ways
like you have, but the Access recordset won't let go of
the form so I can use it.

Scott

-----Original Message-----

Using A2K. I have a form/subform and would like to use a combo box to
navigate the subform. So, a user would choose a name from the combo box
(SSN is the key and is the bound column) and the

subform would
automatically

navigate to the name requested. Is there a way to do this? I tried the
following code in the AfterUpdate event of the combo:

strCriteria = "[SSN] = " & conDoubleQuote & Me.cboSearch.Column(0) &
conDoubleQuote

Me.subfrmConferenceAttendance.Form.RecordsetClone.Find
strCriteria

Me.subfrmConferenceAttendance.Form.Bookmark = _
Me.subfrmConferenceAttendance.Form.RecordsetClone.Bookmark

Nothing appears to happen.

Thanks for any help or advice.

Same result with a textbox. Our posts reference nearly the identical
question.

Frank



.

 

[Frank Reichenbacher]

My post is just before you two and it deals with
precisely the same dilemma.

Not precisely. You have a subform, we have continuous forms. You are trying
to edit data and we are trying to simply display it.


We are trying to iterate

through a recordset, but are unable to get it to
correlate to the created form controls.

I had three problems in mine:

1. My input mask was wrong, so I ended up searching for a value that was not
going to be in the recordset.

2. I confused the textbox and field names.

3. I misplaced the quotes around my string variable name in the Find
operation.


My situation

starts with an Access generated recordset and no matter
what I have tried, I can't get my code to work with that
recordset and tie into the form at the same time. I have
created my own recordsets in a million different ways

Except the correct one. That's the problem here, there is a million ways to
screw up code and only one correct way.

I tried to figure out how to help you, but I would need more information
than I am getting from your post.

(Did you try to Requery the Form after an edit?)

Frank

like you have, but the Access recordset won't let go of
the form so I can use it.

Scott

-----Original Message-----

Using A2K. I have a form/subform and would like to use a combo box to
navigate the subform. So, a user would choose a name from the combo box
(SSN is the key and is the bound column) and the

subform would
automatically

navigate to the name requested. Is there a way to do this? I tried the
following code in the AfterUpdate event of the combo:

strCriteria = "[SSN] = " & conDoubleQuote & Me.cboSearch.Column(0) &
conDoubleQuote

Me.subfrmConferenceAttendance.Form.RecordsetClone.Find
strCriteria

Me.subfrmConferenceAttendance.Form.Bookmark = _
Me.subfrmConferenceAttendance.Form.RecordsetClone.Bookmark

Nothing appears to happen.

Thanks for any help or advice.

Same result with a textbox. Our posts reference nearly the identical
question.

Frank



.