[AccessD] Bind Form to RecordSet

Darryl Collins darryl at whittleconsulting.com.au
Mon Feb 25 17:29:26 CST 2013


Hahahaha... Yeah... Thought I could fire up a few of the old timers ;)  been a while...



-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
Sent: Tuesday, 26 February 2013 10:02 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Bind Form to RecordSet

IOW,  you used unbound forms in Access?   How Could You!!!!

Gee, we haven't had this discussion for a few years.  :-)

D,RFC

--
Stuart

On 25 Feb 2013 at 22:54, Darryl Collins wrote:

> True,
> 
> But what I used to do when using SQL server for similar things is to 
> download the SP data into a form and allow the user to edit the 
> unbound record and then use an update query to write it back into the 
> SQL BE database when they were ready.
> 
> The main trick is to ensure you pull down all of the supporting data 
> for the form as well (say to create valid combo box choices for that 
> selection et al).
> 
> It was very fast and worked well.
> 
> 

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com





More information about the AccessD mailing list