Help with "memo" field in Purchase Order subform

[mthornblad]

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]

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.

 

[mthornblad]

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.

Steve

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

Mark