Filtering from same table

  • Thread starter Thread starter Access Newbie
  • Start date Start date
A

Access Newbie

Not sure how to explaing this, so here goes...
I want to have a button open a memo field instead of
having the field on the form with the rest of the
information, so that it can be larger or the same size as
the form (almost like a notepad effect). I'm assuming that
I need to have some kind of filter in place to keep the
records in sync, but I can't figure out how to do it.

I have the memo field in the same table as the rest of the
information.

Could someone tell me how to do this?
 
Just add a criteria when opening the second form.

DoCmd.OpenForm "Form2",,"ID=" & "txtID"

Where Form2 is the name of the second form and txtID is the name of the
field on the first form with the linking information such as the primary
key. If txtID is text modify the above to:

DoCmd.OpenForm "Form2",,"ID='" & "txtID" & "'"

Note additional single quotes '.

Kelvin
 
Not sure how to explaing this, so here goes...
I want to have a button open a memo field instead of
having the field on the form with the rest of the
information, so that it can be larger or the same size as
the form (almost like a notepad effect). I'm assuming that
I need to have some kind of filter in place to keep the
records in sync, but I can't figure out how to do it.

I have the memo field in the same table as the rest of the
information.
Click to expand...

The simplest way would be to put a Tab control on the Form; put all
the textboxes and other controls for the other fields on one page of
the tab, and a single big textbox for the memo field on the second.
 
Back
Top