Access 2007: Create a form for both display and data entry purposes

5 pts.
Tags:
Access 2007 forms
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

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Neilo
    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
    125 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following