Subform GoToNewRecord Issue 1

[maxhugen]

In an unbound form 'horse', I have 2 subforms, horse_list and horse_detail. The recordsource for horse_detail is:

SELECT horse.* FROM horse WHERE horse_id=[Forms]![horse]![horse_list].[Form]![horse_id] Or horse_id Is Null

This is supposed to allow the subform to show the selected record from horse_list, OR a new record.

A button on the main form [Add Horse] tries to move to a new record in horse_detail. However, this is not available, and I can't understand why?

I temporarily added Navigation Buttons to the subform, and it does not show a new record as being available either. However, if I open just the subform (and type in the required [Forms]![horse]![horse_list].[Form]![horse_id]), it is available as expected.

I must be missing something, but it's got me stumped. Can anyone suggest what I'm doing wrong?

MTIA

Max Hugen
Australia

 

[maxhugen]

Hmmm... just realised the subform is not even editable, despite Allow Edits/Deletions/Additions all being enabled!

Max Hugen
Australia

 

[dhookom]

I would check the "Allow Edits/Deletions/Additions" on the main form.

Duane
Hook'D on Access
MS Access MVP

 

[maxhugen]

Oh boy, this is one very red-faced programmer saying: thanks Duane! I must be sleep-working

Max Hugen
Australia