Query / Form Question

  • Thread starter Thread starter Joe
  • Start date Start date
J

Joe

Does anyone know of anyway to have sort of like 2 record
sources within a form. One recordset has to be read-only
because of where the information is being pulled (Some of
the information is being munipulated to change a designed
ID number to a name (from a employee master table)). The
other recordset is information that needs to be entered
for those fields that are read-only. Therefore this
recordset needs to be updateable.

Does anyone know a way to do this or a workaround. ANY
HELP WOULD BE GREATLY APPRECIATED!!!

Thanks,
Joe
 
Hi Joe,

(you have your reasons):
You can create a Recordset (ADO or DAO) on the OnLoad event of your Form

How to Bind Microsoft Access Forms to ADO Recordsets
http://support.microsoft.com/default.aspx?scid=kb;en-us;281998

ACC2000: Forms Based on ADO Recordsets Are Read-Only
http://support.microsoft.com/default.aspx?scid=kb;en-us;227053

If you are doing something like where one half of the Form is bound to
updateable recordset and the other half is bound to NON-updateable
recordset then you could just bind your Form to the updateable recordset.
And then on the OnLoad event Loop thru your Form's controls and assign
those ones you want to the NON-updateable recordset. So in theory you can
only bind to 1 Recordset in a Form. But you can have more than one
recordset loaded in memory (OnLoad event).

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


Regards,

Eric Butts
Microsoft Access Support

"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."




--------------------
| Content-Class: urn:content-classes:message
| From: "Joe" <[email protected]>
| Sender: "Joe" <[email protected]>
| Subject: Query / Form Question
| Date: Wed, 4 Feb 2004 09:23:23 -0800
| Lines: 14
| 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: AcPrQ5dkcKDSYd/hShuEJSW+oTHJhQ==
| Newsgroups: microsoft.public.access.formscoding
| Path: cpmsftngxa07.phx.gbl
| Xref: cpmsftngxa07.phx.gbl microsoft.public.access.formscoding:219177
| NNTP-Posting-Host: tk2msftngxa13.phx.gbl 10.40.1.165
| X-Tomcat-NG: microsoft.public.access.formscoding
|
| Does anyone know of anyway to have sort of like 2 record
| sources within a form. One recordset has to be read-only
| because of where the information is being pulled (Some of
| the information is being munipulated to change a designed
| ID number to a name (from a employee master table)). The
| other recordset is information that needs to be entered
| for those fields that are read-only. Therefore this
| recordset needs to be updateable.
|
| Does anyone know a way to do this or a workaround. ANY
| HELP WOULD BE GREATLY APPRECIATED!!!
|
| Thanks,
| Joe
|
 
Back
Top