Hi, I have designed a form for bill payment. Is it possible to view the data entered at the bottom of the form (for integrity check purposes?) I want the form to look something like a subform but i dont want the data to be populated into 2 tables, just one table. How do I do this? I want the data entry clerk to be able to view the last 10 records entered, on the same form. Please help.
One approach to think of is having a command button on your form which could open a separate summary form on demand that would provide a read-only view of the records and fields you wish to show (properties AllowEdits, AllowDeletions and AllowAdditions all set to No). You could base this form on a separate query of the billing table, sorted in descending order by reference and date, say (to show the most recent records first). This would not limit you to the last ten records, however, unless you used a SELECT TOP 10 in your form's query.
-Stewart
ps to be most useful such a form would be in datasheet or continuous forms view. Your command button code would also have to open the form using a filter to select only the bill records matching your current bill payer (filtering the relevant ID field).