Nero
Shop smart, shop S-Mart
- Local time
- Today, 17:25
- Joined
- Jan 8, 2002
- Messages
- 217
Hi,
Been away from Access for a long time so please bear with me.
I have a pop-up form which allows the user to open a main form based upon different queries.
The problem I'm having is the main form is opening but showing all records and not filtered.
If for example the user selects all records with a value of over £5000, when opened the form returns all records not just the filtered ones.
If I run the query on it's own it works fine showing me the filtered records.
Any ideas ?
Been away from Access for a long time so please bear with me.
I have a pop-up form which allows the user to open a main form based upon different queries.
The problem I'm having is the main form is opening but showing all records and not filtered.
If for example the user selects all records with a value of over £5000, when opened the form returns all records not just the filtered ones.
If I run the query on it's own it works fine showing me the filtered records.
Any ideas ?