Code text box value

[Wayne]

I have a sub form with a combo called PaperSize that that
uses the following query as its record source:

SELECT Print_Fee.PrintFeeID, Print_Fee.PrintTypeID,
Print_Fee.PaperSize FROM Print_Fee WHERE
(((Print_Fee.PrintTypeID)=[Forms]![PrintRequisition]![PrintReq_Subform]![Type]));

I also have a text box called PaperSizeDisplay that I want
display the PaperSize value from the Print_Fee table that
corresponds to the PrintFeeID recorded in the combo above.

I am thinking that maybe this can be done using the after
update event on the PrintSize combo. Can someone please
show me how this could be done.

Thanks

 

[Eric Butts [MSFT]]

Hi Wayne,

Have you tried in your textbox control:

=[Forms]![PrintRequisition]![PrintReq_Subform]![Type].column(2)

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support
(e-mail address removed)
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

This posting is provided "AS IS" with no warranties, and confers no rights


--------------------
| Content-Class: urn:content-classes:message
| From: "Wayne" <[email protected]>
| Sender: "Wayne" <[email protected]>
| Subject: Code text box value
| Date: Sat, 21 Aug 2004 04:05:23 -0700
| Lines: 17
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: quoted-printable
| X-Newsreader: Microsoft CDO for Windows 2000
| Thread-Index: AcSHbsGtWiLm9G/cR3OIh4xp2aR5fg==
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Newsgroups: microsoft.public.access.formscoding
| Path: cpmsftngxa10.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.access.formscoding:243137
| NNTP-Posting-Host: tk2msftngxa12.phx.gbl 10.40.1.164
| X-Tomcat-NG: microsoft.public.access.formscoding
|
| I have a sub form with a combo called PaperSize that that
| uses the following query as its record source:
| SELECT Print_Fee.PrintFeeID, Print_Fee.PrintTypeID,
| Print_Fee.PaperSize FROM Print_Fee WHERE
|
(((Print_Fee.PrintTypeID)=[Forms]![PrintRequisition]![PrintReq_Subform]![Typ
e]));
| I also have a text box called PaperSizeDisplay that I want
| display the PaperSize value from the Print_Fee table that
| corresponds to the PrintFeeID recorded in the combo above.
| I am thinking that maybe this can be done using the after
| update event on the PrintSize combo. Can someone please
| show me how this could be done.
| Thanks
|