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