I need some help with several problems --
1. When i'm importing records through a query, using an append table, its
telling me its found several errors in all the records, because of a
validation rule. Tehre are no validation rules set, and ther are no
formatting issues. At any rate, if i override it and allow it to import the
data, it works fine. Id like to remove this problem, as the people who wil
be using this database are not technical at all.

2. I've tried several different code snippets on the web and from MS's
different affiliates, with no luck. I'm trying to make a very simple filter
so that by selecting one of the (NON duplicates) on the list box, all of the
records are filtered to show only those with the same value as the list box.

3. Exporting data onto a web form.. . this one needs lots of help. I have
not yet built the form, but I intend to have it served from a secure server
from my workplace. My options are, what is currently done, whihc is
exporting the results to a spreadsheet and emailing it to everyone, and what
i want to do, whihc is create a webpage they can look at online, with no user
permissions except to read the records, using the same sorting method as
above.
4. In one of my Yes/No fields, it defaults to a value of 0, even though i
have none of the default values set. When i went back and changed all the
defaults to "No", it still insists on placing a zero if one clicks on a Null
field, in order to enter "yes" or "no"


I imagine someone will want a copy of some part of my database. I can
provide that, but as the records are secure, i wil have to clear them out.

1) What is probably happening is one of your fields has the "Required" option
set to true. Any records which have no value for that field will return a
validation error. It's very possible it's not working correctly, as it will
reject those records and you could be losing data you need. You can block
this error message by running the queries in a macro or VB code and setting
setwarnings to false... although making it handle your data more reliably
would be a better choice, if possible.

2) Use a combo box, and try code similar to this:

Private Sub Combo10_Click()
Me.Filter = "[Field1] = '" & Me.Combo10.Text & "'"
Me.FilterOn = True
End Sub

3. Can't help you much here.

4. 0 = No = False. Defaulting it to no will set the value to 0. Having no
default value set.. will default it to no, which defaults it to 0.


"Pwyd" wrote:

> I need some help with several problems --
> 1. When i'm importing records through a query, using an append table, its
> telling me its found several errors in all the records, because of a
> validation rule. Tehre are no validation rules set, and ther are no
> formatting issues. At any rate, if i override it and allow it to import the
> data, it works fine. Id like to remove this problem, as the people who wil
> be using this database are not technical at all.
>
> 2. I've tried several different code snippets on the web and from MS's
> different affiliates, with no luck. I'm trying to make a very simple filter
> so that by selecting one of the (NON duplicates) on the list box, all of the
> records are filtered to show only those with the same value as the list box.
>
> 3. Exporting data onto a web form.. . this one needs lots of help. I have
> not yet built the form, but I intend to have it served from a secure server
> from my workplace. My options are, what is currently done, whihc is
> exporting the results to a spreadsheet and emailing it to everyone, and what
> i want to do, whihc is create a webpage they can look at online, with no user
> permissions except to read the records, using the same sorting method as
> above.
> 4. In one of my Yes/No fields, it defaults to a value of 0, even though i
> have none of the default values set. When i went back and changed all the
> defaults to "No", it still insists on placing a zero if one clicks on a Null
> field, in order to enter "yes" or "no"
>
>
> I imagine someone will want a copy of some part of my database. I can
> provide that, but as the records are secure, i wil have to clear them out.
>
>

Yes, in fact there are four required fields. The data the appendtable is
providing includes those fields, and none of them are empty, nor do they
break any of those rules.


"Lance" wrote:

