Stumped, need help. Access 2007 Requiring Data in a form

[RuralGuy]

You are ignoring the (New) record, right?

[Moridan]

You are ignoring the (New) record, right?

The new record that is created in my table? Every time I use the edit function I have a new line item entry in my table. It would be a nightmare to have to do it afterwards.

[RuralGuy]

Are you opening the table directly to check for proper edits and extra records?

[Moridan]

Are you opening the table directly to check for proper edits and extra records?

Yes. That is correct.

[RuralGuy]

The record count increases every time you open that edit form right?

[Moridan]

The record count increases every time you open that edit form right?

Yes, it adds another <AutoNumber> entry every time you edit something on the Edit form.

[RuralGuy]

I'm sorry for asking what appears to be stupid question occasionally, but without a db to look at I'm grasping sometimes. We've established that the SubForm when in stand alone mode does *not* create this extra record. It occurs *only* when displayed on another form with a SubFormControl. Do you have anything in the SubFormControl's LinkMaster/ChildFields properties?

[Moridan]

There are no stupid questions. I am the un-educated one here. 9-)

Opening to the subform, I make a change on one of the entries (fed by the query that outputs every update made within the last 30 days) and save the file by right-clicking the top of the tab and selecting save. This does NOT create a new blank entry in my table. But going through the main form DOES.

I'm not sure what you mean by "anything in the subformcontrols linkmaster/childfields properties". 9-(

[RuralGuy]

It can be a bit tricky but you need to select the SubFomControl by left clicking on the very top left of the SubFormControl. A handle will appear on the top left. You know you are looking at the SubFormControl when the Data tab has the LinkMasterFields and LinkChildFields properties.

[RuralGuy]

I have to go to a meeting. I'll check in when I get back. Maybe a couple of hours.

[Moridan]

It can be a bit tricky but you need to select the SubFomControl by left clicking on the very top left of the SubFormControl. A handle will appear on the top left. You know you are looking at the SubFormControl when the Data tab has the LinkMasterFields and LinkChildFields properties.

Are SubFormControl, LinkMasterFields, and LinkChildFields exact terms in Access because I cant find any information on them. I couldnt find anything about a "handle" appearing either. Select SubFormControl by left clicking the top left of the SubFormControl? 9-(

[RuralGuy]

Yes "Link Master Fields" and "Link Child Fields" are the property names on the Data tab of the SubFormControl. You have not selected the SubFormControl yet. As I said, it can be tricky.

[Moridan]

Ahhh Ok, got it. Here is what it shows:

Source Object: frmEditUpdateSubform
Link Master Fields: Proj_Short_Title
Link Child Fields: Same
Filter on Empty Master: Yes
Enabled: Yes
Locked: No

[RuralGuy]

"Link Child Fields: Same" or does it have "Proj_Short_Title" in it? I like to be precise.

[Moridan]

"Link Child Fields: Same" or does it have "Proj_Short_Title" in it? I like to be precise.

Link Child Fields: Proj_Short_Title

9-)