wizcow
Registered User.
- Local time
- Yesterday, 18:44
- Joined
- Sep 22, 2001
- Messages
- 236
Hello
I have a Subform (on an Invoice form) that I have been using a table as the record source. The sub form is set to datasheet. I have been also using a bunch of dlookups on the subform.
I want to get rid of the dlookups, so I made a query that does the job.
My problem is... now that the query is the record source for the subform I can no longer use it as data entry, as it only displays records already in the table.
Is there a way to force the query to give me an empty record, so I can add data?
Tom
I have a Subform (on an Invoice form) that I have been using a table as the record source. The sub form is set to datasheet. I have been also using a bunch of dlookups on the subform.
I want to get rid of the dlookups, so I made a query that does the job.
My problem is... now that the query is the record source for the subform I can no longer use it as data entry, as it only displays records already in the table.
Is there a way to force the query to give me an empty record, so I can add data?
Tom