> 1) What is probably happening is one of your fields has the "Required" option
> set to true. Any records which have no value for that field will return a
> validation error. It's very possible it's not working correctly, as it will
> reject those records and you could be losing data you need. You can block
> this error message by running the queries in a macro or VB code and setting
> setwarnings to false... although making it handle your data more reliably
> would be a better choice, if possible.
>
> 2) Use a combo box, and try code similar to this:
>
> Private Sub Combo10_Click()
> Me.Filter = "[Field1] = '" & Me.Combo10.Text & "'"
> Me.FilterOn = True
> End Sub
>
> 3. Can't help you much here.
>
> 4. 0 = No = False. Defaulting it to no will set the value to 0. Having no
> default value set.. will default it to no, which defaults it to 0.
>
>
> "Pwyd" wrote:
>
> > I need some help with several problems --
> > 1. When i'm importing records through a query, using an append table, its
> > telling me its found several errors in all the records, because of a
> > validation rule. Tehre are no validation rules set, and ther are no
> > formatting issues. At any rate, if i override it and allow it to import the
> > data, it works fine. Id like to remove this problem, as the people who wil
> > be using this database are not technical at all.
> >
> > 2. I've tried several different code snippets on the web and from MS's
> > different affiliates, with no luck. I'm trying to make a very simple filter
> > so that by selecting one of the (NON duplicates) on the list box, all of the
> > records are filtered to show only those with the same value as the list box.
> >
> > 3. Exporting data onto a web form.. . this one needs lots of help. I have
> > not yet built the form, but I intend to have it served from a secure server
> > from my workplace. My options are, what is currently done, whihc is
> > exporting the results to a spreadsheet and emailing it to everyone, and what
> > i want to do, whihc is create a webpage they can look at online, with no user
> > permissions except to read the records, using the same sorting method as
> > above.
> > 4. In one of my Yes/No fields, it defaults to a value of 0, even though i
> > have none of the default values set. When i went back and changed all the
> > defaults to "No", it still insists on placing a zero if one clicks on a Null
> > field, in order to enter "yes" or "no"
> >
> >
> > I imagine someone will want a copy of some part of my database. I can
> > provide that, but as the records are secure, i wil have to clear them out.
> >
> >

Well.. along the same line. Do you have any fields with "allow zero length"
set to no and data which violates it?

"Pwyd" wrote:

> Yes, in fact there are four required fields. The data the appendtable is
> providing includes those fields, and none of them are empty, nor do they
> break any of those rules.
>
>
> "Lance" wrote:
>
> > 1) What is probably happening is one of your fields has the "Required" option
> > set to true. Any records which have no value for that field will return a
> > validation error. It's very possible it's not working correctly, as it will
> > reject those records and you could be losing data you need. You can block
> > this error message by running the queries in a macro or VB code and setting
> > setwarnings to false... although making it handle your data more reliably
> > would be a better choice, if possible.
> >
> > 2) Use a combo box, and try code similar to this:
> >
> > Private Sub Combo10_Click()
> > Me.Filter = "[Field1] = '" & Me.Combo10.Text & "'"
> > Me.FilterOn = True
> > End Sub
> >
> > 3. Can't help you much here.
> >
> > 4. 0 = No = False. Defaulting it to no will set the value to 0. Having no
> > default value set.. will default it to no, which defaults it to 0.
> >
> >
> > "Pwyd" wrote:
> >
> > > I need some help with several problems --
> > > 1. When i'm importing records through a query, using an append table, its
> > > telling me its found several errors in all the records, because of a
> > > validation rule. Tehre are no validation rules set, and ther are no
> > > formatting issues. At any rate, if i override it and allow it to import the
> > > data, it works fine. Id like to remove this problem, as the people who wil
> > > be using this database are not technical at all.
> > >
> > > 2. I've tried several different code snippets on the web and from MS's
> > > different affiliates, with no luck. I'm trying to make a very simple filter
> > > so that by selecting one of the (NON duplicates) on the list box, all of the
> > > records are filtered to show only those with the same value as the list box.
> > >
> > > 3. Exporting data onto a web form.. . this one needs lots of help. I have
> > > not yet built the form, but I intend to have it served from a secure server
> > > from my workplace. My options are, what is currently done, whihc is
> > > exporting the results to a spreadsheet and emailing it to everyone, and what
> > > i want to do, whihc is create a webpage they can look at online, with no user
> > > permissions except to read the records, using the same sorting method as
> > > above.
> > > 4. In one of my Yes/No fields, it defaults to a value of 0, even though i
> > > have none of the default values set. When i went back and changed all the
> > > defaults to "No", it still insists on placing a zero if one clicks on a Null
> > > field, in order to enter "yes" or "no"
> > >
> > >
> > > I imagine someone will want a copy of some part of my database. I can
> > > provide that, but as the records are secure, i wil have to clear them out.
> > >
> > >

All right. now i'm getting an error for a Data type criteria mismatch.

i have:
Me.Filter = "[Sap Company Code] = '" & Me.saplistboxcontrol.Text & "'"
Me.FilterOn = True


where sap company code is the name of the field i wish to display the values
that one has an option to filter by
and the saplistboxcontrol is the name of the list box itself.
I need it to only show one of each value that exists in that field. No
duplicates.
I also need it to actually do the filtering. it shows a filter being on when
looking at the record controls, but its moving through all the records, not
just the ones its filtered.


