Help - strange record entry

[matt beamish]

I have two subforms on my main form. Both subforms are very similar and comprise two fields each. Both have an After Update event set on one field to enter the current date into the other field.

In one form I can update a record, press F9 and everything is smooth - I can proceed to somewhere else.

In the second form, if I update a record, the date is entered in the second field, but with black background, and I have to focus on the field, press Enter and then Esc (in the right order) to be able to proceed. I have tried many things to stop this as it is slowing data entry (just when I am starting to feel abit sleep deprived with an early start ahead).

Any suggestions greatly appreciated.

Matt

 

[matt beamish]

no takers

OK, so no takers on this so far....
Just so I know is this because
a)my problem is badly phrased and it is not clear what I am asking
b)there is a very simple workaround that I should know but being a novice I dont know it?
c) This an access problem

If anyone would care to see the basic database structure, I would happily post it....

Please?!

Matt

 

[matt beamish]

Still no response to my problem.....

If no one can help specifically, can anyone give a general pointer on this problem. Can I view the VBA code underlying a form if the Macros have not been converted to VBA, or do they not exist in viewable code until a conversion to Module has taken place?

Thanks in advance

Matt

 

[modest]

Zip your database and add it as an attachment. Then we can see the problem first hand. If you have access rights to the VBA press ALT+F11. It could be that the user purposely makes you type that sequence of code, or this could just be an Access corruption error.

 

[matt beamish]

Thankyou modest - here it is. I wrote the database, so any problems are fundamentally my own (although I got help on one of the now obsolete modules)

On the "FCustDetails_Payments" Form are 2 subforms.

On the bills subform if a new record is entered in bill, date is entered by a Macro and the cursor jumps to the next record. Try the same on the Payments subform and the cursor locks up until Enter and then Escape are pressed.

thanks very much for your interest

Matt

 

[matt beamish]

Problem solved. My error seems to have resolved itself....I had an after update running on the whole form in addition to particular fields, and this is what was causing the confusion. Following removal, a compact and repair, and a reboot, things are behaving as they should.

However, I think that I introduced the global after update because of the cursor behaviour, so I am not convinced that I understand the errror's cause and solution.

Matt
Leicester