Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / December 2007

Tip: Looking for answers? Try searching our database.

Help with "memo" field in Purchase Order subform

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
mthornblad@gmail.com - 03 Dec 2007 05:47 GMT
Hi

I have a form/subform for entering vendor purchase orders.  I would
like to be able to optionally enter info (in a memo field) for each
line item in the subform.  For example, one of the p.o. line items
might be a "special order" for a customer.  I would like to be able to
enter the customer's phone number and other information about the
customer for that line item.

Ideally, I would like to click a field on a line item in the subform
and have a "window" pop up that would allow me to enter the customer
information.  After entering the info, I would press the 'Esc' key (or
something similar) that would close the "window" and return me to the
subform to continue entering the p.o. data.

Is this possible ?  Or is there another way I could do this ?

I would appreciate any help or suggestions.

Thanks in advance
Mark
Steve Schapel - 03 Dec 2007 08:49 GMT
Mark,

First of all, you need a control on the detail section of the form,
bound to the memo field.  If you don't want to see it on the form,
that's fine, just make it very small, but it needs to be there for this
code to work:
   Me.NameOfMemoControl.SetFocus
   DoCmd.RunCommand acCmdZoomBox

You could put a little command button on the form, or use the Click
event of one of the other controls on the form.

Signature

Steve Schapel, Microsoft Access MVP

> Hi
>
[quoted text clipped - 17 lines]
> Thanks in advance
> Mark
mthornblad@gmail.com - 03 Dec 2007 18:24 GMT
> Mark,
>
[quoted text clipped - 33 lines]
> > Thanks in advance
> > Mark

Steve

Thanks for your help.  I will give this a try.

Mark
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.