MACRO TO SET RECORD SOURCE ON FORM

  • Thread starter Thread starter brennon
  • Start date Start date
B

brennon

Is there a way to use a wild card in the record source
for forms/reports. for example have the record source
be '*SM' meaning as long as the table ends in 'SM' then
use it?
 
Hi Brennon,

You can't. Imagine you have the following tables in your database

aaaSM
bbbSM
cccSM
zzzSM

How would Microsoft Access know which one to choose?

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: "brennon" <[email protected]>
| Sender: "brennon" <[email protected]>
| Subject: MACRO TO SET RECORD SOURCE ON FORM
| Date: Wed, 24 Mar 2004 07:28:02 -0800
| Lines: 5
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcQRtJjSMvOyW4aaR2usS8myNUrrJA==
| Newsgroups: microsoft.public.access.macros
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.access.macros:30785
| NNTP-Posting-Host: tk2msftngxa08.phx.gbl 10.40.1.160
| X-Tomcat-NG: microsoft.public.access.macros
|
| Is there a way to use a wild card in the record source
| for forms/reports. for example have the record source
| be '*SM' meaning as long as the table ends in 'SM' then
| use it?
|
|
 
Back
Top