The dreaded DING!

[Guest]

I set up a form and subform using the wizard. The subform displays related
data properly as I move from one record to the next on the form. But when I
attempt to enter a new record, DING is the sound I get.

I'm having a devil of a time with this. I've tried all sorts of Property
settings on the form, subform, and individual fields. I've searched Help and
Que's Using 2002. What am I missing?

Thank you.

 

[Allan Murphy]

I do not know if this works as I do not have speakers connected.

Select Tools ---> Options----> General

Then untick Provide feedback with sound.. Right click this box to see the
"what is this" comment

 

[Ken Snell \(MVP\)]

I'm guessing that the subform is based on a nonupdatable query... the Ding
that you hear is the "error" sound -- the "Default Windows Sound" in the
Windows setup -- because ACCESS cannot create a new record.

 

[Guest]

If your using relational tables and display the primary key from one table,
try changing it for the forign key in the other table.

 

[Guest]

Sorry, I wasn't clear. The DING is not the problem. I can't update the
subform. See message below.

 

[Guest]

Thanks. I describe the problem in more detail below.

 

[Guest]

Sorry, I wasn't clear. The DING is not the problem. I can't update the
subform. See message below.

 

[Guest]

I'll describe this in more detail:

I set up a form (Author name) and subform (with author recording information
- one record per recording) using the wizard. The subform successfully
displays audio recording information related to the main form (Author name)
as I move from one Author record to the next on the main form. So the
relationship between the forms works properly.

Here's the problem:
I can successfully add a new Author on the main form using the Record
Selector at the bottom of the window, BUT I can NOT enter data in a new
subform record (ie a new recording for the Author.) I don't get an error
message, just the ding telling me it's not allowed.

Why can't I add information to a new subform record?

Thank you.

 

[Guest]

Credit DM! It wasn't workiing because key fields weren't included.

Peace all and thanks.

 

[Douglas J Steele]

Sounds as though you've set up referential integrity so that you can't add a
record related to the Author before a row exists for the Author in the
Author table. That's the way things should be.

 

[Guest]

Thankyou. Good luck with your project.