I'm unsure how to proceed with making the data transfer on the append table
work properly. I don't see why those required fields are causing trouble at
all. Could i simply supply you with a copy of the database and have you look
yourself? Perhaps i'm just poor at describing my problems here.

"Pwyd" wrote:

> Yes, in fact there are four required fields. The data the appendtable is
> providing includes those fields, and none of them are empty, nor do they
> break any of those rules.
>
>
> "Lance" wrote:
>
> > 1) What is probably happening is one of your fields has the "Required" option
> > set to true. Any records which have no value for that field will return a
> > validation error. It's very possible it's not working correctly, as it will
> > reject those records and you could be losing data you need. You can block
> > this error message by running the queries in a macro or VB code and setting
> > setwarnings to false... although making it handle your data more reliably
> > would be a better choice, if possible.
> >
> > 2) Use a combo box, and try code similar to this:
> >
> > Private Sub Combo10_Click()
> > Me.Filter = "[Field1] = '" & Me.Combo10.Text & "'"
> > Me.FilterOn = True
> > End Sub
> >
> > 3. Can't help you much here.
> >
> > 4. 0 = No = False. Defaulting it to no will set the value to 0. Having no
> > default value set.. will default it to no, which defaults it to 0.
> >
> >
> > "Pwyd" wrote:
> >
> > > I need some help with several problems --
> > > 1. When i'm importing records through a query, using an append table, its
> > > telling me its found several errors in all the records, because of a
> > > validation rule. Tehre are no validation rules set, and ther are no
> > > formatting issues. At any rate, if i override it and allow it to import the
> > > data, it works fine. Id like to remove this problem, as the people who wil
> > > be using this database are not technical at all.
> > >
> > > 2. I've tried several different code snippets on the web and from MS's
> > > different affiliates, with no luck. I'm trying to make a very simple filter
> > > so that by selecting one of the (NON duplicates) on the list box, all of the
> > > records are filtered to show only those with the same value as the list box.
> > >
> > > 3. Exporting data onto a web form.. . this one needs lots of help. I have
> > > not yet built the form, but I intend to have it served from a secure server
> > > from my workplace. My options are, what is currently done, whihc is
> > > exporting the results to a spreadsheet and emailing it to everyone, and what
> > > i want to do, whihc is create a webpage they can look at online, with no user
> > > permissions except to read the records, using the same sorting method as
> > > above.
> > > 4. In one of my Yes/No fields, it defaults to a value of 0, even though i
> > > have none of the default values set. When i went back and changed all the
> > > defaults to "No", it still insists on placing a zero if one clicks on a Null
> > > field, in order to enter "yes" or "no"
> > >
> > >
> > > I imagine someone will want a copy of some part of my database. I can
> > > provide that, but as the records are secure, i wil have to clear them out.
> > >
> > >

is [Sap Company Code] a numeric field?

"Pwyd" wrote:

