Code text box value

  • Thread starter Thread starter Wayne
  • Start date Start date
W

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
 
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
|
 
Back
Top