Access 2007: Create a form for both display and data entry purposes
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.
Software/Hardware used:
Microsoft Access 2007
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.
Software/Hardware used:
Microsoft Access 2007
ASKED:
August 4, 2010 2:23 AM
UPDATED:
August 4, 2010 7:26 PM
Answer Wiki:
Last Wiki Answer Submitted:
Be the first to answer this question.
All Answer Wiki Contributors:
Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.
You can create a front end with all the controls and backend written in VBA, that upon load prefills the information you want and the user finish can click on a button with again code behindthat will send act upon the request