Search results

Great. Thanks for the all the help. Pete

Thanks. So when is the oncurrent triggered?

thanks guys you were right about being dirty. All working perfectly. I changed the openreport parameters as suggested too. regards Pete

Nope doesn't help it wasn't dirty if I do "DoCmd.RunCommand acCmdSaveRecord" I get "the command or action saverecord isn't available now" I assume the form has a lock or something like that so I assume I need to trigger the save method on the form or something like that but then I need to run...

When I create a new record using the default navigation bar it does not become real till something has been entered and it has been save to the table. How can I check the status of the current displayed data to see if it actually exists in the table (has been save)? My current problem is that...

How do I delete a record in form view using the default record navigation bar? I have set allow deletions=true Thanks

It's OK. I spotted it. =DLookup("[Address Line 1]", "Quotes", "[Unique key] = " & DMax("[Unique key]", "Quotes")) works great, thanks Pete One question though If I wanted to do this in VBA code in an event, where would be the best place to put it to achieve the same thing? I prefer doing...

Thanks Pete Table "Quotes" includes Unique Key Autonumber Address Line 1 Text I have set the default value property of "Address Line 1" to the following =DLookUp("Address Line 1","Quotes","Unique key = " & (DMax,"Unique key","Quotes")) Nothing happens, what have I done wrong? Thanks Pete

Hi I expect this is very simple when you know how I have some address fields displayed on a form, when the user adds a new record (via the default record selector) I want the screen to display a new blank record but have the address fields should default to the values from the previous record...