Having trouble editing data in form

[psalmon]

I have a form to edit records. When I open the form I am not able to change any of the fields until I edit a date field that has a calendar popup on the "on click" event. After that all of the fields are available for editing. Any ideas??
Thanks,
Pat

 

[Mile-O]

Is the AllowEdits property of the form set to True or False?

 

[psalmon]

This property is set to "Yes"

 

[godofhell]

It appears that the date field is triggering the new record. I believe your query definitation is causing this problem. You might also check the default value for the date field, it might have a value set. To fix the problem you could write code on the on open event so that it runs the code that is behind the calendar control, this will open the form at the point that you use the calendar control, you could also simply have it right the current date on that field.

Form OnOpen()
myfield.Value= Date

 

[psalmon]

The date field isn't triggering a new record. When I edit the date field on an existing record, the other fields become editable. Before I edit the date the other fields have the appearance of being editable, but they are not. When I scroll through the records and attempt to make a change (before editing the date) by clicking into a field and trying to add text, the form pops back to record #1 every time, not matter which field I try to edit. I am attaching a sample of my db. the form I am having trouble with is "frmMaintainWorkOrderDatabase", the date field on this form that seems to open the fields is "Closed By".

Thanks,
Pat

 

[jrjr]

You forgot the attachment

 

[psalmon]

Oops, Thanks

It was too big. I have removed alot of the supporting tables so the combo boxes won't work. Just try to edit the text fields.

 

[jrjr]

In the form's properties under the On Dirty, comment out the....

DoCmd.Requery

so that it looks like this:
'DoCmd.Requery

Then things seem to work correctly

 

[psalmon]

Thank you so much!!! Can you explain why that behaved the way it did?

 

[jrjr]

My pleasure

It seemed that when you tried to enter something into a field, the form was refreshing and the cursor was returned to the beginning of the tab order again. On dirty means roughly.... has data or has something entered into it.

 

[psalmon]

Oh, I see. Thanks again!

 

[godofhell]

It goes to show that working with the actual database is a lot easier than trying to picture it. Good job JRJR.