Data Not Visible in Form after inserting

B

Bill

I have built a form with a subform. All the form does is hold the sub form - the sub form is a datasheet that is updateable and supports inserts

Anyway, when I insert a record in the data sheet (sub form), I then get an error message that the data has been inserted into the database but is not displayable because it does not meet the criteria of the form

I can update the records without any error message. If I close the form and re-open it, all the records are displayed including the record(s) I just entered

How do I get rid of the error message and keep the newly inserted record in the datasheet.

Bill
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Inserting a beginning record in a subform 2
Strange behavior and Error 2105 when oncurrent event cycles 0
Form_Delete event can't fire requery in other form 1
Refresh data in sub forms when one sub form is edited 8
Duplicate record in Form and Subform 0
Bookmark not working on subform 5
selecting a record from continuous form 3
sync data on data field from key field in the sub form 0

Top