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
 
Hi,

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... :(

Chantal

(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?

--

Joe

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.

Chantal



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

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