How do I check the status of the current record

[tgbyhn10]

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 I am calling a query / report to print the current record but if it's a new record and not save the print routine crashes. I want to disable the print button if the until the record exists.

Thanks

Pete

 

[RuralGuy]

Try: If Me.Dirty Then Me.Dirty = False
...before you call the print routine.

 

[tgbyhn10]

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 my print routine after.

When i press a command button I'm trying print the current record but it has not been saved yet so how do I save and then call my report as follows?

If Not IsNull(Me![txtUniquekey]) Then
DoCmd.OpenReport "Quotations Report", acViewNormal, "where [uniquekey] = " & Str(Me![txtUniquekey])
end if

txtUniquekey is a field on the form bound to a primary key autonumber field on the table

Any ideas?

help....

 

[RuralGuy]

The WhereCondition argument does *not* include the word WHERE!
DoCmd.OpenReport "Quotations Report", , "[uniquekey] = " & Me.txtUniquekey
...and there is no reason to convert that field to a string.

 

[missinglinq]

If the record isn't Dirty, no data has been entered! Me.Dirty = False (as in RuralGuy's code) forces the record to be saved. The only way for

If Me.Dirty Then Me.Dirty = False

to fail to save the record would be if the record weren't Dirty, i.e. no data had been entered!

 

[RuralGuy]

MissingLinq,
I believe the OP's problem was the WhereCondition argument all along.

 

[tgbyhn10]

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

regards

Pete

 

[RuralGuy]

You're welcome. Glad you got it sorted.