Query based on records displayed

stephen81

Registered User.
Local time
Today, 00:03
Joined
Nov 27, 2002
Messages
198
I have a continuous form based on a query with the criteria as all records where a certain field is null. From this form, the user can fill in values for the null field. I then want to click a button on the first form to open another continuous form showing the same records so the user can go on to do something else. The problem I have though, is that if I base the second form on the same query as the first form, any records where the user has filled in a value for the previously empty field will now not be included in the query results. Is there a simple way of doing this?
 
I think you can CLONE the original forms recordset and use that. Search the forums on Recordset Clone.
 
OK. I've managed to do that now.
I used
me.recordset = Forms!OtherForm.recordset

Cheers
 

Users who are viewing this thread

Back
Top Bottom