• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 284
  • Last Modified:

Make memo field from subform editable on main form

I have a subform with a memo field, column width set to 0". On my main form, I put a big text box with the rowsource subForm.Form!MemoFieldName. The idea was to have the memo field change as we switch records in the subform. But I want people to be able to edit the data as well. Is there a solution?

1Thanks!
0
TristanRyan
Asked:
TristanRyan
  • 4
  • 2
1 Solution
 
jjafferrCommented:
Hi TristanRyan,

Why don't you allow them to edit it in the SubForm itself?
you can always use the scrolls to navigate to the lower lines.

I usually make the memo field height so that it can show 2 lines of text.

Hope this helps

jaffer
0
 
TristanRyanAuthor Commented:
Thanks for the suggestion, but don't want to go that route -- the subform is in datasheet view, but the memo field contains a history, so we need to see quite a few lines.
T.
0
 
jjafferrCommented:
TristanRyan

I would Save that SubForm1 to SubForm2,
in SubForm2, delete all fields except MemoFieldName, make it as big as you like,
Remove all the borders from SubForm2, so that when placed on the Main Form along with SubForm1, it looks like a field on the Main Form.
Assign the Parent/Child relation like you did for SubForm1.

Now the Records will show as you move from 1 Record to another,
Any changes you make in MemoFieldName of SubForm2 WILL change your Table Record.

If you wanted to see the changes in MemoFieldName of SubForm1 (I know that is not the case with you, but others might require this functionality)
On Change/ or /On Losf Focus of MemoFieldName of SubForm2, place the command Refresh, so that changes show in MemoFieldName of SubForm1.

I hope this help,

jaffer
0
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

 
TristanRyanAuthor Commented:
Whoops ... sorry, forgot I had this question open.

T.
0
 
jjafferrCommented:
Thanks both,

Hey Jack
Have been seeing you cleaning more than dealing,
what's up?

jaffer
0
 
jadedataMS Access Systems CreatorCommented:
out straight on projects of my own...
0
 
jjafferrCommented:
Right on, Don't be away to long, we missed your posts you know ;o)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now