Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dcrandell
Starting Member
2 Posts |
 Posted - 2004-08-27 : 20:57:08
|
| help in access front end using sql server backend. Query works fine pulls data, in form using bookmark and it does not go to correct number I type into the combo box: Here is the routine::::Private Sub Combo29_Enter()' Find the record that matches the control. Me.RecordsetClone.FindFirst "[Envelope_Number] = '" & Me![Combo29] & "'" Me.Bookmark = Me.RecordsetClone.BookmarkEnd |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2004-08-29 : 19:26:19
|
| Just to clarify:You've got a form with a combo box on it. When the user selects an item from the combo, the form is meant to move to the corresponding record - right?If so, you'd be better off using the FILTER property on the form. |
 |
|
|
|
|
|
query