> All right. now i'm getting an error for a Data type criteria mismatch.
>
> i have:
> Me.Filter = "[Sap Company Code] = '" & Me.saplistboxcontrol.Text & "'"
> Me.FilterOn = True
>
>
> where sap company code is the name of the field i wish to display the values
> that one has an option to filter by
> and the saplistboxcontrol is the name of the list box itself.
> I need it to only show one of each value that exists in that field. No
> duplicates.
> I also need it to actually do the filtering. it shows a filter being on when
> looking at the record controls, but its moving through all the records, not
> just the ones its filtered.
>
>
> I'm unsure how to proceed with making the data transfer on the append table
> work properly. I don't see why those required fields are causing trouble at
> all. Could i simply supply you with a copy of the database and have you look
> yourself? Perhaps i'm just poor at describing my problems here.
>
> "Pwyd" wrote:
>
> > Yes, in fact there are four required fields. The data the appendtable is
> > providing includes those fields, and none of them are empty, nor do they
> > break any of those rules.
> >
> >
> > "Lance" wrote:
> >
> > > 1) What is probably happening is one of your fields has the "Required" option
> > > set to true. Any records which have no value for that field will return a
> > > validation error. It's very possible it's not working correctly, as it will
> > > reject those records and you could be losing data you need. You can block
> > > this error message by running the queries in a macro or VB code and setting
> > > setwarnings to false... although making it handle your data more reliably
> > > would be a better choice, if possible.
> > >
> > > 2) Use a combo box, and try code similar to this:
> > >
> > > Private Sub Combo10_Click()
> > > Me.Filter = "[Field1] = '" & Me.Combo10.Text & "'"
> > > Me.FilterOn = True
> > > End Sub
> > >
> > > 3. Can't help you much here.
> > >
> > > 4. 0 = No = False. Defaulting it to no will set the value to 0. Having no
> > > default value set.. will default it to no, which defaults it to 0.
> > >
> > >
> > > "Pwyd" wrote:
> > >
> > > > I need some help with several problems --
> > > > 1. When i'm importing records through a query, using an append table, its
> > > > telling me its found several errors in all the records, because of a
> > > > validation rule. Tehre are no validation rules set, and ther are no
> > > > formatting issues. At any rate, if i override it and allow it to import the
> > > > data, it works fine. Id like to remove this problem, as the people who wil
> > > > be using this database are not technical at all.
> > > >
> > > > 2. I've tried several different code snippets on the web and from MS's
> > > > different affiliates, with no luck. I'm trying to make a very simple filter
> > > > so that by selecting one of the (NON duplicates) on the list box, all of the
> > > > records are filtered to show only those with the same value as the list box.
> > > >
> > > > 3. Exporting data onto a web form.. . this one needs lots of help. I have
> > > > not yet built the form, but I intend to have it served from a secure server
> > > > from my workplace. My options are, what is currently done, whihc is
> > > > exporting the results to a spreadsheet and emailing it to everyone, and what
> > > > i want to do, whihc is create a webpage they can look at online, with no user
> > > > permissions except to read the records, using the same sorting method as
> > > > above.
> > > > 4. In one of my Yes/No fields, it defaults to a value of 0, even though i
> > > > have none of the default values set. When i went back and changed all the
> > > > defaults to "No", it still insists on placing a zero if one clicks on a Null
> > > > field, in order to enter "yes" or "no"
> > > >
> > > >
> > > > I imagine someone will want a copy of some part of my database. I can
> > > > provide that, but as the records are secure, i wil have to clear them out.
> > > >
> > > >

Gimme an email address, i'll send you a copy of it. There are no fields that
allow zero length that violate the data that is being given to it. The only
fields being appended have data in them. the rest of them aren't being
touched.


"Lance" wrote:

> Well.. along the same line. Do you have any fields with "allow zero length"
> set to no and data which violates it?
>
> "Pwyd" wrote:
>
> > Yes, in fact there are four required fields. The data the appendtable is
> > providing includes those fields, and none of them are empty, nor do they
> > break any of those rules.
> >
> >
> > "Lance" wrote:
> >
> > > 1) What is probably happening is one of your fields has the "Required" option
> > > set to true. Any records which have no value for that field will return a
> > > validation error. It's very possible it's not working correctly, as it will
> > > reject those records and you could be losing data you need. You can block
> > > this error message by running the queries in a macro or VB code and setting
> > > setwarnings to false... although making it handle your data more reliably
> > > would be a better choice, if possible.
> > >
> > > 2) Use a combo box, and try code similar to this:
> > >
> > > Private Sub Combo10_Click()
> > > Me.Filter = "[Field1] = '" & Me.Combo10.Text & "'"
> > > Me.FilterOn = True
> > > End Sub
> > >
> > > 3. Can't help you much here.
> > >
> > > 4. 0 = No = False. Defaulting it to no will set the value to 0. Having no
> > > default value set.. will default it to no, which defaults it to 0.
> > >
> > >
> > > "Pwyd" wrote:
> > >
> > > > I need some help with several problems --
> > > > 1. When i'm importing records through a query, using an append table, its
> > > > telling me its found several errors in all the records, because of a
> > > > validation rule. Tehre are no validation rules set, and ther are no
> > > > formatting issues. At any rate, if i override it and allow it to import the
> > > > data, it works fine. Id like to remove this problem, as the people who wil
> > > > be using this database are not technical at all.
> > > >
> > > > 2. I've tried several different code snippets on the web and from MS's
> > > > different affiliates, with no luck. I'm trying to make a very simple filter
> > > > so that by selecting one of the (NON duplicates) on the list box, all of the
> > > > records are filtered to show only those with the same value as the list box.
> > > >
> > > > 3. Exporting data onto a web form.. . this one needs lots of help. I have
> > > > not yet built the form, but I intend to have it served from a secure server
> > > > from my workplace. My options are, what is currently done, whihc is
> > > > exporting the results to a spreadsheet and emailing it to everyone, and what
> > > > i want to do, whihc is create a webpage they can look at online, with no user
> > > > permissions except to read the records, using the same sorting method as
> > > > above.
> > > > 4. In one of my Yes/No fields, it defaults to a value of 0, even though i
> > > > have none of the default values set. When i went back and changed all the
> > > > defaults to "No", it still insists on placing a zero if one clicks on a Null
> > > > field, in order to enter "yes" or "no"
> > > >
> > > >
> > > > I imagine someone will want a copy of some part of my database. I can
> > > > provide that, but as the records are secure, i wil have to clear them out.
> > > >
> > > >

