Penn White
penn227 at yahoo.com
Wed May 4 16:35:31 CDT 2005
Thanks for all the help. Let me play with this tonight now that I have some new ideas, thanks to you all, and see if I can get it to work. Penn ----- Original Message ----- From: "Stuart McLachlan" <stuart at lexacorp.com.pg> To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Sent: Wednesday, May 04, 2005 2:18 PM Subject: Re: [AccessD] Fill in some fields in a new record withoutcreatinganewrecord? > On 4 May 2005 at 19:53, Gustav Brock wrote: > >> >> Thank you for the suggestion. That would be fine if I >> wanted to add a new >> record. The problem really arises when I'm >> accidentally in a new record (I >> hit the * button in the record selector) but don't >> really want to add a new >> record. If I attempt to move from that 'new empty' >> record, I can't get out >> of it. > > Get rid of that code that sets values in the On_Current and set the > "Default Value"s of the fields to the lookup functions instead. That way > they only get filled in when soemone starts to enter data. > > > > > -- > Stuart > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com