Search results

Are your forms bound to tables or queries of tables. It can make a difference. It should be a query.

I'm thinking you were getting the error because there was no record yet. It was not null!

If you use a different approach, maybe the AfterUpdate event, I believe it should work for either situation.

See if this link will get you started: http://www.baldyweb.com/CustomAutonumber.htm

What version are you using?

Is it also making a backup at the same time? If so, you may have some corruption. What version are you using? Have you tried a Repair Install?

Have you tried Debug.Print or MsgBox on the two proof(s)? See what is actually being returned.

Does each record have a PrimaryKey?

Easy for a human maybe but to so much for a computer. What is the Record Source for the Data Sheet? Do the records have a Primary Key? Unlike a spread sheet like Excel, a record in a RDBMS is not necessarily right next to the others except for display purposes.

How would you go about finding the previous reading?

Excellent.Glad we could be of assistance.

I'm not sure why the field "auto-populates" on creation but adding a If Me.NewRecord Then Me.YourControl = Now() to the BeforeUpdate event of the form will overwrite it.

Don't fill that control until the BeforeUpdate event of the form.

What do you consider the completion vs creation?

I never liked HyperLink fields as they are strange. I use Text fields and then use the Click or DoubleClick event of the TextBox to take the user where they want to go.

To what *type* of value are you setting those Control Sources?

Boy I thought you were from Urbana-Champaign Il. Glad to hear it is Mn. :D Welcome to the site and you will not be disappointed. There are a ton of great people here to assist in solving MS Access issues.

What does the SubForm look like when you bring it up by itself? What mode is it running in?

Let us know if you still need assistance. This is a solvable issue, probably with code.

Thanks for the update. Boy those Nulls can sure be a pest can't they?