p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Access (http://p2p.wrox.com/forumdisplay.php?f=18)
-   -   "Object Required" message (http://p2p.wrox.com/showthread.php?t=9102)

chacquard February 9th, 2004 12:00 AM

"Object Required" message

I've been working on a form that contains a subform. The fields in the main form are EvendId, EventName, Date, time, place, etc.. These fields cannot be edited (locked = yes and activated = no)

In the subform the fields are EventId, TicketNo, Qty, Section, Row, Seat,etc...
I use this subform to see the list of tickets for the event and to add new tickets. When I open my form, the focus goes to the last record. Then, if I want to close the form or undo, I have a "Object Required" message by Microsoft Access. I double checked all of my fields. They all allow null value or an empty string.

The form and subform allow additions, edits and deletions.

I don't know where to look anymore... please help me... :(


(Sorry if some of the terms are not right, I use a french version of Access)

joefawcett February 9th, 2004 10:24 AM

Do you have code in the event handlers that run when the form closes? Have you spelt EventId consistently across the database and code, it's not in your post?



chacquard February 9th, 2004 12:50 PM

Hi Joe,

There is no code in the Close Event, besides the docmd.close, and yes, i spelt the EventId consistently across the database and code.


All times are GMT -4. The time now is 10:48 AM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.