yes, its numeric. why should that matter?


"Lance" wrote:

> is [Sap Company Code] a numeric field?
>
> "Pwyd" wrote:
>
> > All right. now i'm getting an error for a Data type criteria mismatch.
> >
> > i have:
> > Me.Filter = "[Sap Company Code] = '" & Me.saplistboxcontrol.Text & "'"
> > Me.FilterOn = True
> >
> >
> > where sap company code is the name of the field i wish to display the values
> > that one has an option to filter by
> > and the saplistboxcontrol is the name of the list box itself.
> > I need it to only show one of each value that exists in that field. No
> > duplicates.
> > I also need it to actually do the filtering. it shows a filter being on when
> > looking at the record controls, but its moving through all the records, not
> > just the ones its filtered.
> >
> >
> > I'm unsure how to proceed with making the data transfer on the append table
> > work properly. I don't see why those required fields are causing trouble at
> > all. Could i simply supply you with a copy of the database and have you look
> > yourself? Perhaps i'm just poor at describing my problems here.
> >
> > "Pwyd" wrote:
> >
> > > Yes, in fact there are four required fields. The data the appendtable is
> > > providing includes those fields, and none of them are empty, nor do they
> > > break any of those rules.
> > >
> > >
> > > "Lance" wrote:
> > >
> > > > 1) What is probably happening is one of your fields has the "Required" option
> > > > set to true. Any records which have no value for that field will return a
> > > > validation error. It's very possible it's not working correctly, as it will
> > > > reject those records and you could be losing data you need. You can block
> > > > this error message by running the queries in a macro or VB code and setting
> > > > setwarnings to false... although making it handle your data more reliably
> > > > would be a better choice, if possible.
> > > >
> > > > 2) Use a combo box, and try code similar to this:
> > > >
> > > > Private Sub Combo10_Click()
> > > > Me.Filter = "[Field1] = '" & Me.Combo10.Text & "'"
> > > > Me.FilterOn = True
> > > > End Sub
> > > >
> > > > 3. Can't help you much here.
> > > >
> > > > 4. 0 = No = False. Defaulting it to no will set the value to 0. Having no
> > > > default value set.. will default it to no, which defaults it to 0.
> > > >
> > > >
> > > > "Pwyd" wrote:
> > > >
> > > > > I need some help with several problems --
> > > > > 1. When i'm importing records through a query, using an append table, its
> > > > > telling me its found several errors in all the records, because of a
> > > > > validation rule. Tehre are no validation rules set, and ther are no
> > > > > formatting issues. At any rate, if i override it and allow it to import the
> > > > > data, it works fine. Id like to remove this problem, as the people who wil
> > > > > be using this database are not technical at all.
> > > > >
> > > > > 2. I've tried several different code snippets on the web and from MS's
> > > > > different affiliates, with no luck. I'm trying to make a very simple filter
> > > > > so that by selecting one of the (NON duplicates) on the list box, all of the
> > > > > records are filtered to show only those with the same value as the list box.
> > > > >
> > > > > 3. Exporting data onto a web form.. . this one needs lots of help. I have
> > > > > not yet built the form, but I intend to have it served from a secure server
> > > > > from my workplace. My options are, what is currently done, whihc is
> > > > > exporting the results to a spreadsheet and emailing it to everyone, and what
> > > > > i want to do, whihc is create a webpage they can look at online, with no user
> > > > > permissions except to read the records, using the same sorting method as
> > > > > above.
> > > > > 4. In one of my Yes/No fields, it defaults to a value of 0, even though i
> > > > > have none of the default values set. When i went back and changed all the
> > > > > defaults to "No", it still insists on placing a zero if one clicks on a Null
> > > > > field, in order to enter "yes" or "no"
> > > > >
> > > > >
> > > > > I imagine someone will want a copy of some part of my database. I can
> > > > > provide that, but as the records are secure, i wil have to clear them out.
> > > > >
> > > > >

