 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms Programming / June 2007Form returns 0 records?
Hi! I'm using a method from Allen Browne's website ( http://allenbrowne.com/ser-24.html) to call values from fields in a previous record and use those as the default values for a new record. The form that I'd like to have those default values in, however, has only one record: the new one. The table the darn form is bound to has 15k+ records; how on earth does the form only have one? I'd appreciate any advice. Thanks in advance! I recall using something similar for Default Value on a new record, but it was using the same form going from an existing record to a new one. I took a look at what Allen Browne has posted on the link you gave. It looks like it should transfer any text from one form to any other form. So, it looks like you might have to debug the process using Break Points to see what is going on. Are you using this for only 1 field/default value? or multiple values/fields? If you are using it for 1 single value/field, then you can use the OpenArg options when calling the form and when opening the new form check for the OpenArg option and populate the field with it's value. >Hi! > [quoted text clipped - 6 lines] > >I'd appreciate any advice. Thanks in advance! The code's breaking right where it should- when it checks for a previous record from which to transfer values. The form only shows one record- the new one- hence, no values can be transferred from the (non-existant) previous record to the new one. I guess my question could be distilled: how do you get a form that currently only shows (contains?) one record to show more- or at the very least, the last record? Or is there a better way to do this, considering I'm trying to do this for ~8 fields? >I recall using something similar for Default Value on a new record, but it >was using the same form going from an existing record to a new one. [quoted text clipped - 14 lines] >> >>I'd appreciate any advice. Thanks in advance! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.