L
lynn atkinson
When I filter SOME forms I do not get a drop down list of entries in that
field to choose from, I just get 'is null' 'is not null' as options.
One form I have just been working on has changed the way it filters to this
not-so-useful filter option from listing all the possible entries in that
field.
WHat I did was as follows:
The form originally only displayed data in controls from one table (post
details table) although the query the form was based on contained 2
tables(postdetailstbl and in the projectcodetbl). I have redesigned the form
and now it contains fields from both tables.
I have checked the option under the tools and in the Edit/Find tab have
checked that the options are all correctly set - ie all 'Show list of values
in....' are all ticked and the 'dont display lists where more than this
number read....' I have set this to 2000 which should be more than enough.
Does anyone have any ideas why this change to the form design should make
such a major change to the way it 'Finds'data.
(It has happened in other forms too - mainly noticed when I split the
database to front end and back end.)
I would be grateful for any help on this matter.
cheers
field to choose from, I just get 'is null' 'is not null' as options.
One form I have just been working on has changed the way it filters to this
not-so-useful filter option from listing all the possible entries in that
field.
WHat I did was as follows:
The form originally only displayed data in controls from one table (post
details table) although the query the form was based on contained 2
tables(postdetailstbl and in the projectcodetbl). I have redesigned the form
and now it contains fields from both tables.
I have checked the option under the tools and in the Edit/Find tab have
checked that the options are all correctly set - ie all 'Show list of values
in....' are all ticked and the 'dont display lists where more than this
number read....' I have set this to 2000 which should be more than enough.
Does anyone have any ideas why this change to the form design should make
such a major change to the way it 'Finds'data.
(It has happened in other forms too - mainly noticed when I split the
database to front end and back end.)
I would be grateful for any help on this matter.
cheers