Solved

Adding a box for Remarks

Posted on 2014-12-16
8
110 Views
Last Modified: 2014-12-17
I need to add a text box?? to my form for the user comments--which means it sounds like a memo field.  But when I did my query I didn't include that has a field.  How do I put this into my form and tir to back to a table??
0
Comment
Question by:Jass Saini
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
8 Comments
 
LVL 18

Accepted Solution

by:
Simon earned 500 total points
ID: 40503706
1. add the memo field to your table or a new related table
2. add the field to your  query
3. drop the field onto your form and give it appropriate properties (scroll bar?)
0
 

Author Closing Comment

by:Jass Saini
ID: 40503824
Thanks..since its tied into my query it's not updating
0
 
LVL 18

Expert Comment

by:Simon
ID: 40503897
Hi, are you having a problem saving data from the memo field or from all fields on your form?
0
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 

Author Comment

by:Jass Saini
ID: 40504879
Yes...I have some fields that are tied back to the form and others are not...
0
 
LVL 18

Expert Comment

by:Simon
ID: 40505272
Check the query that you use to populate your form.
Did you first add the memo field to your table and then update the query to include the new field? Check that you haven't made a typo and just included a static item in your query instead of a column from the table.
0
 

Author Comment

by:Jass Saini
ID: 40505342
Sorry what do you mean by that "static item in your query "...I have that memo field in my table already..as I included into my subform..but now my boss wants it a part of my main form and my main form is based off the query.
0
 
LVL 18

Expert Comment

by:Simon
ID: 40505424
The subform and main form would usually be based on different queries and just linked together by the master/child relationship (common key fields) that you choose when you add the subform to the main form. If both are based on the same query I suspect that's the cause of your problem.
0
 

Author Comment

by:Jass Saini
ID: 40505656
Sorry again..I am new at this and this is the way I was taught.  The main form is based off the query and subform is from the table.  If I based it off the query then I am unable to enter data...this was my orginal problem when I found this website.  There are so many different ways of doing stuff...
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question