How can I create a form that is autofilled with data from a query (such as a client's ID and balance), and will also be used for data entry for another field from a table not part of the query (the amount paid by the client and the current date)?
I tried to use a subform for the data entry but (a) I couldn't get rid of the scrollbars, even by changing the subform properties, and (b) the subform simply displayed all the previous payments made by the client -- I want to enter a new record using a control that looks like a regular textbox. Did I go about this the wrong way?
Any help is appreciated; I can clarify further if need be.
Microsoft Access 2007
August 4, 2010 2:23 AM
August 4, 2010 7:26 PM