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.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!