I'm afraid I wouldn't be allowed to open it, against company security rules.

And silly question.. but when you say "the only fields being appended" do
you mean the fields that actually make it into your final table, or all the
fields in the initial table you're trying to add?

"Pwyd" wrote:

> Gimme an email address, i'll send you a copy of it. There are no fields that
> allow zero length that violate the data that is being given to it. The only
> fields being appended have data in them. the rest of them aren't being
> touched.
>
>
> "Lance" wrote:
>
> > Well.. along the same line. Do you have any fields with "allow zero length"
> > set to no and data which violates it?
> >
> > "Pwyd" wrote:
> >
> > > Yes, in fact there are four required fields. The data the appendtable is
> > > providing includes those fields, and none of them are empty, nor do they
> > > break any of those rules.
> > >
> > >
> > > "Lance" wrote:
> > >
> > > > 1) What is probably happening is one of your fields has the "Required" option
> > > > set to true. Any records which have no value for that field will return a
> > > > validation error. It's very possible it's not working correctly, as it will
> > > > reject those records and you could be losing data you need. You can block
> > > > this error message by running the queries in a macro or VB code and setting
> > > > setwarnings to false... although making it handle your data more reliably
> > > > would be a better choice, if possible.
> > > >
> > > > 2) Use a combo box, and try code similar to this:
> > > >
> > > > Private Sub Combo10_Click()
> > > > Me.Filter = "[Field1] = '" & Me.Combo10.Text & "'"
> > > > Me.FilterOn = True
> > > > End Sub
> > > >
> > > > 3. Can't help you much here.
> > > >
> > > > 4. 0 = No = False. Defaulting it to no will set the value to 0. Having no
> > > > default value set.. will default it to no, which defaults it to 0.
> > > >
> > > >
> > > > "Pwyd" wrote:
> > > >
> > > > > I need some help with several problems --
> > > > > 1. When i'm importing records through a query, using an append table, its
> > > > > telling me its found several errors in all the records, because of a
> > > > > validation rule. Tehre are no validation rules set, and ther are no
> > > > > formatting issues. At any rate, if i override it and allow it to import the
> > > > > data, it works fine. Id like to remove this problem, as the people who wil
> > > > > be using this database are not technical at all.
> > > > >
> > > > > 2. I've tried several different code snippets on the web and from MS's
> > > > > different affiliates, with no luck. I'm trying to make a very simple filter
> > > > > so that by selecting one of the (NON duplicates) on the list box, all of the
> > > > > records are filtered to show only those with the same value as the list box.
> > > > >
> > > > > 3. Exporting data onto a web form.. . this one needs lots of help. I have
> > > > > not yet built the form, but I intend to have it served from a secure server
> > > > > from my workplace. My options are, what is currently done, whihc is
> > > > > exporting the results to a spreadsheet and emailing it to everyone, and what
> > > > > i want to do, whihc is create a webpage they can look at online, with no user
> > > > > permissions except to read the records, using the same sorting method as
> > > > > above.
> > > > > 4. In one of my Yes/No fields, it defaults to a value of 0, even though i
> > > > > have none of the default values set. When i went back and changed all the
> > > > > defaults to "No", it still insists on placing a zero if one clicks on a Null
> > > > > field, in order to enter "yes" or "no"
> > > > >
> > > > >
> > > > > I imagine someone will want a copy of some part of my database. I can
> > > > > provide that, but as the records are secure, i wil have to clear them out.
> > > > >
> > > > >

You get data type criteria mismatch errors when you're trying to compare two
values with different data types, in this case the numeric [Sap Company Code]
field with a string from your textbox. We were actually forcing the result
to string by putting it in quotes.. easy enough to fix. Try:

Me.Filter = "[Sap Company Code] = " & Me.saplistboxcontrol.Text

"Pwyd" wrote:

> yes, its numeric. why should that matter?
>
>
> "Lance" wrote:
>
> > is [Sap Company Code] a numeric field?
> >
> > "Pwyd" wrote:
> >
> > > All right. now i'm getting an error for a Data type criteria mismatch.
> > >
> > > i have:
> > > Me.Filter = "[Sap Company Code] = '" & Me.saplistboxcontrol.Text & "'"
> > > Me.FilterOn = True