Subject: "Object Required" message
Posted By: chacquard Post Date: 2/8/2004 11:00:36 PM
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)

Reply By: joefawcett Reply Date: 2/9/2004 9:24:44 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
Reply By: chacquard Reply Date: 2/9/2004 11:50:35 AM
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


Go to topic 9557

Return to index page 953
Return to index page 952
Return to index page 951
Return to index page 950
Return to index page 949
Return to index page 948
Return to index page 947
Return to index page 946
Return to index page 945
Return to index page 944