C
Can
I have an Access 2003 adp with the backend on SQL Server 2000.
I want to open a form and have a record being displayed, it doesn't matter
what record. Then I want the user to select a particular record from a
combo box and go to that record.
Originally I opened up the form and showed all the records, then I would
select a record and the record would appear when I used the ServerFilter
function. There was one problem, if you typed in something in the combo box
(including an incomplete record) it would not return any results and the
screen would go grey. How do I take that condition into account? The user
only should have to type in part of the person's name.
I don't need to do it with ServerFilter, that's just the first way I got it
to return records. I am new to this so if there is a better way I am willing
to change it. My first goal is to get it working, my second goal is to make
it efficient. I did experiment some with stored procedures but did not get
far.
Any help is appreciated.
Can
I want to open a form and have a record being displayed, it doesn't matter
what record. Then I want the user to select a particular record from a
combo box and go to that record.
Originally I opened up the form and showed all the records, then I would
select a record and the record would appear when I used the ServerFilter
function. There was one problem, if you typed in something in the combo box
(including an incomplete record) it would not return any results and the
screen would go grey. How do I take that condition into account? The user
only should have to type in part of the person's name.
I don't need to do it with ServerFilter, that's just the first way I got it
to return records. I am new to this so if there is a better way I am willing
to change it. My first goal is to get it working, my second goal is to make
it efficient. I did experiment some with stored procedures but did not get
far.
Any help is appreciated.
Can